DB2-z/OS:CCMS: DB13: DB2 Utilities SHRLEVEL Syntax

June 29, 2009 at 4:13 am

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

  1. 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...
  2. DB2-z/OS:CCMS: DSNACCOR RUNSTATS recommendationsSymptom 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,...
  3. 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,...
  4. 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...
  5. 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,...
  6. 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...
  7. 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....
  8. 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

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 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

Correction instructions are also available for
SAP Basis 7.00 Support Package 17-19

Activation after applying the correction instructions:
To activate the DB13 job template changes, please perform the following steps:
1. Start transaction DB2J.2. Press button Profile.3. Select “Protect utility statement skeletons”.4. Press the Save button to save the profile.5. Press button Profile again.6. Select “Allow SAP to update utility statement skeletons”7. Press the Save button again to save the profile.8. Confirm the warning message.

This procedure sets the version of the DB13 job templates to 0. The changed DB13 job templates will be modified at the next DB13 job execution.
Note: This action replaces the D13 job templates and customer modifications get lost.
Releases lower than SAP Basis 7.00 Support Package 17:
The DB13 job templates can be changed with DB2J. Please edit the following job templates
UTILS:REORG_IXUTILS:REORG_IX_RSTUTILS:REORG_TSUTILS:REORG_TS_RST

and change “SHRLEVEL(CHANGE)” into “SHRLEVEL CHANGE”.

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon]

Leave a Comment