PK31838: SQLCODEN302 SQLCODE302N SQLCODE -302 VARIABLE TOO LARGE FOR TARGET

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Running Object Comparison job. First step EXTRACT DB2 CATALOG
  OBJECTS FOR SOURCE got a RC=12 and a the following
  SQL code:
  
  Generating DDL for Database MCSDBCA1
  Unexpected sqlcode in : Insert adbgen PK gtt
  
  DSNT408I SQLCODE = -302, ERROR: THE VALUE OF INPUT VARIABLE
        OR PARAMETER NUMBER 1 IS INVALID OR TOO LARGE FOR THE
        TARGET COLUMN OR THE TARGET VALUE
   sqlcode302 sqlcodeN302 sqlcode302N
  DSNT418I SQLSTATE = 22003 SQLSTATE RETURN CODE
  DSNT415I SQLERRP = DSNXRIHB SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD = -385 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
  DSNT416I SQLERRD = X'FFFFFE7F' X'00000000' X'00000000'
  X'FFFFFFFF'
  X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
  .
  Additional symptoms: sqlcode304 sqlcoden304 sqlcode304n
  adb2rem SELECT COUNT ( * ) INTO : H FROM SYSIBM . SYSTABLES
  WHERE TYPE = 'A'
  .
  Error occurs when ALIAS count exceeds 32767 (max value for
  small int variable). OC ( Object Compare Tool ) and GEN for
  Admin are affected.
  

Local fix

• Please apply ptf when available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2  Administration  Tool,  and     *
  *                 users of DB2 Object Comparison Tool, who     *
  *                 use  ADB2GEN with a very large number of     *
  *                 objects, may be affected.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Running Object Comparison job, first    *
  *                      step EXTRACT DB2 CATALOG OBJECTS for    *
  *                      SOURCE got a RC=12 and the following    *
  *                      SQL code:                               *
  *                      DSNT408I SQLCODE = -302,  ERROR: THE    *
  *                      VALUE OF INPUT VARIABLE OR PARAMETER    *
  *                      NUMBER 1 IS INVALID OR TOO LARGE FOR    *
  *                      THE TARGET COLUMN OR THE TARGET VALUE   *
  *                      .*                                      *
  *                      Error occurs when ALIAS count exceeds   *
  *                      32767 (maximum value for small INT      *
  *                      variable).                              *
  *                      .*                                      *
  *                      Users of GEN with a very large number   *
  *                      of objects are running into  -302 SQL   *
  *                      code  (because of the fact that  some   *
  *                      quantities can exceed the capacity of   *
  *                      SMALLINT columns in the ADBGEN Global   *
  *                      Temp Table).                            *
  *                      .* Note:                                *
  *                      Changes have been made:                 *
  *                      * Change  two  columns in the ADBGEN    *
  *                        Global Temp Table from SMALLINT to    *
  *                        INTEGER                               *
  *                      * Change the two queries which identify *
  *                        DB2 systems having no aliases  and/or *
  *                        synonyms  so  that  they will perform *
  *                        better  and  also avoid possible -302 *
  *                        SQLCODE                               *
  *                      * Changed several variable declarations *
  *                        from FIXED(15) to FIXED(31).          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix.
  

Temporary fix

• *********
  * HIPER *
  *********
  

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  ADB2REP  ADB2RER  ADB2RES
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK18811

     UP06/10/18 P F610

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.