IC87090: GENERATE BACKUPSET CAN FAIL AFTER REACHING ACTIVE LOG NUM_LOG_SPAN LIMIT.

IBM Tivoli Storage Manager (TSM) server V6.3.3.x interim fix downloads

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 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