PH33006: ALTER TABLE IN SEGMENTED TABLESPACE RUN JOB MISSING -STA ACCESS(RW) FOR TS BEFORE CREATE TABLE ERROR SQLCODE = -904

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When an ALTER to a table stored in a non-UTS tablespace requires
  one to DROP and CREATE the table, Admin Tool generates
  a WSL with a -STA command to put the tablespace in ACCESS(RO)
  status before unloading the data.  However, the WSL does
  not contain a -STA command after the UNLOAD to put the
  tablespace in ACCESS(RW) status before the CREATE TABLE command.
  As a result, the run job may fail with a SQLCODE = -904 error
  on the tablespace:
  
  
  DSNT408I SQLCODE = -904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED
  BY AN UNAVAILABLE RESOURCE. REASON 00C90080, TYPE OF RESOURCE
  00000200, AND RESOURCE NAME >database.tablespace<
  DSNT418I SQLSTATE   = 57011 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXICTB SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = 125  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'0000007D'  X'00000000'  X'00000000'
  X'FFFFFFFF'
           X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  
  
  Note:  This problem does not occur when the table is in a UTS,
  because in that case the tablespace is dropped and recreated,
  and so the tablespace is automatically in ACCESS(RW).
  
  
  Keywords:  SQLCODE904N
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  Keywords:  SQLCODE904N
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Object Comparison Tool for      *
  *                 z/OS with segmented table spaces.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE -904 is returned when running a *
  *                      work statement list (WSL) that drops    *
  *                      and recreates a table in a segmented    *
  *                      table space.                            *
  ****************************************************************
  Running a WSL for a change that drops and
  recreates a table in a segmented
  table space may result in the following
  error:
  
  ADB7955E DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION
  ADB7955E CAUSED BY AN UNAVAILABLE RESOURCE. REASON
  ADB7955E 00C90080, TYPE OF RESOURCE 00000200, AND
  ADB7955E RESOURCE NAME >database< .>table space<
  

Problem conclusion

• The issue has been resolved.
  
  Search keywords: MSGSDSNT408 SQLCODE904N RSN00C90080
  

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:

  UI74749

Modules/Macros

• ADB2CMT  ADBGAJOB
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI74749

     UP21/04/06 P F104

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.