IBM Support

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

Subscribe

You can track all active APARs for this component.

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 number

    IT15963

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-06-30

  • Closed date

    2016-07-21

  • Last modified date

    2016-07-21

  • 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



Document information

More support for: Tivoli Storage Manager

Software version: 7.1.3

Reference #: IT15963

Modified date: 21 July 2016