PH50508: ERROR MESSAGE ADB7955E FOR WARNING SQLCODE +162 IN ADBTEP2 OUTPUT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• User is running an apply with ADBTEP2 to create a foreign key
  and it issues ADB7955E error message on SQLCODE = 162.
  Description of ADB7955E states: Processing fails and stops This
  was not the case, the apply job ended with CC=4.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using ADBTEP2, the user receives   *
  *                      error message ADB7955E even though the  *
  *                      job receives SQL code +162 (a warning). *
  *                      The user expected warning message       *
  *                      ADB7954W to be issued instead.          *
  ****************************************************************
  The user runs an apply job with ADBTEP2 to create a foreign key
  and receives a +162 SQL code warning that a table space is in
  check pending. Db2 Admin Tool issues an error message,
  ADB7955E which is a generic ADMIN error message, along with
  that warning. The user expected a warning message, such as
  ADB7954W which is the generic ADMIN warning message,
  instead.
  

Problem conclusion

• The problem has been resolved.
  

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

• ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI90392

     UP23/02/10 P F302

• RD10 PSY UI90393

     UP23/02/09 P F302

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.