IT15963: SQL0413N OVERFLOW OCCURRED DURING NUMBER DATA TYPE CONVERSION. SLQSTATE=22003 WHEN RUNNING SELECT TO CHECK DEDUPLICATION STATS.

7.1.7.000-TIV-TSMSRV-SolarisSPARC
7.1.7.000-TIV-TSMSRV-Linuxs390x
7.1.7.000-TIV-TSMSRV-Linuxppc64
7.1.7.000-TIV-TSMSRV-WIN
7.1.7.000-TIV-TSMSRV-Linuxx86_64
7.1.7.000-TIV-TSMSRV-HP-UX
7.1.7.000-TIV-TSMSRV-AIX
IBM Spectrum Protect Server V7.1 Fix Pack 7 (7.1.7.000) Downloads

APAR status

• Closed as program error.

Error description

• When running the following select statement from the
  IBM Spectrum Protect Administrative command line:
  .
  Select date_time,cast((node_name) as char(40)) as "Node_Name",
  cast ((filespace_name) as char(60)) as "Filaspace_Name"
  cast(protected_MB as bigint) as protected,cast(physical_MB
  as bigint) as physical,DECIMAL(DEDUP_SAVED_PCT, 5, 2)
  from dedupstats_SQL where date_time>='DATE TIME'"
  The server will return:
  SQl0413N Overflow occured during numeric data type conversion.
  SQLSTATE=22003.
  This is due to a node which has been deduplicated 100%. The
  overflow does not effect the query dedupstats IBM Spectrum
  Protect command.
  Customer/L2 Diagnositics: Run the following query on the
  IBM Spectrum Protect Administrative command line:
  .
  query dedupstats
  .
  If this APAR is applicable then one node would show 100%
  deduplication.
  Additional Keywords: Select deduplication statistics overflow
  query
  

Local fix

• The select statement can be ran directly from the DB2
  command line without seeing the overflow error:
  db2 connect to tsmdb1
  db2 set schema tsmdb1
  db2 "Select date_time,cast((node_name) as char(40)) as
  "Node_Name",cast((filespace_name) as char(60)) as
  "Filespace_Name",cast(protected_MB as bigint) as protected,
  cast(physical_MD as bigint ) as pysical,DECIMAL_SAVED_PCT, 5,
  2) from dedupstats_sql where date_time>='Date TIME'"
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Tivoli Storage Manager server users of container storage *
  * pools.                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in level 7.1.7. Note that this is      *
  * subject to change at the discretion of IBM.                  *
  ****************************************************************
  

Problem conclusion

• This problem was fixed.
  Affected platforms:  AIX, Solaris, 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

• R71A PSY

     UP

• R71H PSY

     UP

• R71L PSY

     UP

• R71S PSY

     UP

• R71W PSY

     UP