SAP Note 423566 - DB2/390: Multi-level HLQ for SORT and DATA in REORG jobs

Component : DB2 for z/OS -

Solution : https://service.sap.com/sap/support/notes/423566 (SAP Service marketplace login required)

Summary :
Ensure that all REORG jobs within SAP environments using DB2 on MVS OS390 have their High-Level Qualifier (HLQ) for data and sort workfiles set to single-level. For implementing this, refer to transport protocols mentioned in SAP note 101217 specific to R/3 release types, ensuring alignment with the prescribed sequence. Regular updates of note 101217 may contain further refinements or instructions, so periodic review is advised to maintain system relevance. For specific R/3 releases such as 4.6D and 4.6C, transport codes M5DK000019 and M5CK000040 respectively should be utilized, followed by necessary adjustments in the REORG job skeleton.

Key words :
additional key words db2 mvs os390 db13 db2j reorg datawk01 sorwk01, prerequisites - solution make, high level qualifier, reorg jobs, single-level, sort workfiles, successfully imported, transports mentioned, regularly updated, transport suitable

Related Notes :

324739DB2 z/OS: CCMS transport for 4.6D
217093DB2 z/OS: CCMS transports for 4.6C
101217DB2 z/OS: Overview of transports and corrections
13719Preliminary transports to customers (note for customers)