PM32315: NEW FUNCTION APAR PM24212 MISSING ++HOLD ACTION SAMPLE TO INFORM CUSTOMERS OF ADBCHU02 SAMPLE ADBTEP 11/02/09 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS APAR PM24212 did not
  include ++HOLD information about the sample library member
  ADBCHU02 resulting in the BIND for program ADBTEP2
  failing:
  DSNX200I  .aaaa BIND SQL ERROR
  
             USING aaaaaaa AUTHORITY
  
             PLAN=(NOT APPLICABLE)
             DBRM=ADBTEP2
  
             STATEMENT=12346
  
             SQLCODE=-206
  
             SQLSTATE=42703
  
             TOKENS=DECFRND
  
  DSNT233I  .aaaa UNSUCCESSFUL BIND FOR
  
             PACKAGE = DB2T.ADBL.ADBTEP2.(V10.1.0.aaaaaaa)
  In addition the comments in member ADBCHU02 reference
  ADBCHU11.
  .
  Additional symptoms: sqlcoden206 sqlcode206
  

Local fix

• Review the sample library members and follow the appropriate
  instructions contained within them.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS 10.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Incorrect job name and comment in       *
  *                      the SAMP(ADBCHU02).                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Incorrect job name and comment in the SAMP(ADBCHU02).
  

Problem conclusion

• Job name and comment corrected to match member name.
  

Temporary fix

• *********
  * HIPER *
  *********
  REVIEW THE SAMPLE LIBRARY MEMBERS AND FOLLOW THE APPROPRIATE
  INSTRUCTIONS CONTAINED WITHIN THEM.
  

Comments

APAR Information

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

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

  UK65311

Modules/Macros

•    ADBCHU02
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK65311

     UP11/03/04 P F103 ®

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.