PK54798: RH FUNCTION RETURNS -134 IN DB2V7 DUE TO HEX(CD.COLVALUE)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool, when function CDI then RH then
  I is issued, when using DB2v7, an SQLCODE -134 is returned.
  Additional Symptons: MSGSQLCODE -134
  sqlcode134 sqlcoden134 sqlcodem134 COLVALUE
  

Local fix

• Edit SQL prior to issue and specify (CD.COLVALUE = X'8003')
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2  Admin Tool Version who use     *
  *                 the RH command on panel  ADB21CDI in DB2     *
  *                 Version 7.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: RH line command on panel ADB21CDI in    *
  *                      DB2 V7 results in SQLCODE -134.         *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• The problems have been fixed.
  

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:

Modules/Macros

•    ADB21CDI
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK33038

     UP08/01/25 P F801

• R720 PSY UK33039

     UP08/01/25 P F801

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.