IBM Support

IT14571: "SELECT * FROM BACKUPSETS" NOT SHOWING DEVCLASS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The Tivoli Storage Manager Server SQL Command
    "Select * from Backupsets"
    may not show the device class used to generate the
    Backup Set,  returning an empty DEVCLASS field.
    For example, running the following SELECT from Administrative
    Command Line (dsmadmc):
    
    
    select * from backupsets where node_name='TSMNODE'
    
    will show:
    
         NODE_NAME: TSMNODE
         BACKUPSET_NAME: BKSET-11-MAR-2016.2172988898
         OBJECT_ID: 2172988898
         DATE_TIME: 2016-03-11 18:50:56.000000
         RETENTION: 61
         DESCRIPTION: Backupset of FS /admin,/var,/backup
         DEVCLASS:
         TYPE: BACKUPSET FULL
         TOC_EXISTS: YES
         DATATYPE: FILE
    
    
    The QUERY BACKUPSET command will display the Device Class field
    as expected.
    
    
    Tivoli Storage Manager Versions Affected:
    All supported versions of Tivoli Storage Manager Server
    
    
    
    Initial Impact:
    Low
    
    
    
    Additional Keywords:
    TSM QUERY BACKUPSET SELECT BACKUPSETS DEVICE CLASS Spectrum
    Protect DEVCLASS empty null SP
    

Local fix

  • Use the QUERY BACKUPSET command instead of the SELECT.
    

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

    IT14571

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    63A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-04-01

  • Closed date

    2016-06-22

  • Last modified date

    2016-06-22

  • 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: 63A

Reference #: IT14571

Modified date: 22 June 2016