PM42777: DBVX UNSUCCESSFUL BIND FOR PACKAGE LCNDBVX KO2OM510 FPE@TCO1 'O510_XRKA' ICAT

Obtain the fix for this APAR.

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