PI76067: INCOMPLETE DDL GENERATED WHEN MOVING XML TABLESPACE TO A DIFERENT STOGROUP.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When generating DDL to perform an ALTER TABLESPACE command to
  move an XML tablespace from one STOGROUP to another the DDL is
  incomplete as it is missing the "ALTER TABLESPACE dbname.tsname"
  clause.
  

Local fix

• Modify the the ADB2MALT member of the SADBSLIB library.
  Change the following lines:
  
  )SEL &PSUBTYP = PBG
    ALTER TABLESPACE "&DBNAME"."&NAME"
  )ENDSEL
  
  to become
  
  )SEL &PSUBTYP = PBG | &PSUBTYP = XML
    ALTER TABLESPACE "&DBNAME"."&NAME"
  )ENDSEL
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who use panel ADB2 option "SM -         *
  *                 Space Management functions" on an XML        *
  *                 table space.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: The generated batch job is missing      *
  *                      the clause for the ALTER step.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using panel ADB2 option "SM - Space Management
  functions" on an XML table space to move the page set to
  another STOGROUP, the generated batch job is missing
  the following clause for the ALTER step:
  
  ALTER TABLESPACE >dbname<.>tsname<
  

Problem conclusion

• 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:

  UI47320 UI47321

Modules/Macros

•    ADB2MALT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI47320

     UP17/05/19 P F705

• RC10 PSY UI47321

     UP17/05/19 P F705

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.