A fix is available
APAR status
Closed as program error.
Error description
Running ICAT job OMBDssid : DSNX200I +DBVX BIND SQL ERROR USING DB2PM AUTHORITY PLAN=(NOT APPLICABLE) DBRM=FPE@TCO1 STATEMENT=989 SQLCODE=-551 SQLSTATE=42501 TOKENS=DB2PM SELECT SYSIBM.SYSCOLUMNS CSECT NAME=DSNXOSC RDS CODE=-20 DSNT233I +DBVX UNSUCCESSFUL BIND FOR PACKAGE = LCNDBVX.KO2OM510.FPE@TCO1.(O510_XRKA) This is because GRANT SELECT ON SYSIBM.SYSCOLUMNS TO DB2PM; is done later on in RKD2SAM(EXGRssid) and RKD2SAM(PWG1ssid) Add: GRANT SELECT ON SYSIBM.SYSCOLUMNS TO DB2PM; to job OMGRssid.
Local fix
Issue GRANT SELECT ON SYSIBM.SYSCOLUMNS TO DB2PM;
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component: * * - ICAT * **************************************************************** * PROBLEM DESCRIPTION: GRANT SELECT on SYSIBM.SYSCOLUMNS is * * absent in OMGRssid member * * * **************************************************************** * RECOMMENDATION: Apply this PTF * * * **************************************************************** PROBLEM SUMMARY: GRANT SELECT on SYSIBM.SYSCOLUMNS is absent in OMGRssid member PROBLEM CONCLUSION: Add GRANT SELECT on SYSIBM.SYSCOLUMNS to put in OMGRssid member
Problem conclusion
Add GRANT SELECT on SYSIBM.SYSCOLUMNS to put in OMGRssid member KEYWORDS : UNSUCCESSFUL BIND GRANT SELECT ON SYSIBM.SYSCOLUMNS OMGRSSID MEMBER
Temporary fix
Comments
APAR Information
APAR number
PM42777
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
510
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-06-30
Closed date
2011-08-02
Last modified date
2011-09-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK70421
Modules/Macros
KD261SDB
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R510 PSY UK70421
UP11/08/04 P F108
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":"5.1.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":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 September 2011