PM43370: GEN SCHEMA OWNER FOR STOGROUP, DATABASE AND TABLESPACE TO CHANGE TO CURRENT SQLID

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool for z/OS for DB2 v9 and higher,
  GEN processing for stogroup, database and table space was
  not changed to no longer use the value for Object schema
  (old name Object Owner) to change to CURRENT SQLID.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who set the field 'Object schema'       *
  *                 to a new schema name on panel ADB2GEN        *
  *                 'Generate SQL from DB2 Catalog' for DB2 9    *
  *                 NFM or higher.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS,    *
  *                      GEN (Generate) processing for           *
  *                      for Stogroups, Databases and Table      *
  *                      Spaces continued to use the value for   *
  *                      the Object schema (old name Object      *
  *                      Owner) for the SET CURRENT SQLID        *
  *                      syntax.                                 *
  *                                                              *
  *                      In addition, the GEN function           *
  *                      issues:                                 *
  *                                                              *
  *                      Processing Trigger                      *
  *                      < schema >.< trigger_name >             *
  *                      ADB1847E WARNING : Error                *
  *                      parsing DDL TRIGGER statement.          *
  *                      Please verify the generated DDL         *
  *                        Reason code = 28                      *
  *                        < schema >.< trigger_name >           *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  CURRENT SQLID was changed to the value of the field
  'Object schema' on panel ADB2GEN for Stogroups,
  Databases and Table Spaces.
  

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:

Modules/Macros

•    ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK71414

     UP11/09/02 P F109

• R720 PSY UK71415

     UP11/09/02 P F109

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.