DB2-z/OS:CCMS: DB2 Utility job changes

July 22, 2009 at 1:30 am

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

Symptom
REORG jobs in transaction DB13 alter the primary and secondary space allocation, if the number of extents is greater than four. In addition, REORG and COPY jobs in DB13 are not enabled for remote maintenance.
Other terms
DB2, CCMS, DB13, z/OS, OS/390, DB13, DSNACCMR, PRIQTY, SECQTY, Backup
Reason and Prerequisites
Program deficiencies
Solution
The following changes have been made:
Altering [...]

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 [...]

DB2-z/OS: fast load with load utility and USS fifos

July 7, 2009 at 2:38 am

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

Symptom
This Note only describes the new process of using the load utility with USS fifos. If you are looking for the old fastload process, see Note 1296510.
This Note conatins additional information to the SDN articleSAP Unicode Conversion on DB2 for z/OS – Cookbook. An up-to-date version of the cookbook is appended to this [...]