Solution : https://service.sap.com/sap/support/notes/207985 (SAP Service marketplace login required)
Summary :
During the generation of REORG TABLESPACE jobs in SAP systems, the calculation of Secondary Quantity for DATAWKnn and SORTWKnn data sets is found to be incorrect, leading to job failures with ICE046A error when handling large tablespaces. This issue stems from improper size parameter estimation for sort data sets. The recommended solution involves importing specified transports into the R/3 System as outlined in SAP Note 101217, ensuring orderly sequence and regular updates from the note to maintain system integrity. Additionally, adopt transport settings as per Note 13719 for specific releases such as 3.1I under transport KDGK000152.
Key words :
error message ice046a sort capacity exceeded - record count, additional key words db2, work data sets datawknn, sort data sets, job terminates due, current maintenance level, reorg tablespace jobs, prerequisites error, reorg tablespace, secondary quantity
Related Notes :
| 101303 | DB2/390: Transports for 3.1I |
| 101217 | DB2 z/OS: Overview of transports and corrections |
| 13719 | Preliminary transports to customers (note for customers) |