PI22422: DB2 ADMINISTRATION TOOL FOR Z/OS WHEN RUNNING WSL RESULTED FROM ALTER TABLE MISSES START TS IN RW MODE BEFORE CREATE TB

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• B2 Administration Tool for z/OS when running WSL resulted
  from ALTer table misses START TS in RW mode before CREATE TB
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who alter a table that needs a DROP /   *
  *                 CREATE and the table name is a reserved      *
  *                 word.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When altering a table whose name is a   *
  *                      reserved word, the change causes the    *
  *                      table to be dropped and recreated       *
  *                      when specifying 'Yes' for the 'As work  *
  *                      statement list' option on panel         *
  *                      ADBPALT 'ALTER - Build Analyze and      *
  *                      Apply Job'.  The job failed to run the  *
  *                      Work Statement List (WSL) and fails     *
  *                      with a Return Code 8 / RC=8 and a       *
  *                      SQLCODE = -904 / SQLCODEN904:           *
  *                                                              *
  *                      SQLCODE = -904, ERROR:                  *
  *                        UNSUCCESSFUL EXECUTION                *
  *                        CAUSED BY AN   UNAVAILABLE            *
  *                        RESOURCE. REASON 00C90080,            *
  *                        TYPE OF RESOURCE 00000200, AND        *
  *                        RESOURCE NAME tablespace-name         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 Admin will put the table space of a table into Read-Only
  (RO) status before dropping the table, and should put the
  table space back into Read-Write (RW) status before creating
  the table.  Instead, DB2 Admin does not generate the DB2
  command to put the table space back into RW status if the table
  name is a reserved word with double quotes, and fails with a
  SQLCODE=-904 / SQLCODEN904.
  

Problem conclusion

• The problem has been resolved. The table space is put back into
  Read-Write (RW) status before creating the table.
  
  The previously defined Work Statement List (WSL) will need to
  be regenerated to generate the following DB2 command:
  
  '-STA DB(db_name) TS(ts_name)'.
  

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:

  UI21541 UI21542

Modules/Macros

•    ADBGAJOB
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI21541

     UP14/09/24 P F409

• RB10 PSY UI21542

     UP14/09/24 P F409

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.