PH30132: EXTENDED SCHEMA SUPPORT AND INCLUDE PARENT OBJECTS FOR GEN AND MIGRATE; ADB1970W ADB1971S USING REP LINE CMD

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR includes enhancements to support an extended schema
  concept by allowing display, navigation or generation of valid
  schema objects. This APAR also adds support to include parent
  objects (database and table space) for tables and table spaces
  when generating DDL or using the MIGRATE function.
  
  In addition, when using the REP line command on an object during
  catalog navigation, for example on a table space on ADB21S, the
  generated JCL may be missing the ACCEPT_FL parameter in the IN
  DD used to call program ADB2GEN. As a result the following
  messages may appear (for example):
  
  ADB1970W Db2 function level 504 is tolerated but not supported
  by this function.
  New attributes or objects for this Db2 function level might not
  be handled or displayed correctly.  The maximum supported
  function level is 501.
  
  ADB1971S To continue using this unsupported function level, you
  must accept the risk. Specify the "Max Db2 function level
  accepted" on the Admin Defaults panel or batch parameter
  ACCEPT_FL='504'in the options for this function.
  
  Keywords: ADB21; ADB21H; ADB2GEN; ADB2GENS; ADBP8MG; ADB2REP;
  ADB2REP6; ADB2GENB; ADB2REPB; msgadb1970w; msgadb1971s
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides enhancements to      *
  *                      extend the schema concept by allowing   *
  *                      display, navigation, or generation      *
  *                      (by the GEN feature) of valid schema    *
  *                      objects. Support is also added to       *
  *                      include parent objects                  *
  *                      (database and table space) for tables   *
  *                      and table spaces when generating DDL.   *
  *                                                              *
  *                      Changes are in the following            *
  *                      areas:                                  *
  *                                                              *
  *                      1. Catalog Navigation                   *
  *                      2. GEN                                  *
  *                      3. Migrate                              *
  ****************************************************************
  The following enhancements support the extended schema concept
  and including parent objects for tables and table spaces:
  
  1. Catalog Navigation
  
  A new selection criteria "Schema" is added on panel
  ADB21 'System Catalog'
  that allows filtering on valid schema object types.
  Additional columns are added on panel ADB21H 'Schemas' to
  display the number of tables, indexes, views and aliases, which
  provides a more complete view of schema objects.
  A new line command 'H' (Show schema) is added for valid schema
  object types on following panels:
  ADB21A - Alias
  ADB21E - User defined data type
  ADB21F - Functions
  ADB21H - Trigger
  ADB21O - Stored procedure
  ADB21PM - Column mask and Row permission
  ADB21Q - Sequence
  ADB21VV - View
  ADB21X - Index
  ADB21T - Table
  
  2. GEN
  
  Existing GEN options panels ADB2GEN, ADB2GENS and ADB2GEN6
  are consolidated into one single new panel ADB2GENB.
  Existing batch report options panels ADB2REP and ADB2REP6
  are consolidated into one single new panel ADB2REPB.
  New options 'CREATE parent DATABASE' and 'CREATE parent
  TABLESPACE' to generate DDL for parent objects for a table
  (table space and database) and table space (database) have
  been added on the GEN options panel ADB2GENB.
  A new GEN request type 'XS' is added that will help generate
  complete lists of valid schema objects.
  A new GEN request parameter 'INCLUDE' has been added for
  'TB' and 'TS' request types.
  
  3. Migrate
  
  New options 'CREATE parent DATABASE' and 'CREATE parent
  TABLESPACE' to include parent objects for table
  (table space and database) and table space (database) have
  been added on the GEN options for MIG panel ADBP8MG;
  

Problem conclusion

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:

  010PC2Ÿ UI73298

Modules/Macros

• ADB21    ADB21A   ADB21D   ADB21E   ADB21F   ADB21G   ADB21H
  ADB21J   ADB21O   ADB21PM  ADB21Q   ADB21S   ADB21T   ADB21TSE
  ADB21VV  ADB21X   ADB21Y   ADB28M   ADB2AN   ADB2ARL  ADB2CM1
  ADB2CM2  ADB2CM3  ADB2CME  ADB2CMF  ADB2CMP  ADB2CMR  ADB2CMS
  ADB2CMT  ADB2CMU  ADB2DEP  ADB2GEN  ADB2GEN2 ADB2GEN6 ADB2GENA
  ADB2GENB ADB2GENS ADB2GENX ADB2RE   ADB2REE  ADB2REG  ADB2REH
  ADB2REM  ADB2REP  ADB2REP6 ADB2REPB ADB2REPS ADB2RER  ADB2RES
  ADB2RET  ADB2REU  ADB2REY  ADB2REZ  ADB2RGC  ADB2WCL  ADBCP
  ADBH1    ADBH1H   ADBH8MG  ADBHGEN  ADBMAIN  ADBP1GV  ADBP8MG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI73298

     UP20/12/30 P F012

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.