PK47974: Consistency of bind for customer using DB2 package versioning 07/07/03 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Consistency of bind for customer using DB2 package versioning.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   PE Server                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Consistency of bind for customer        *
  *                      using DB2 package versioning            *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF.                              *
  ****************************************************************
  Consistency of bind for customer using DB2 package versioning
  Users will experience the following after starting the server
  when UK25927 was applied:
  FPEV5016I  DB2B REQUIRED DBRM DGO@SP NOT BOUND. BINDING IT
  FPEV5004S  DB2B DATABASE UPDATE FAILED. SEE JOB LOG FOR DETAILS
  FPEV5002I  DB2B PWH IS STOPPING
  REQUIRED DBRM DGO@SP NOT BOUND. BINDING IT
  ****************************************************************
  ********
  *******
  DB2 SQL operation failed:
  SQL code ............. : - 805
  Detecting module ..... : DSNXEPM
  PM Server function ... : DGOZSP
  SQL state ............ : 51002
  SQL error message .... :
  ---+
  | DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME
  USEBSX01DB2B..DG-
  |
  | O@SP.180F08E71844E866 NOT FOUND IN PLAN DB2PM. REASON 03 |
  | DSNT418I SQLSTATE = 51002 SQLSTATE RETURN CODE |
  | DSNT415I SQLERRP = DSNXEPM SQL PROCEDURE DETECTING ERROR |
  | DSNT416I SQLERRD = -250 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
  |
  | DSNT416I SQLERRD = X'FFFFFF06' X'00000000' X'00000000' | etc
  etc
    User action .......... :
     +----------------------------------------------------
     | DB2 BIND FOR THIS PACKAGE FAILED. CHECK THE SYSTEM
     | OUTPUT OF THE CORRESPONDING BIND JOB FOR ERRORS
     | AND CORRECT THEM. THEN RESTART THE PM SERVER.
     +----------------------------------------------------
   ********************************************************
   DATABASE UPDATE FAILED. SEE JOB LOG FOR DETAILS
   PWH IS STOPPING
  

Problem conclusion

•  Apply PTF when available. This will resolve
  the problem where the DBRM provided in ptf UK25927 were
  incorrect
  

Temporary fix

Comments

• Consistency established (DBRM / MODULE)
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

  PK47721

• APAR is sysrouted TO one or more of the following:

  UK26647

Modules/Macros

•    DGOVDB2I DGOVDB2S DGOVWRPA DGOVWRP2 DGOVWR2C
  DGOYMAIN DGOYXPLC
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK26647

     UP07/07/04 P F707 Ø

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.