PK91811: GEN RC12 SQLCODEN512 ADB1649E ADB2REM: UNEXPECTED SQLCODE IN : OPEN C_TP WHEN REFERENCING DSNDB04

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS GEN command issues a
  message:
            Processing Database DSNDB04
  Invalid database name. Cannot create a database with a name
  starting with DSNDB.
              DSNDB04
  ADB1651E   DBname= DSNDB04, TSname= A
  ADB1649E ADB2REM:  Unexpected sqlcode in : Open c_tp
  
   DSNT408I SQLCODE = -502, ERROR:  THE CURSOR IDENTIFIED IN AN
  OPEN STATEMENT IS
            ALREADY OPEN
   DSNT418I SQLSTATE   = 24502 SQLSTATE RETURN CODE
  and then ends RC12.
  Chapter 9. Reconstructing SQL (DB2 Admin ReverseEngineering)
  Engineering) "GEN does not support these DB2 V9 objects:" does
  not list the DSNDB prefix restriction.
  .
  For DB2 9 subsystems the restriction includes
  names starting with DSN followed by 5 digits
  .
  Masking to a DSN prefixed name will also cause the symptom
  e.g.
  GEN database HELLO but use a mask of DBNAME:HELLO,DSNDB9 will
  cause the error message
  

Local fix

• Do not GEN DSNDB prefixed objects.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Admin Tool who use the GEN  or  *
  *                 DDL command to  request DDL for a  database  *
  *                 name starting with DSNDB, or to request DDL  *
  *                 for an MQT.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following error occurred  when      *
  *                      attempting  to generate DDL for  a      *
  *                      database with a name starting with      *
  *                      DSNDB.                                  *
  *                      ADB1649E ADB2REM:  Unexpected sqlcode   *
  *                      in : Open c_tp.                         *
  *                                                              *
  *                       DSNT408I SQLCODE = -502, ERROR:  THE   *
  *                       CURSOR  IDENTIFIED  IN AN OPEN STATE   *
  *                       ALREADY OPEN.                          *
  *                                                              *
  *                      The following oncode condition occurred *
  *                      when attempting to generate DDL for  an *
  *                      MQT that was defined without specifying *
  *                      the 'MAINTAINED BY' and                 *
  *                      'QUERY OPTIMIZATION' options:           *
  *                      IBM0400W ONCODE=500  The CONDITION      *
  *                      condition  was raised by a  SIGNAL      *
  *                      statement  and    the    condition      *
  *                      ML_STRINGRANGE.                         *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The following error occurred when attempting to generate DDL for
  a database with a name starting with DSNDB.
  ADB1649E ADB2REM:  Unexpected sqlcode in : Open c_tp.
  
   DSNT408I SQLCODE = -502, ERROR:  THE CURSOR IDENTIFIED IN AN
   OPEN STATE ALREADY OPEN
  The following oncode condition occurred  when attempting to
  generate DDL for an MQT that was defined without specifying
  the 'MAINTAINED BY' and 'QUERY OPTIMIZATION' options:
  IBM0400W ONCODE=500  The CONDITION condition was raised by a
  SIGNAL statement and the condition ML_STRINGRANGE.
  

Problem conclusion

• The problems have been fixed. Generating a database with a name
  starting with DSNDB is  now considered a warning and the create
  statement for the database is not generated,  but other objects
  in  the database  are generated.   The MQT DDL is now generated
  correctly.
  

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:

  UK48848

Modules/Macros

•    ADB1000  ADB2REG  ADB2REU
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK48848

     UP09/08/01 P F907

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.