PI12371: PANEL ADB21S GEN DOES NOT GENERATE RELATED TABLESPACE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The Administration Tool for DB2 z/OS GEN Function does not
  generate related Tablespace from Panel ADB21S.
    CREATE TABLESPACE BASE_TS
    CREATE TABLE dbname.BASE_TS
      IN dbname.BASE_TS
    CREATE TABLE dbname.REL_TS
      IN dbname.REL_TS
    ALTER TABLE dbname.BASE_TS
    USE HISTORY TABLE dbname.REL_TS;
  

Local fix

• Run GEN on Database from Panel ADB21D
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Generate (GEN) function to  *
  *                 generate a base temporal table space         *
  *                 which includes all history objects.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Admin Tool's GEN function does  *
  *                      not generate a related history table    *
  *                      space from panel ADB21S 'Table          *
  *                      Spaces', the following statements       *
  *                      are generated, and the DDL for the      *
  *                      creation of the history table space     *
  *                      is missing:                             *
  *                                                              *
  *                        CREATE TABLESPACE BASE_TS             *
  *                        CREATE TABLE dbname.BASE_TS           *
  *                          IN dbname.BASE_TS                   *
  *                        CREATE TABLE dbname.REL_TS            *
  *                          IN dbname.REL_TS                    *
  *                        ALTER TABLE dbname.BASE_TS            *
  *                        USE HISTORY TABLE dbname.REL_TS;      *
  *                                                              *
  *                      If the table space is not created, the  *
  *                      user will experience a SQLCODE=-204 /   *
  *                      SQLCODEN204 error:                      *
  *                                                              *
  *                      SQLCODE = -204, ERROR:                  *
  *                      >tablespace_name<                       *
  *                      IS AN UNDEFINED NAME                    *
  *                      SQLSTATE=42704                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  History table space is not generated when performing a GEN on
  the base temporal table space.
  

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:

  UI17022 UI17023

Modules/Macros

• ADB2REP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI17022

     UP14/04/16 P F404

• RB10 PSY UI17023

     UP14/04/16 P F404

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.