Program RSCROSS10, Performance problems with job EU_REORG

July 14, 2009 at 5:55 am

[] [] [] [] [] [] [] [] []

Symptom
The job EU_REORG has a long runtime in STEP 10 in the program RSCROSS10.
Program RSCROSS10 cleans up the incorrect entries in the where-used list index. This mainly involves deleting the entries in the where-used list tables WBCROSSGT, CROSS, and WBCROSSI.
Since these tables are very large, the program RSCROSS10 may run for a very long [...]

DB2-z/OS:CCMS: Mapping Table for REORG not found (DSNU056I)

July 13, 2009 at 7:05 am

[] [] [] [] [] [] [] [] [] []

Symptom
The execution of Online REORG fails with the following error message:
DSNU056I -D6K0 117 09:26:04.97 DSNUGMAP – TABLE ‘SAPBRE.QT000101′ NOT FOUND
This means, that the mapping table, which is necessary for Online Reorg, is not created in the database.
Other terms
DB2, CCMS, DB13, z/OS, OS/390, DB2 Utility, DB13
Reason and Prerequisites
The Online Reorg ABAP program tries to create [...]