IBM Support

IC60997: TSM 6.1 DEFINE DRIVE COMMAND FAILS WITH ELEMENT NUMBER LARGER THAN 32767, ALSO CAUSES UPGRADE FAILURE DURING INSERTDB

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When defining a drive on the TSM 6.1 server, if an element
    number higher than 32767 is specified, the command will
    fail. The following error may be returned to the activity
    log:
    -
    ANR0162W Supplemental database diagnostic information:
    -1:23513:-545 ([IBM][CLI Driver] [DB2/LINUXX8664] SQL0545N
    The requested operation is not allowed because a row does not
    satisfy the check constraint "TSMDB1.MMS_DRIVES.MMSDR_04"
    SQLSTATE=23513). (SESSION: XXXX)
    -
    Other messages may include ANR0158W, ANR0102E, ANR2032E and
    ANR9999D.
    -
    Also note that this problem can cause a TSM server upgrade
    from 5.x to 6.1 to fail during the INSERTDB phase. Previous
    versions of TSM allowed for the element number to be larger
    than 32767. Errors may be similar to:
    -
    ANR1338E One or more constraint violations were detected.
    Examine log file constrnt.log for details.
    ANR1396E INSERTDB: Process 1, database insert, has completed
    with errors.
    -
    The constrnt.log file may have an error like this:
    -
    <constraint_error timestamp="yyyymmddhhmmss"
    tablename="TSMDB1"."MMS_DRIVES" numcols="19">
    <violation type="OUT_OF_RANGE" colnum="4">
    ...
    <col colnum="4" colname="ELEMENT" coltype="INTEGER">
    -2536
    TSM Versions Affected:
    TSM 6.1 servers on all platforms
    Initial Impact:
    Medium
    Additional Keywords:
    MSGANR0162W MSGANR0158W MSGANR0102E MSGANR2032E MSGANR9999D
    define drive autodetect qualstar tsm61 zz61
    

Local fix

  • If possible, reconfigure the library device so that drive
    element numbers are smaller than 32767.
    Also see knowledge document 1384368 for
    information about this problem during
    upgrade of TSM.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Tivoli Storage Manager users of          *
    *                 version 6.1 server who use SCSI libraries    *
    *                 with drive element numbers greater than      *
    *                 32767.                                       *
    ****************************************************************
    * PROBLEM DESCRIPTION: See ERROR DESCRIPTION                   *
    ****************************************************************
    * RECOMMENDATION: Apply fixing level when available. This      *
    *                 problem is currently projected to be fixed   *
    *                 in level 6.1.2. Note that this is subject    *
    *                 to change at the discretion of IBM.          *
    ****************************************************************
    *
    

Problem conclusion

  • The Tivoli Storage Manager server has been corrected to allow
    element numbers greater than 32767.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC60997

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    61L

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-04-30

  • Closed date

    2009-05-05

  • Last modified date

    2009-05-08

  • 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

  • R61A PSY

       UP

  • R61H PSY

       UP

  • R61L PSY

       UP

  • R61S PSY

       UP

  • R61W PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"61L","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
08 May 2009