APAR status
Closed as program error.
Error description
Error messages are logged in the server activity log. ANR0162W Supplemental database diagnostic information: -1:22003:-413 ([IBM][CLI Driver][DB2/NT64] SQL0413N Overflow occurred during numeric data type conversion. SQLSTATE=22003) ANR0516E SQL processing for statement select node_name , sum ( capacity ) as capacity , sum ( cast ( capacity as decimal ( 16 , 4 ) ) * cast ( ( pct_util/100 ) as decimal ( 16 , 4 ) ) ) as used from FILESPACEVIEW group by node_name failed. This error is seen at intervals when the Tivoli Monitoring Agent queries the server (default is once every hour). The decimal conversion (16,4) can accommodate up to 1 TB. If the node filespace's capacity exceeds 1 TB, the overflow error will occur. Tivoli Storage Manager Versions Affected: Tivoli Monitoring and Reporting on all supported versions and platforms. Customer/L2 Diagnostics (If Applicable) From a DB2 command line processor, issue the same command as reported in the activity log. The overflow error will also occur. db2 select node_name, sum(capacity) as capacity, sum(cast(capacity as decimal(16,4)) * cast((pct_util/100) as decimal(16,4))) as used from filespaceview group by node_name NODE_NAME CAPACITY USED ------------------ --------------------------------- ------------------- SQL0413N Overflow occurred during numeric data type conversion. SQLSTATE=22003 Initial Impact: Low Additional Keywords: TSM R&M ITM TIP TEPS DB2
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All Tivoli Monitoring for Tivoli Storage * * Manger users. * **************************************************************** * PROBLEM DESCRIPTION: See APAR description. * **************************************************************** * RECOMMENDATION: This problem is currently projected to be * * fixed in level 6.3.5. * * Note that this is subject to change at the * * discretion of IBM. * **************************************************************** *
Problem conclusion
This problem is fixed. Affected platforms: AIX, Linux, and Windows.
Temporary fix
Comments
APAR Information
APAR number
IT00983
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
63W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-04-15
Closed date
2014-05-13
Last modified date
2014-05-13
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
R63A PSY
UP
R63H PSY
UP
R63L PSY
UP
R63S PSY
UP
R63W PSY
UP
R63Z PSY
UP
[{"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":"63W","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
13 May 2014