PM87211: DB2 ADMINISTRATION TOOL FOR Z/OS CHANGE MANAGEMENT ANALYZE RUN FAILS TO DETECT STOGROUP WHEN PROCESSING CHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS Change Management ANALYZE run
  fails to detect STOGROUP when processing Change
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Generate (GEN) function     *
  *                 to generate DDL for a database which is      *
  *                 defined on a non-existent STOGROUP.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the GEN function to          *
  *                      generate DDL for a database which       *
  *                      is defined on a non-existent STOGROUP,  *
  *                      GEN failed with RC=8 / Return Code 8,   *
  *                      and error messages ADB1653E /           *
  *                      msgadb1653e and ADB1650E                *
  *                      / msgadb1650e:                          *
  *                                                              *
  *                      Processing Database dbname              *
  *                      ADB1653E                                *
  *                        Stogroup not found,                   *
  *                        SGname= sgname                        *
  *                      ADB1650E                                *
  *                        DBname= dbname                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When generating DDL for a database which is defined on a
  non-existent STOGROUP, DB2 Admin tool failed and produced
  error messages ADB1653E and ADB1650E.  DB2 Admin Tool presumes
  the STOGROUP should exist when creating a database, but it is
  allowed by DB2.
  

Problem conclusion

• Problem has been resolved. A warning message ADB1601W
  / msgadb1601w will be displayed:
  
    ADB1601W Stogroup not found, SGname= sgname
  
  instead of the error message ADB1653E:
  
    ADB1653E Stogroup not found, SGname= sgname
  

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:

  UK95882 UK95883

Modules/Macros

• ADB1000  ADB2REM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK95882

     UP13/07/18 P F307

• RA20 PSY UK95883

     UP13/07/18 P F307

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.