Solution : https://service.sap.com/sap/support/notes/593469 (SAP Service marketplace login required)
Summary :
SAP Note addresses issues with tablespaces impacting utilities, system exports, and unauthorized table space creation in TEMP databases. It clarifies types of databases (TEMP and work file) and their use in SAP environments like BW and CCMS that manage temporary data differently to enhance performance. Despite systemic permissions for SAP's OS/390 group ID, authorizations might lack for creating necessary tablespaces, causing SQLCODE -551 errors. Solutions include modifying job control language in migrations and manual tablespace creation for specific SAP group IDs, ensuring operational continuity and efficiency.
Key words :
saps os/390 group id <schema>, transaction db13 include code, kernel patch level xxx, db2 data sharing group, system defined db2 objects, query intermediate result tables, declared global temporary tables, newest maintenance level, data sharing member, official ibm documentation
Related Notes :
| 776547 | DB2/zOS: DB13 upload with stored procedure DSNACCDS |
| 765983 | DB2/zOS: Reducing number of DSNACCOR REORG recommendations |
| 717935 | DB2/zOS: FTP replacement by Stored Procedures |
| 507824 | DB2/390 V7: Real Time Statistics and DSNACCOR |
| 427748 | DB2-z/OS: CCMS corrections (6.10, 6.20, 6.40, 7.x) |
| 324739 | DB2 z/OS: CCMS transport for 4.6D |
| 217093 | DB2 z/OS: CCMS transports for 4.6C |
| 101217 | DB2 z/OS: Overview of transports and corrections |
| 13719 | Preliminary transports to customers (note for customers) |