PI51939: DSNT408I SQLCODE = -413

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Error message 'ETI801E Pgm: ETI@IOTB Stmt: 00128 Type:
  OPEN DSNT408I SQLCODE = -413, ERROR: OVERFLOW OR
  UNDERFLOW OCCURRED DURING NUMERIC DATA TYPE CONVERSION'
  may occur when one of the tables have more than
  2147483647 rows and satisfies the name mask on table lookup.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Table Editor z/OS.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Error message 'ETI801E Pgm: ETI@IOTB    *
  *                      Stmt: 00128 Type: OPEN DSNT408I         *
  *                      SQLCODE = -413, ERROR: OVERFLOW OR      *
  *                      UNDERFLOW OCCURRED DURING NUMERIC DATA  *
  *                      TYPE CONVERSION' may occur when one of  *
  *                      the tables have more than 2147483647    *
  *                      rows and satisfies the name mask on     *
  *                      table lookup.                           *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UI33407

Modules/Macros

•    ETI$DPTB ETI@CNVT ETI@CONN ETI@DFCK ETI@DSQL
  ETI@HIST ETI@IOCT ETI@IOID ETI@IOSC ETI@IOSX ETI@IOTB ETI@LOB
  ETI@LOG  ETI@PREP ETI@ROLB ETI@SQLD ETI@TCHK ETI@TCHX ETI@VALD
  ETI@WDUP ETI@WRIT ETILDB2  ETI2DB2
  

Fix information

• Fixed component name

  DB2 TABLE EDITO

• Fixed component ID

  5697G6500

Applicable component levels

• R140 PSY UI33407

     UP15/12/02 P F512

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.