IBM Support

IT02769: DELETE VOLUME FOR NON DEDUPLICATED COPY STORAGE POOL MAY TAKE A LONG TIME.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Deletion of physical tape copypool volume in a non-dedup storage
    pool may take a long time.   This occurs due to a check/step to
    uncatalog deduplicated bitfiles via an SQL which can take a long
    time as seen by a high DB2 Reg Exec.  A non-deduplicated copy
    pool should not need to do this check to uncatalog deduplicated
    bitfiles.
    
    The conditions for this apar are:
    - Delete Volume with discarddata=yes
    - The copy storage pool where the delete is occurring is not and
    has never been deduplicated.
    
    Customer/L2 Diagnostics (if applicable)
    Example from Tivoli Storage Manager server instrumentation
    trace:
     Thread 210247 AdmVolDelThread parent=210246
    12:31:16.751-->12:53:42.369
     Operation       Count  Tottime  Avgtime  Mintime  Maxtime
    InstTput  Total KB
     ---------------------------------------------------------------
    -------------
     DB2 Fetch Prep     12    0.042    0.004    0.001    0.006
     DB2 MFtch Prep     69    0.033    0.000    0.000    0.004
     DB2 Delet Prep      7    0.014    0.002    0.001    0.002
     DB2 Updat Prep      3    0.007    0.003    0.001    0.004
     DB2 Fetch Exec    451    0.071    0.000    0.000    0.000
     DB2 MFtch Exec    198    0.045    0.000    0.000    0.006
     DB2 Delet Exec    139    0.028    0.000    0.000    0.001
     DB2 Updat Exec      8    0.001    0.000    0.000    0.000
     DB2 Fetch         451    0.002    0.000    0.000    0.000
     DB2 MFetch        231    0.000    0.000    0.000    0.000
     DB2 Commit          1    0.002    0.002    0.002    0.002
     DB2 Reg Prep        5    0.014    0.003    0.000    0.006
     DB2 Reg Exec       72 1344.999   18.681    0.000   53.969 <---
    Here
     DB2 Reg Fetch      88    0.001    0.0000    0.000    0.000
     DB2 Connect         2    0.011    0.006    0.005    0.005
     Sleep               1    0.300    0.300    0.300    0.300
     Unknown                  0.040
     ---------------------------------------------------------------
    -------------
     Total                 1345.617
    
    
    *NOTE*
    None
    
    Platforms affected:
    All supported version Unix/Linux/Windows
    
    
    Initial Impact: Medium
    
    Additional Keywords: ZZ62 ZZ63 ZZ71 del vol dedup dedup'd
    

Local fix

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

    IT02769

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-06-24

  • Closed date

    2014-09-18

  • Last modified date

    2015-01-28

  • 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

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 71A

Reference #: IT02769

Modified date: 28 January 2015