IC61919: ANR0162W AND SQL0413N OVERFLOW OCCURRED DURING NUMERIC DATA TYPE CONVERSION WHEN TSM DB IS QUERIED

APAR status

• Closed as user error.

Error description

• The following messages can be observed on a TSM Server when
  issuing select statement against the TSM database:
  
  ANR0162W Supplemental database diagnostic information:
  -1:22003:-413
  ([IBM][CLI Driver][DB2/LINUXX8664] SQL0413N  Overflow occurred
  during numeric data type conversion.  SQLSTATE=22003).
  
  The following message indicates which select statement lead to
  the error. Please note that there might be other select
  statements leading to the same above warning message.
  
  ANR0516E SQL processing for statement select node_name , sum (
  capacity ) as capacity , sum ( cast ( capacity as decimal ) *
  cast ( ( pct_util/100 ) as decimal ) ) as used from
  FILESPACEVIEW group by node_name  failed.
  
  Reviewing db2diag.log you will see message similar to the
  following in the relevant timeframe:
  
  2009-07-01-16.13.32.903814+120 I1224970E499        LEVEL: Error
  PID     : 32724                TID  : 47993394817344PROC :
  db2sysc 0
  INSTANCE: tsminst1             NODE : 000          DB   : TSMDB1
  APPHDL  : 0-21664              APPID:
  *LOCAL.tsminst1.090701141332
  AUTHID  : TSMINST1
  EDUID   : 125                  EDUNAME: db2agent (TSMDB1) 0
  FUNCTION: DB2 UDB, runtime interpreter, sqlrisrt, probe:50
  DATA #2 : Hexdump, 4 bytes
  0x00002BA6553F7EB0 : 0800 1680
  
  TSM Versions Affected:
  TSM Server 6.1 on all supported platforms
  
  Initial Impact:
  Low
  
  Additional Keywords:
  zz61 zzrm61 db2 select field length data type int64 integer
  

Local fix

• Ignore these messages until a fix is available.
  

Problem summary

Problem conclusion

Temporary fix

Comments

• This APAR is being closed as a user error.  The command processi
  ng and messages issued are correct in this situation.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  TSM SERVER

• Fixed component ID

  5698ISMSV

Applicable component levels