PM00038: SQLCODEN805 ADB8SQL RENAME AS SADBSAMP ADBBIND SAYS BIND PACKAGE(ADBL) **** V8 ONLY ****

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS SADBSAMP member ADBBIND
  shows:
  BIND PACKAGE(ADBL)      /*      ****  V8 ONLY  ****
       MEMBER(ADB8SQL)    /*      ****  V8 ONLY  ****
       QUALIFIER(ADB)     /*      ****  FAILS ON V7 ****
       VALIDATE(BIND)     /*  THE QUALIFIER SHOULD MATCH THE OWNER
       ISOLATION(CS)      /*  OF THE CHECKPOINT TABLE ADBCHKPT
       RELEASE(C) -
       SQLERROR(CONTINUE) -
       ENCODING(EBCDIC)  -
       EXPLAIN(NO)
  which resulted in a SQLCODE -805 when using the RENAME feature
  on a DB2 9 NFM / New Function Mode subsystem.
  

Local fix

• Bind the BIND PACKAGE(ADBL) MEMBER(ADB8SQL)
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 who use the ADBBIND SAMP LIBRARY MEMBER TO   *
  *                 BIND ADMIN PACKAGES AND PLANS.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: For PACKAGE ADB8SQL:                    *
  *                      The SAMP LIBRARY MEMBER ADBBIND used    *
  *                      comments:                               *
  *                      /*      ****  V8 ONLY  ****          */ *
  *                      They were changed to:                   *
  *                      /*      **** DB2 V8 OR HIGHER ****   */ *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The SAMP library JOB ADBBIND was updated with the correct
  comments.
  

Problem conclusion

• The problem has 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

•    ADBBIND
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK53038

     UP09/12/25 P F912

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.