IBM Support

IT00331: SLOW SERVER RESPONSE ON WILDCARDED CUARCHQRY VERB

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The Tivoli Storage Manager might slowly respond to wildcarded
    cuArchQry verbs. The symptom typically is seen for clients that
    manage a huge amount of objects in a single filespace, e.g.
    Content Manager or Content Manager on Demand API applications.
    
    To verify you are affected by the APAR review a client SESSVERB
    VERBINFO PID TID trace. The section of interest looks like:
    <DATE> 10:40:06.634 &#65422;59637772&#65434; &#65422;1800&#65434; : cuarch.cpp( 970):
    cuArchQry: fsID: 10, hl: '/DOC', ll: '/653053GAA*'
    <DATE> 10:40:06.634 &#65422;59637772&#65434; &#65422;1800&#65434; : cuarch.cpp( 972):
    owner: '*', descr: '*'
    <DATE> 10:40:06.634 &#65422;59637772&#65434; &#65422;1800&#65434; : cuarch.cpp( 973):
    mgmtClass: 0, copyGroup: 0, ordering: true
    <DATE> 10:40:06.634 &#65422;59637772&#65434; &#65422;1800&#65434; : cuarch.cpp( 978):
    insDateLower: 00/00/00   00:00:00, insDateUpper: 00/00/35
    00:00:00
    <DATE> 10:40:06.634 &#65422;59637772&#65434; &#65422;1800&#65434; : cuarch.cpp( 982):
    expDateLower: 00/00/00   00:00:00, expDateUpper: 00/00/35
    00:00:00
    <DATE> 10:40:06.634 &#65422;59637772&#65434; &#65422;1800&#65434; : session.cpp(1615): Send
    Verb: Length:    88 Code: 00000046 Type: ArchQry
    <DATE> 10:40:06.634 &#65422;59637772&#65434; &#65422;1800&#65434; : session.cpp(1656): ->
    <DATE> 10:40:06.634 &#65422;59637772&#65434; &#65422;1800&#65434; : session.cpp(1383): Recv
    Verb:
    <DATE> 10:40:31.279 &#65422;59637772&#65434; &#65422;1800&#65434; : session.cpp(1523):
    Length:   166 Code: 000000C3 Type:    <- ArchQryRespEnhanced2
    
    You are hit by the APAR if you see both, the wildcarded
    cuArchQry ll parameter ('/653053GAA*'), and a fully qualified hl
    parameter ('/DOC') and finally the delay between "Recv Verb:"
    and the ArchQryRespEnhanced2 response returned.
    
    Looking at a server DBSTMT trace, you will find the following
    SQL statement generated:
    SELECT
    NODEID,FSID,OBJTYPE,HL,LL,INSDATE,OBJID,DESCR,RETINIT_DATE,OBJIN
    FO,
    
    OWNER,MCID,CGID,STG_HINT,CLNTTYPE,BKSETRET,SETDATATYPE,HELD,
            VOLDATEGMT,ALIASOF
    FROM "TSMDB1"."ARCHIVE_NAMEVIEW"
    WHERE (NODEID=? AND FSID=? AND OBJTYPE=? AND LL LIKE ? AND
    HLID=?)
    FOR READ ONLY
    OPTIMIZE
    FOR 10 ROWS
         WITH UR
    
    Here the combination of "LL LIKE ?" and "HLID=?" in the
    ARCHIVE_NAMEVIEW query confirm the APAR.
      Tivoli Storage Manager Versions Affected: all V6 V7
      Initial Impact: Medium
      Additional Keywords: TSM hash performance CM CMOD
    

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 levels 6.3.5 and 7.1.1. 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

    IT00331

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    63A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-03-14

  • Closed date

    2014-03-28

  • Last modified date

    2014-03-28

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • dsmserv
    

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



Document information

More support for: Tivoli Storage Manager

Software version: 63A

Reference #: IT00331

Modified date: 28 March 2014