A fix is available
APAR status
Closed as program error.
Error description
The ISPF Online Monitor does not show the program name and the SQL statement in field "SQL Statement and Program" on the "Thread Detail" panel DGOMTPSM. Only N/P is displayed. This occurs under the following conditions: - The ISPF Online Monitor is running as Client of the PEServer - DB2 security is controlled by RACF and not by GRANTs - The RACF option "LIST OF GROUPS" is activated - The primary authid (TSO userid) has no MONITOR2 authority - Only a secondary authid has MONITOR2 authority
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component: * * - ISPF Monitoring dialogs * **************************************************************** * PROBLEM DESCRIPTION: The ISPF Online Monitor does not show * * the program name and the SQL statement * * in field "SQL Statement and Program" * * on the "Thread Detail" panel DGOMTPSM. * * Only N/P is displayed. * * This occurs under the following * * conditions: * * - The ISPF Online Monitor is running * * as Client of the PEServer * * - DB2 security is controlled by RACF * * and not by GRANTs * * - The RACF option "LIST OF GROUPS" * * is activated * * - The primary authid (TSO userid) has * * no MONITOR2 authority * * - Only a secondary authid has MONITOR2 * * authority * * * **************************************************************** * RECOMMENDATION: Apply this PTF * * * **************************************************************** PROBLEM SUMMARY: The ISPF Online Monitor does not show the program name and the SQL statement in field "SQL Statement and Program" on the "Thread Detail" panel DGOMTPSM. Only N/P is displayed. This occurs under the following conditions: - The ISPF Online Monitor is running as Client of the PEServer - DB2 security is controlled by RACF and not by GRANTs - The RACF option "LIST OF GROUPS" is activated - The primary authid (TSO userid) has no MONITOR2 authority - Only a secondary authid has MONITOR2 authority PROBLEM CONCLUSION: The ISPF Online Monitor shows the program name and the SQL statement if DB2 security is controlled by RACF only.
Problem conclusion
The ISPF Online Monitor shows the program name and the SQL statement if DB2 security is controlled by RACF only. KEYWORDS: ISPF-OLM SQL-STMT RACF MONITOR2
Temporary fix
Comments
APAR Information
APAR number
PM05768
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
420
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-01-22
Closed date
2010-01-28
Last modified date
2010-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK53930
Modules/Macros
DGOVPMOV
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R420 PSY UK53930
UP10/01/30 P F001
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 February 2010