A fix is available
APAR status
Closed as program error.
Error description
Generate backupset can fail after hitting NUM_LOG_SPAN limit for the active log, when processing a large amount of data. In actlog, it can be seen: ANR0171I imobjgen.c(8559): Error detected on 44:5, database in evaluation mode. ANR0157W Database operation FETCH for table Backupset.Temp.Objects failed with result code 4522 and tracking ID: 000000001156F578. ANR0158W Database operation FETCH for table Backupset.Temp.Objects failed with operation code 4522 and tracking id 000000001156F578. The data for column 1 is: (int8)1. ANR0158W Database operation FETCH for table Backupset.Temp.Objects failed with operation code 4522 and tracking id 000000001156F578. The data for column 8 is: (int64)5288812168. ANR0106E imobjgen.c(8571): Unexpected error 4522 fetching row in table "Backupset.Temp.Objects". ANR9999D_3405780912 imIncludeObjInSet(imobjgen.c:1578) Thread<50>: Failure (9996) from IsObjInTOC. ANR9999D Thread<50> issued message 9999 from: ANR9999D Thread<50> 000007FEE8366A99 OutDiagToCons()+159 ANR9999D Thread<50> 000007FEE83604EC outDiagfExt()+fc ANR9999D Thread<50> 000007FEE7F1B997 imIncludeObjInSet()+157 ANR9999D Thread<50> 000007FEE7D48178 bfWriteObjectSet()+768 ANR9999D Thread<50> 000007FEE7F1676E GenBkSetTocThread()+43e ANR9999D Thread<50> 000007FEE7F17FD2 imGenerateObjectSetTOC()+1792 ANR9999D Thread<50> 000007FEE7F1D5CC imIncludeObjInSet()+1d8c ANR9999D Thread<50> 000007FEE7F1F9F4 imIncludeObjInSet()+41b4 ANR9999D Thread<50> 000007FEE7B882A4 startThread()+124 ANR9999D Thread<50> 0000000072B91D9F endthreadex()+43 ANR9999D Thread<50> 0000000072B91E3B endthreadex()+df ANR9999D Thread<50> 00000000774DF33D BaseThreadInitThunk()+d ANR9999D Thread<50> 0000000077612CA1 RtlUserThreadStart()+21 in db2diag.log 2012-05-23-22.47.53.493000+000 E15493030F726 LEVEL: Error PID : 17720 TID : 15936 PROC : db2syscs.exe INSTANCE: SERVER1 NODE : 000 DB : TSMDB1 EDUID : 15936 EDUNAME: db2loggr (TSMDB1) FUNCTION: DB2 UDB, data protection services, sqlpScanTranTableForLowTran, probe:550 MESSAGE : ADM1541W Application "dsmsvc.exe" with application handle "0-53637" and application id "*LOCAL.SERVER1.120523113743" executing under authentication id "abcd1234" has been forced off of the database for violating database configuration parameter NUM_LOG_SPAN (current value "231"). The unit of work will be rolled back. Tivoli Storage Manager Versions Affected: Tivoli Storage Manager server 6.1, 6.2 and 6.3 on all platforms Initial Impact: high Additional Keywords: TSM zz61 zz62 zz63 87563 gen backupset generate activelog full filling
Local fix
Run generate backupset with smaller subset of nodes and data.
Problem summary
**************************************************************** * USERS AFFECTED: All Tivoli Storage Manager server users of * * the Generate Backupset command * **************************************************************** * PROBLEM DESCRIPTION: See error description. * **************************************************************** * RECOMMENDATION: Apply fixing level when available. This * * problem is currently projected to be fixed * * in levels 6.2.5, 6.3.3.100, 6.3.4. Note that * * this is subject to change at the discretion of IBM. * **************************************************************** *
Problem conclusion
This problem has been corrected. Affected platforms: AIX, HP-UX, Solaris, Linux, and Windows.
Temporary fix
Comments
APAR Information
APAR number
IC87090
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
63W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-10-09
Closed date
2012-11-05
Last modified date
2013-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
[{"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":"63W"}]
Document Information
Modified date:
19 September 2021