Solution : https://service.sap.com/sap/support/notes/1021551 (SAP Service marketplace login required)
Summary :
During system copy or Unicode conversion, it's essential to maintain DB2-specific attributes such as table partitioning, bufferpool assignment, DSSIZE, and compression settings. This SAP Note provides guidance on preserving these attributes using the sapinst/R3load method. For non-unicode systems, manual settings are dictated, while unicode systems apply compression by default. The updated copy process additionally retains certain index features and ordering that don’t usually conform to the data dictionary definitions. Note that SAP NetWeaver 2007 and DB2 v9 aren't supported. Required support packages include SAPKB64017 and SAPKB70008. Implementation involves applying support package stacks and generating SQL files through the SMIGR_CREATE_DDL report.
Key words :
netweaver 2004 support package stack 21 netweaver 2004s support package stack 13 sap netweaver process integration, /os partitioning r3load r3loadctl system copy unicode conversions bufferpool reason, preserve db2 storage parameter settings, support sap netweaver 2007, standard system copy process, improved system copy procedure preserves, copy database specific table attributes, support package stacks, sap basis support packages, bufferpool assignment dssize compress
Related Notes :
| 1586409 | |
| 1296510 | DB2-z/OS: fast load with load utility BatchPipes/MVSDS |
| 1062976 | DB2-z/OS: fast load with load utility and USS fifos |