PK94699: GEN SQLCODEN304 DATA TYPE BIGINT HOST VARIABLE IN POSITION 32 WITH DATA TYPE INTEGER AFTER APPLYING PTF 09/08/26 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS GEN and Migrate functions
  will fail with the following error if catalog statistics is
  generated on DB2 v9. In addition a BIGINT column in
  SYSIBM.SYSTABLESPACESTATS or SYSIBM.SYSINDEXSPACESTATS must
  have a value greater than 2147483648 (max value of integer).
  If you want to search your existing batch jobs.
  Look for GENSTATS in the PARMS('.../GENSTATS...') statement
  for each GEN step.
  SQLCODEN304:
  ADB2RES: Unexpected sqlcode in : Fetch c_tablespacestats first
  DSNT408I SQLCODE = -304, ERROR: A VALUE WITH DATA TYPE BIGINT
  CANNOT BE ASSIGNED TO A HOST VARIABLE BECAUSE THE VALUE IS NOT
  WITHIN THE RANGE OF THE HOST VARIABLE IN POSITION 32 WITH
  DATA TYPE INTEGER
  DSNT418I SQLSTATE = 22003 SQLSTATE RETURN CODE
  DSNT415I SQLERRP = DSNXROHB SQL PROCEDURE DETECTING ERROR
  

Local fix

• Select NO for the catalog statistics option in GEN and MIG
  when running on DB2 9.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool who use     *
  *                 generate catalog statistics on DB2 9.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following error was received:       *
  *                      ADB2RES: Unexpected sqlcode in :        *
  *                          Fetch c_tablespacestats first       *
  *                                                              *
  *                      Followed by DB2 SQLCODE -304 error      *
  *                      message:                                *
  *                      SQLCODE = -304, ERROR:  A VALUE WITH    *
  *                      DATA TYPE BIGINT CANNOT BE ASSIGNED TO  *
  *                      A HOST VARIABLE BECAUSE THE VALUE IS    *
  *                      NOT WITHIN THE RANGE OF THE HOST        *
  *                      VARIABLE IN POSITION 32 WITH DATA       *
  *                      TYPE INTEGER                            *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  A BIGINT value was not correctly retrieved from DB2 by the
  program.
  

Problem conclusion

• The problem has been fixed.
  

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

•    ADB2RES
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK50262

     UP09/09/26 P F909

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.