Basis Errors and Solutions

DB2-z/OS:CCMS: Enabling Sysplex Monitor

June 26, 2009 at 11:44 pm

[CCMS] [Configuration] [DB] [DB2] [enabling] [enabling devices] [host] [monitor] [OS07] [sysplex] [z/OS]

1. 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...
2. 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...
3. 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...
4. 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,...
5. 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,...
6. 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....
7. 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,...
8. 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...

Symptom

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 host
Reason and Prerequisites

The following new function modules are delivered:
STU3_ZOS_GET_CONFIGSTU3_ADMIN_GET_SYSPLEX_NAMESolution

Import one of the following support packages:
SAP Basis 7.11 Support Package 3SAP Basis 7.10 Support Package 8SAP Basis 7.01 Support Package 4SAP Basis 7.00 Support Package 19.

Note: Please make sure that the IBM PTF
PK73268: RETURN SYSPLEX NAME IN XML DOCUMENT RETURNED BY SYSPROC.GET_SYSTEM_INFO

is installed in the respective DB2 Subsystem.
In case the PTF is not installed, as a workaround you can specify the Sysplex Name by inserting the following line into table DB2MISC:
(’RMF_SYSPLEX’, , )
where remote_dbcon is the database connection defined in the DBA Cockpit for the respective DB2 Subsystem (blank for the local system).

Permalink