Direct links to fixes
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
[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1.3"}]
Document Information
Modified date:
26 September 2021