PH31035: MIGRATE OR GEN STATISTICS ENDS ADB7955E SQLCODE = -420 VALUE STRING ARGUMENT NOT ACCEPTABLE SYSIBM.BIGINT FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• GEN or Migrate statistics issues a SELECT on a column
  with type BIGINT.  Currently the value is enclosed in quotes,
  with preceding spaces, depending on the number, which works fine
  for values >=0. However, ADBTEP2 and DSNTEP2 cannot process the
  prceding spaces for negative numbers.  As a result, the job may
  end with the following error:
  
  ADB7955E  DSNT408I SQLCODE = -420, ERROR:  THE VALUE OF A STRING
   ARGUMENT WAS NOT
  ADB7955E           ACCEPTABLE TO THE SYSIBM.BIGINT FUNCTION
  ADB7955E  DSNT418I SQLSTATE   = 22018 SQLSTATE RETURN CODE
  ADB7955E  DSNT415I SQLERRP    = DSNXRLNG SQL PROCEDURE DETECTING
  ERROR
  ADB7955E  DSNT416I SQLERRD    = -174  0  0  -1  0  0 SQL
  DIAGNOSTIC INFORMATION
  ADB7955E  DSNT416I SQLERRD    = X'FFFFFF52'  X'00000000'
  X'00000000'  X'FFFFFFFF
  ADB7955E           X'00000000'  X'00000000' SQL DIAGNOSTIC
  INFORMATION
  
  Keywords:  msgadb7955e;sqlcode420n
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS Reverse Engineering (GEN) function      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Generating catalog statistics does not  *
  *                      correctly process negative values for   *
  *                      SYSTABLESPACESTATS.UPDATESIZE,          *
  *                      resulting in error SQLCODE = -420       *
  *                      when job is run.                        *
  ****************************************************************
  When building the UPDATE statement for the SYSTABLESPACESTATS
  catalog table, GEN does not correctly print the value for
  the UPDATESIZE column when the value is negative. It is quoted
  with extraneous spaces.  When the job is run, it results in the
  following error:
  
   DSNT408I SQLCODE = -420, ERROR:  THE VALUE
                    OF A STRING ARGUMENT WAS NOT
                    ACCEPTABLE TO THE SYSIBM.BIGINT FUNCTION
  

Problem conclusion

• The 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:

  UI74042

Modules/Macros

• ADB2RES
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI74042

     UP21/02/23 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.