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 number
IC61919
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
61W
Status
CLOSED USE
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-07-09
Closed date
2009-09-11
Last modified date
2009-09-11
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"61W","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
11 September 2009