Solution : https://service.sap.com/sap/support/notes/103682 (SAP Service marketplace login required)
Summary :
This SAP Note details handling storage attributes of tables and indexes, managing table/index conversion and creation within R/3 systems on DB2/390 for releases up to 4.0B. Post 4.5A, alterations in DB2 storage attribute management and SE14 transactions were implemented. It provides instructions for proper designation of storage parameters using SE14, techniques to prevent conversion errors, and steps to alter primary keys and indexes accordingly. Emphasizes database object relationships and prerequisites while utilizing specific DB, user-defined, and default settings to maintain system efficiency and integrity.
Key words :
save storage parameters delete index, 4k-pagesize -> 32k-pagesize, partitioned tables manual actions, multi-table-tablespace location, separate single-table tablespace, existing single-table tablespace, db parameters -> save, changed object ids, dialog box 'request, import ddic corrections
Related Notes :
| 529178 | DB2/390: Table conversion with COMPRESS |
| 162250 | DB2/390: DDIC corrections (3.0F,3.1H,3.1I,4.0B) |
| 96515 | DB2/390: Isolating large tables and table clusters |
| 78354 | DB2/390: Conversion of partitioned tables |
| 13719 | Preliminary transports to customers (note for customers) |