IC98338: MULTIPLE ACTIVE VERSIONS OF AN OBJECT AFTER NODE REPLICATION ROLES HAVE BEEN REVERSED

IBM Tivoli Storage Manager V6.3 Fix Pack 5 (6.3.5.000) Server Downloads
IBM Tivoli Storage Manager (TSM) server V7.1.0.x interim fix downloads

APAR status

• Closed as program error.

Error description

• When reversing Tivoli Storage Manager server node replication
  roles, for example as described in TechNote 1628618
  "Synchronization of source and target replication server after
  role change",
  http://www-01.ibm.com/support/docview.wss?uid=swg21628618
  it is possible to get multiple active versions of an object.
  
  Customer/L2 Diagnostics :
  This problem applies, when  for a node that went through a
  replication role reversal, a QUERY BACKUP from this client node
  reports multiple active versions of the same object.
  
  For example:
  
  tsm> q ba Z:\Test\test* -subdir=no
  
  Size    Backup Date         Mgmt Class  A/I File
  ------  ------------------- ----------- --- -------
    10 B  27.11.2013 17:07:53   MC_DIR     A  \\srv1\z$\Test\test1
    10 B  27.11.2013 17:59:13   MC_DIR     A  \\srv1\z$\Test\test1
  
  Tivoli Storage Manager Versions Affected:
  Tivoli Storage Manager Server versions 6.3 and 7.1
  
  Initial Impact:
  medium
  
  Additional Keywords:
  TSM zz63 repl SRS TRS 1628618
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of Tivoli Storage Manager server   *
  *                 using node replication.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: See Error Description.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Apply fixing level when available.  This problem is currently
  projected to be fixed in levels 6.3.5 and 7.1.1.  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.
  *
  If duplicate active objects were created prior to installing
  this fix, the following SQL will correct the problem by
  deactivating the older version.  Fill in the <nodeid> and
  <fsid> containing the duplicate active objects.
  *
  db2 start database manager
  db2 connect to tsmdb1
  db2 "update tsmdb1.backup_objects old set state=2,
  deacdate=current_timestamp where old.nodeid=<nodeid> and
  old.fsid=<fsid> and old.state=1 and exists ( select 1 from
  tsmdb1.backup_objects new where new.objid!=old.objid and
  new.nodeid=old.nodeid and new.fsid=old.fsid and new.hl=old.hl
  and new.ll=old.ll and new.state=old.state and
  new.objtype=old.objtype and new.insdate>old.insdate fetch
  first 1 rows only )"
  

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:

Modules/Macros

• IMBKINS
  

Fix information

• Fixed component name

  TSM SERVER

• Fixed component ID

  5698ISMSV

Applicable component levels

• 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