IBM Support

IC94179: UPDATE VOLUME ACCESS DESTROYED SLOW ON V6 SERVERS

Subscribe

You can track all active APARs for this component.

 

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