A fix is available
APAR status
Closed as program error.
Error description
Update volume Access DEStroyed may perform slowly with sequential volume on v6 servers. The performances worsens with small file workloads on large volumes. The impact for this issue can be most severe when updating all volumes in a storage pool using WHERESTGpool=pool_name. A server trace with DBEXEC ASVOL ADDMSG trace classes during the UPDATE VOLUME will show many SELECT from "TSMDB1"."AF_BITFILES" and INSERT INTO "TSMDB1"."AF_DAMAGED" during the UPDATE VOLUME. Here is an example: 10:33:37.027 ■3958■tbcli.c■4234■RdbPrepareAndExecuteStmt: Executing statement 'SELECT SRVID,BFID,POOLID,CK1,CK2,FORMAT, SIZE,NUMSEGS,LASTRTRV,FLAGS FROM "TSMDB1"."AF_BITFILES" WHERE (SRVID=? AND BFID=? AND POOLID=?) FETCH FIRST 1 ROW ONLY FOR READ ONLY WITH UR --3958' submitted from afutil.c(2764). 10:33:37.027 ■3958■tbcli.c■4234■RdbPrepareAndExecuteStmt: Executing statement 'INSERT INTO "TSMDB1"."AF_DAMAGED" (SRVID,BFID,POOLID,UPDATOR) VALUES(?,?,?,?) --3958' submitted from afutil.c(2021). Tivoli Storage Manager Versions Affected: All V6 Tivoli Storage Manager Servers Initial Impact: Medium Additional Keywords: TSM
Local fix
It is possible to manually update the volume by using DB2 directly. This manual update is not recommended for volumes in deduplicated storage pools. Run the following db2 commands as the Tivoli Storage Manager instance owner. - - - db2 connect to tsmdb1 - - - db2 set schema tsmdb1 - - - It is possible to manually update an individual volume with this command. db2 "update as_volume_status set access=4 where volname='<volume name case sensitive>'" - - - Here is an example for a volume named FILEPOOL: db2 "update as_volume_status set access=4 where volname='00000028.BFS'" It is possible to manually update the volumes in a storage pool with this command. - - - db2 "update as_volume_status set access=4 where poolid in (select poolid from ss_pools where poolname='<pool name in caps>')" - - - Here is an example for a pool named FILEPOOL: - - - db2 "update as_volume_status set access=4 where poolid in (select poolid from ss_pools where poolname='FILEPOOL')"
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 6.3.5. * * 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 number
IC94179
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
63A
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-07-16
Closed date
2013-08-06
Last modified date
2013-08-16
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
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":"63A"}]
Document Information
Modified date:
23 September 2021