Basis Errors and Solutions

DB2-z/OS:CCMS: DSNACCOR RUNSTATS recommendations

July 3, 2009 at 5:15 am

[CCMS] [DB13] [DB2] [db2 runstats] [DSNACCOR] [DSNACCOX] [OS/390] [recommendations] [REORG] [runstats] [z/OS]

DB2-z/OS:CCMS: DB13: DB2 Utilities SHRLEVEL SyntaxSymptom 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...
DB2-z/OS:CCMS: DSNDB01 excluded when calling DSNACCMOSymptom 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,...
DB2-z/OS:CCMS: DB2 Utility job changesSymptom 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...
DB2-z/OS:CCMS: Mapping Table for REORG not found (DSNU056I)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...
DB2-z/OS: CCMS corrections (6.10, 6.20, 6.40, 7.x)Symptom This note describes DB2 for z/OS-specific corrections and advance developments for the CCMS for R/3 Releases 6.10, 6.20, 6.40 and 7.00. Other terms DB2, z/OS, ABAP, transport, correction, fix, advance development,...
DB2-z/OS:CCMS: Enabling Sysplex MonitorSymptom The new OS07(n) needs to query the connected SAP system via RFC to find out details about the associated DB host. Other terms DB2, z/OS, CCMS, Sysplex Monitor, OS07, Configuration, DB...
DB2-z/OS:CCMS: Jobhead Correction Doesn’t WorkSymptom The DBA Cockpit for DB2 for z/OS offers the function ‘Homogeneous System Copy: Jobhead Correction’. When pressing the pushbutton ‘Update the Jobhead’ no action takes place and the jobhead remains unchanged....
DB2-z/OS:CCMS: Incorrect Memory Values in Sysplex MonitorSymptom The Sysplex Monitor and the respective OS07 display show incorrect values for Storage Frames Available and Storage Frames online. Other terms DB2 z/OS CCMS Sysplex Monitor Storage Frames Reason and Prerequisites...

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 Basis 7.00 Support Package 20SAP Basis 7.01 Support Package 5SAP Basis 7.02 Support Package 2SAP Basis 7.10 Support Package 9SAP Basis 7.11 Support Package 4

The change is also delivered for 6.40 with Transport SAPK640OC2