IC78227: EXPORT OF LARGE NUMBER OF OBJECTS MAY LEAD TO LOCKING CONTENTION RESULTING IN OVERALL PERFORMANCE DEGRADATION

APAR status

• Closed as program error.

Error description

• The export process holds 2 locks for each aggregate until the
  end of processing. If there is a large amount of data for
  export, it can cause lock conflicts between export processing
  and other server processes or client sessions. This can affect
  the performance of export processing and other server processes
  or sessions running at the same time.
  
  - Messages ANR0379W will be seen in server activity log.
  
  03/25/2011 00:32:42      ANR0379W A server database deadlock
  situation has been
                            encountered; the lock request for the
  bf aggregate
                            (superbitfile) id lock, 11505375 will
  be denied to
                            resolve the deadlock.
  03/25/2011 00:32:42      ANR9999D_3434449294
  bfRtrv(bfrtrv.c:877) Thread<40>: Error
                            82 getting sub-bitfile information.
  (SESSION: 1584,
                            PROCESS: 57)
  03/25/2011 00:32:42      ANR9999D_1288456981
  XiExportObject(xibf.c:858) Thread<40>:
                            Unknown result code (82) from bfRtrv.
  (SESSION: 1584,
                            PROCESS: 57)
  
  - Message ANR0656W can be used to determine whether files were
  skipped in the export process.
  
  03/25/2011 00:32:44      ANR0656W EXPORT NODE: Skipped 0 archive
  files, 1 backup
                            files, and 0 space managed files.
  (SESSION: 1584,
                            PROCESS: 57)
  
  - Messsages ANR0532W and ANR0538I will be seen in server trace
  taken with IMSORT XI XIDETAIL XISESS ADDMSG flags.
  
  ANR0532W smnode.c(3620): Transaction  ( 000000000A0FADC8 ) was
  aborted for session 8442 for node NODE1 (WinNT).
  ANR0538I A resource waiter has been aborted.~
  
  - "SHOW TXNT" can be used to see a transaction created in
  xiexport.c holding locks.
  
  slot -> 179:
   Tsn=0:19156403, Resurrected=False, InFlight=True,
  Distributed=False, Persistent=True, Addr 0000000007029718
     Start ThreadId=38, Timestamp=2011-08-09 15:15:31,
  Creator=xiexport.c(441)
  
  After the export process and a client session encounter a lock
  conflict, both the export and the session stagnate. After
  RESOURCETIMEOUT limit is reached, the transaction of the session
  is aborted and the export process immediately continues to run
  until another lock conflict occurs.
  
  Tivoli Storage Manager Versions Affected:
  Tivoli Storage Manager server 6.x on all platforms.
  
  Initial Impact:
  Low
  
  Additional Keywords:
  zz61 zz62 slow export lock conflict deadlock XiExportObject
  ANR0538I ANR0532W ANR0379W TSM
  

Local fix

• Performing export during low server activity might help to avoid
  lock conflicts.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager server users of   *
  *                 the EXPORT command.                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: See ERROR DESCRIPTION.                  *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available. This      *
  *                 problem is currently projected to be         *
  *                 fixed in levels 6.2.4 and 6.3.2.             *
  *                 Note that this is subject to change          *
  *                 at the discretion of IBM.                    *
  ****************************************************************
  *
  

Problem conclusion

• This problem was fixed.
  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

• R61A PSY

     UP

• R61H PSY

     UP

• R61L PSY

     UP

• R61S PSY

     UP

• R61W PSY

     UP

• 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