Direct links to fixes
APAR status
Closed as program error.
Error description
he Tivoli Storage Manager server currently has a limitation in the number of objects to be trackable via the occupancy table for a given node and filespace pair. If a REPAIR OCCUPANCY is run against such a node/filespace combination, the process will end with ANR0162W Supplemental database diagnostic information: -1:22003:-802 ([IBM][CLI Driver][DB2/LINUXX8664] SQL0802N Arithmetic overflow or other arithmetic exception occurred. SQLSTATE=22003). (SESSION: 1810, PROCESS: 29) ANR0106E bfutil.c(9203): Unexpected error 2343 fetching row in table "AF.Bitfiles". (SESSION: 1810, PROCESS: 29) ANR0106E bfutil.c(9204): Unexpected error 2343 fetching row in table "BF.Aggregate.Attributes". (SESSION: 1810, PROCESS: 29) As dedup splits large objects into much smaller chunks that must be individually tracked, node/filespaces backed up to a dedup pool are more likely exposed to this APAR. The problem is only related to occupancy and does not affect the integrity or restorability of the data. Tivoli Storage Manager Versions Affected: all supported L2 Diagnostics (If Applicable) Check if any of the bfaa columns exceeds 2,147,483,647: db2 connect to tsmdb1 db2 set schema tsmdb1 db2 "select afbf.poolid, afbf.ck1, afbf.ck2, sum( cast(bfaa.numfiles as bigint) ), sum( cast(bfaa.numchunks as bigint) ) FROM TSMDB1.bf_aggregate_attributes AS bfaa LEFT JOIN TSMDB1.af_bitfiles AS afbf ON (afbf.srvid=bfaa.srvid AND afbf.bfid=bfaa.superbfid) group by afbf.poolid, afbf.ck1, afbf.ck2 order by afbf.poolid, afbf.ck1, afbf.ck2 FOR READ ONLY WITH CS" Initial Impact: Low Additional Keywords: TSM
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Tivoli Storage Manager server users. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description. * **************************************************************** * RECOMMENDATION: * * Apply fixing level when available. This problem is * * currently projected to be fixed in level 7.1.3. Note that * * this is subject to change at the discretion of IBM. * ****************************************************************
Problem conclusion
The problem was fixed. Affected Platforms: AIX, HP-UX, Solaris, Linux, and Windows.
Temporary fix
Comments
APAR Information
APAR number
IT04864
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
71L
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-10-10
Closed date
2015-02-12
Last modified date
2015-02-12
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
R62A PSY
UP
R62H PSY
UP
R62L PSY
UP
R62S PSY
UP
R62W PSY
UP
R63A PSY
UP
R63H PSY
UP
R63L PSY
UP
R63S PSY
UP
R63W PSY
UP
R71A PSY
UP
R71H PSY
UP
R71L PSY
UP
R71S PSY
UP
R71W 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":"7.1.3","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
12 February 2015