PI76613: DB2 ADMIN TOOL ADB2GEN OF DATABASE RESULTS IN SQLCODE -305

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• GEN DDL or Compare of pre-DB2 V12 defined database results in
  SQLCODE -305:
  ---------------------------------------------------------------
  ADB2GEN - Create DDL from catalog info
  ---------------------------------------------------------------
            Processing Database ADBDCC
  ADB1223E ADB2REM:  Unexpected sqlcode in : Fetch c_ts
  
  DSNT408I SQLCODE = -305, ERROR:  THE NULL VALUE CANNOT BE
            ASSIGNED TO HOST VARIABLE NUMBER 53 BECAUSE NO
            INDICATOR VARIABLE IS SPEC
  DSNT418I SQLSTATE   = 22002 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXROHB SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = -115  0  0  -1  0  0 SQL DIAGNOSTIC INFO
  DSNT416I SQLERRD    = X'FFFFFF8D'  X'00000000'  X'00000000'
            X'FFFFFFFF' X'00000000'  X'00000000' SQL DIAGNOSTIC
            INFORMATION
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 version 12 Release 1, and DB2 12 who         *
  *                 use the GEN or DDL command on a database     *
  *                 which has a table space created in DB2 11    *
  *                 or lower.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Error message ADB1223E / msgadb1223e    *
  *                      and SQLCODE -305 / SQLCODEN305 is       *
  *                      observed when using the GEN or DDL      *
  *                      command.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When executing the GEN or DDL command on a database, error
  ADB1223E / msgadb1223e and SQLCODE -305 / SQLCODEN305
  is observed:
  
  ADB1223E ADB2REM: Unexpected sqlcode in : Fetch c_ts
  
  DSNT408I SQLCODE = -305, ERROR: THE NULL VALUE CANNOT
  BE ASSIGNED TO HOST VARIABLE NUMBER 53 BECAUSE NO
  INDICATOR VARIABLE IS SPEC
  DSNT418I SQLSTATE = 22002
  SQLSTATE RETURN CODE
  

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

•    ADB2REM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI46433

     UP17/04/18 P F704

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.