PH56416: WHEN DROP/CREATE OF A TABLE WITH TRIGGERS IS GENERATED, RO ON TABLESPACE PREVENTS CREATE OF TABLE AFTER DROP

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a drop/create of a table with Triggers is generated, RO
  status on tablespace prevents create of table after drop. When
  attempting to create the tables failed with the following error:
  
  ADBT050E SQLERROR ON CREATE COMMAND, EXECUTE FUNCTION. ADB7953I
  SQL statement (partial):
  ADB7955E SQL error:
  ADB7955E DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION
  CAUSED BY AN ADB7955E UNAVAILABLE RESOURCE. REASON 00C90080,
  TYPE OF RESOURCE 00000200, AND
  ADB7955E RESOURCE NAME ARRX2013.TSU87 ADB7955E DSNT418I SQLSTATE
  = 57011 SQLSTATE RETURN CODE
  
  
  The tablespace needs to be manually reset to RW status in order
  for the job to continue.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The user creates a change that          *
  *                      requires a drop and create of a         *
  *                      table that has triggers. When the       *
  *                      user runs the change, a -904 error      *
  *                      occurs, because the table space is      *
  *                      still in a read-only state.             *
  ****************************************************************
  A change is made to a table with triggers, and the change
  involves a drop and create of the table.  When the change
  is run, the user receives an RC=8 with the following error:
  
  ADBT050E SQLERROR ON CREATE COMMAND, EXECUTE FUNCTION.
  ADB7953I SQL statement
  ADB7955E SQL error:
  ADB7955E DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL
  EXECUTION CAUSED BY AN ADB7955E UNAVAILABLE RESOURCE.
  REASON 00C90080, TYPE OF RESOURCE 00000200, AND
  ADB7955E RESOURCE NAME TS1.TB1
  ADB7955E DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
  
  The error occurs, because the table space that holds the
  table is still in read-only mode, which was set before the
  unload of the table.
  

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:

  UI94665 UI94666

Modules/Macros

• ADBGAJOB
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI94665

     UP23/12/01 P F311

• RD10 PSY UI94666

     UP23/12/01 P F311

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.