Symptom
You want to create the service SQL to extract the current SQL query scenario.
Other terms
DB2, OS/390, z/OS, PLI8, DSNPLI8
Reason and Prerequisites
To reproduce problems in the area of the DB2 optimizer, you must extract and copy the database objects that are involved and the related database statistics. You can use the service SQL to [...]
Symptom
DB13 jobs exclude DB2 directory table spaces (DSNDB01) from RUNSTATS, REORG and COPY when stored procedure DNSACCMO is used to call the DB2 utilities.
Other terms
DB2, CCMS, DB13, z/OS, OS/390, RUNSTATS, REORG, COPY
Reason and Prerequisites
Program error
Solution
Import one of the following Support Packages:
SAP Basis 7.00 Support Package 20SAP Basis 7.01 Support Package 5SAP Basis 7.02 Support [...]
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 [...]
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 [...]
Symptom
Latest News
As of7-Jul-2009a new version of RSDB2FIX is available as an attachment (SAPK34POSN.CAR) to this note.Attention:This transport should only be applied for Releases = 6.10 apply the highest Basis Support Package listed in this note.
Short Description
It can be time-consuming to check whether all required Program Temporary Fixes (PTF) listed in SAP Notes [...]
Symptom
When computing RUNSTATS recommendations, the stored procedure DSNACCOR does not take into account, if last RUNSTATS time is older than last REORG time.
Other terms
DB2, CCMS, DB13, z/OS, OS/390, RUNSTATS, REORG, DSNACCOR, DSNACCOX
Reason and Prerequisites
Programm deficiency
Solution
A change in the ABAP code can compensate the lack of functionality in DSNACCOR.
Import one of the following Support Packages:
SAP [...]
Symptom
The DB13 job templates to call DB2 Utilities contain a wrong syntax for SHRLEVEL. The value of SHRLEVEL is accidentally enclosed in brackets. This prevents the fix from IBM APAR PK87122 from being effective.
Other terms
DB2, CCMS, DB13, z/OS, OS/390, DB13, DSNACCMO, REORG PART, NPI
Reason and Prerequisites
Programm error
Solution
Import one of the following Support Packages:
SAP [...]