PI93848: BATCH ANALYZE COMMENT ON INDEX ADB1223E ADB2REM: UNEXPECTED SQLCODE IN : SELECT SYSTABLES SQLCODE=-302/SQLCODEN302

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A CM Batch or Object Compare Batch analyze job of a change that
  includes a comment on an index may result in the following
  error:
  ADB1223E ADB2REM: Unexpected sqlcode in : Select systables
  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
  DSNT418I SQLSTATE = 22001 SQLSTATE RETURN CODE
  DSNT415I SQLERRP = DSNXRIHB SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD = -190 0 0 128 0 0 SQL DIAGNOSTIC INFORMATION
  DSNT416I SQLERRD = X'FFFFFF42' X'00000000' X'00000000'
  X'00000080'
  X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
  

Local fix

• Run Analyze online instead of batch.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Administration Tool for z/OS        *
  *                 who use the change management function       *
  *                 to analyze a change, or users of Object      *
  *                 Comparison Tool for z/OS.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When analyzing a change using the       *
  *                      change management batch function        *
  *                      or Object Comparison Tool, the          *
  *                      GEN function fails with SQLCODE=-302    *
  *                      / SQLCODEN302 when processing           *
  *                      the statement COMMENT ON INDEX.         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When analyzing a change using the change management batch
  function or Object Compare, the GEN function fails with
  SQLCODE=-302 when processing the statement COMMENT
  ON INDEX:
  
  ADB1223E ADB2REM: Unexpected sqlcode in : Select
   systables
  
  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
  DSNT418I SQLSTATE = 22001 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:

  UI54249 UI54250

Modules/Macros

•    ADB0
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI54249

     UP18/03/10 P F803

• RC10 PSY UI54250

     UP18/03/10 P F803

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.