PI46428: DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT RESOLVE CORRECTLY IMPLICIT DATABASE NAME IN THE RECOVER CHANGE JOB

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS does not resolve correctly
  implicit database name in the RECOVER CHANGE job
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use Change Management           *
  *                 to recover the change.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the 'ALT Alter Table'        *
  *                      (ALT) function to alter a table in      *
  *                      an implicitly created database to       *
  *                      drop/recreate the table, register       *
  *                      it as a change, analyze the change,     *
  *                      run the change, and finally recover     *
  *                      the change, the 'DB2 -START' command    *
  *                      is executed before the UNLOAD           *
  *                      statement in the recover job and        *
  *                      references an incorrect database        *
  *                      name which will result in the           *
  *                      following error because the             *
  *                      database name has been changed          *
  *                      to another random value by DB2          *
  *                      after recreating the table              *
  *                      and running the original change         *
  *                                                              *
  *                      ADB5044I *** INPUT STATEMENT:           *
  *                      -STA DB(>dbname<) SPACENAM              *
  *                      (>tsname<) ACCESS(RO);                  *
  *                      ADB5060I *** Implicit commit            *
  *                      performed, number:                      *
  *                                                              *
  *                         -STA DB(>dbname<) SPACENAM           *
  *                      (>tsname<) ACCESS(RO)                   *
  *                                                              *
  *                      DSNT301I  #SSID- INVALID DATA           *
  *                      BASE >dbname<                           *
  *                      DSN9022I  #SSID- DSNTDDIS               *
  *                      'START DATABASE' NORMAL                 *
  *                      COMPLETION                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following error is seen when attempting to register,
  analyze, run and recover a table after an alter:
  
  DSNT301I  #SSID- INVALID DATA BASE >dbname<
  DSN9022I  #SSID- DSNTDDIS 'START DATABASE'
  NORMAL COMPLETION
  
  because the database name has been changed to another random
  value by DB2 after recreating the table and running the
  original change.
  

Problem conclusion

• Program has been changed to generate the new ADMIN START
  statement seen below in the recover job when unloading the
  table which was in an implicitly created database:
  
  ADMIN START FOR TABLE >table-qual<.>table-name<
   CLONE  ACCESS(RO)
  
  Program has also been changed to parse the new ADMIN
  START statement and transform it to the 'DB2 -START'
  command with the retrieved database name and table space
  name from the DB2 catalog at run time.
  

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:

  UI33457 UI33458

Modules/Macros

•    ADBGAJOB ADBTEPI  ADBTEP2  ADB2PA5  ADB2PA6
  ADB2WCL  ADB2WIN
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI33457

     UP15/12/04 P F512

• RB20 PSY UI33458

     UP15/12/04 P F512

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.