PM06412: DDL COMMAND PRODUCTS EMPTY DDL FILE WHEN DSNDB% PREFIXED OBJECTS WHILE GEN ISSUES MESSAGE ADB1926W ( AS EXPECTED )

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS DDL command creates an
  empty dataset when processing objects with names prefixed
  DSNDB.
  .
  

Local fix

• Note: The GEN command issues the following messages for
  objects prefixed DSNDB:
  ADB2GEN - Create DDL from catalog info
  ----------------------------------------------------------------
  
  
            Processing Database DSNDB07
  ADB1926W A create statement for database DSNDB07 will not be
  generated.  The name cannot start with DSNDB.
  Reason code = 40
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use the DDL line command        *
  *                 to generate DDL for system databases         *
  *                 DSNDB01, DSNDB04, DSNDB06 and DSNDB07.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      DDL command creates an empty data       *
  *                      set when processing objects             *
  *                      containing names prefixed with          *
  *                      DSNDB.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool for z/OS DDL command creates
  an empty data set when processing objects containing
  names prefixed with DSNDB.
  

Problem conclusion

• Panel ADB21D "DB2X Databases" and message ADB328
  have been modified. When a user issues the DDL line
  command against system databases prefixed with DSNDB,
  there will be a message displayed on panel ADB21D
  indicating the 'DDL' command is not supported
  for these system databases.
  

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

•    ADB21D   ADB38
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK64491

     UP11/02/06 P F102

• R720 PSY UK64492

     UP11/02/06 P F102

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.