PI15738: DB2 ADMINISTRATION TOOL FOR Z/OS IMAGE COPY STATUS QUERY (ICS) MAY FAIL WITH SQLCODEN413 IF COPYPAGES VALUE IS LARGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS Image Copy Status query
  (ICS) may fail with SQLCODEN413 if COPYPAGES value is large
  and INT(COPYPAGESF) results in overflow
  .
  Additional symptoms:
  When running query :
  SELECT DEC(DSNUM, 4, 0) AS DSNM,
  T.*,HEX(START_RBA),HEX(PIT_RBA),
  INT(COPYPAGESF) AS NACTIVE, '     4' AS PGSIZE FROM
  ADASHEV.SYSCOPY T
  WHERE TSNAME = 'tsname' AND DBNAME = 'dbname' ORDER BY TIMESTAMP
  DESC FOR FETCH ONLY
  encountered the following error:
  ADB2E1 in --------------------- DB2 Error Display 1
  --------------------- 13:52
  Command ===>
  Rollback done
     SQLCODE : -413                           DSNTIAR CODE :  0
  
  DSNT408I SQLCODE = -413, ERROR:  OVERFLOW OR UNDERFLOW OCCURRED
  DURING NUMERIC
           DATA TYPE CONVERSION
  DSNT418I SQLSTATE   = 22003 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXRINT SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = -101  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'FFFFFF9B'  X'00000000'  X'00000000'
  X'FFFFFFFF'
           X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  

Local fix

• Remove INT(COPYPAGESF) from the query or just use COPYPAGESF
  and then it runs with good return code.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use 'ICS - Image copy status'       *
  *                 line command on panel ADB21S 'Table          *
  *                 Spaces'.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When issuing the 'ICS' line command     *
  *                      on panel ADB21S to show the image       *
  *                      copy status of a table space,  the      *
  *                      command failed with error               *
  *                      SQLCODE=-413 / SQLCODEN413:             *
  *                                                              *
  *                      DSNT408I SQLCODE = -413,                *
  *                      ERROR: OVERFLOW OR                      *
  *                      UNDERFLOW OCCURRED                      *
  *                      DURING NUMERIC DATA TYPE                *
  *                      CONVERSION                              *
  *                      DSNT418I SQLSTATE   = 22003             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When issuing 'ICS' command on panel ADB21S to show image copy
  status of a table space,  and the number of pages written to
  the copy data set (column COPYPAGESF in the catalog table
  SYSCOPY) of the table space is not in the range of integer,
  and a query statement for processing the line command
  attempted to covert the value to an integer, this leads to the
  SQLCODE=-413 / SQLCODEN413.
  

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:

  UI19649 UI19650 UI19651

Modules/Macros

• ADBPPDC  ADB21S
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UI19649

     UP14/07/18 P F407

• RA20 PSY UI19650

     UP14/07/18 P F407

• RB10 PSY UI19651

     UP14/07/18 P F407

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.