PH46980: ADMIN START FOR TABLE COMMAND IS GENERATED AT THE END OF WSL FILE AFTER THE DROP DATABASE STATEMENT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When doing CM batch with an import of a DROP DATABASE statement
  for a database that has a table with an implicit table space,
  the resulting WSL has an ADMIN START FOR TABLE command at the
  very end of the WSL. The execution of the requested START
  DATABASE SPACENAME fails as the object is no longer available.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using Change Management (CM) batch *
  *                      to import a DROP DATABASE statement, an *
  *                      ADMIN START statement is included in    *
  *                      the resulting work statement list(WSL). *
  *                      The WSL fails when you try to run it.   *
  ****************************************************************
  The user is importing a DROP DATABASE statement by using CM
  batch. The WSL created by the CM batch includes an ADMIN START
  FOR TABLE statement, which is changed to a START DB command when
  the WSL is run. The WSL then fails, because the database no
  longer exists after being dropped.
  

Problem conclusion

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

  UI82352 UI82375

Modules/Macros

• ADBGAJOB
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI82352

     UP22/10/03 P F209

• RD10 PSY UI82375

     UP22/10/03 P F209

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.