IT00983: SQL SELECT STATEMENT FROM MONITORING AGENT CAUSES OVERFLOW ERROR SQL0413N

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 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