PI79233: DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME DB2DVLP..EQQDPX2C. AFTER APPLYING UI43560 AND OTHER PTFS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After applying HIPER PTFS UI43560 UI44901 and others, a REPLAN
  or CP EXTEND job fails when using the history function
  (DB2HISTORY parameter). Messages received include:
  DSNT408I SQLCODE = -805, ERROR:  DBRM OR PACKAGE NAME
  DB2DVLP..EQQDPX2C.
  1A3B6E9C05F0CBD4
           NOT FOUND IN PLAN EQQHP002. REASON 03
  DSNT418I SQLSTATE   = 51002 SQLSTATE RETURN
  CODE
  DSNT415I SQLERRP    = DSNXEPM SQL PROCEDURE DETECTING
  ERROR
  DSNT416I SQLERRD    = -251  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'FFFFFF05'  X'00000000'  X'00000000'
  X'FFFFFFFF'  X'0000
           X'00000000' SQL DIAGNOSTIC
  INFORMATION
  
  A check of the TOKEN values shows:
  DBRM:
  EQQ.SEQQMISC(EQQDPX2C) con token is 030952710116350F
  
  DB2 SYSPKAGE:.
  DSN_DEFAULT_COLLID_EQQHP002 EQQDPX2P 030952710116350F
  
  LOAD MODULE:
  EQQ.SEQQLMD0(EQQDNTOP) con token is 1A3B6E9C05F0CBD4.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All IWS for z/OS 930 users running the       *
  *                 IWSz DB2 History feature.                    *
  *                 FUNCTION=HIST                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Error DBRM or PACKAGE name not found    *
  *                      (EQQDPX2C) with SQLCODE=-805 issued     *
  *                      during Replan or Extend.                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  SQLCODE=-805 issued during CP replan or extend,
  with DB2 History feature enabled and PI62521 applied.
  

Problem conclusion

• DBRM and SQL modules have been recompiled to avoid a mismatch
  in the compiling date.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UI46953 UI46952

Modules/Macros

•    EQQDBDEF EQQDBDE2 EQQDPX2C EQQDPX2P EQQGSG2O
  EQQGSL2P EQQMC2CM
  

Fix information

• Fixed component name

  TIV WRKLD SCHD

• Fixed component ID

  5697WSZ01

Applicable component levels

• R930 PSY UI46952

     UP17/05/23 P F705 Ž

• R932 PSY UI46953

     UP17/05/23 P F705 Ž

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.