IT14571: "SELECT * FROM BACKUPSETS" NOT SHOWING DEVCLASS

7.1.7.000-TIV-TSMSRV-SolarisSPARC
7.1.7.000-TIV-TSMSRV-Linuxs390x
7.1.7.000-TIV-TSMSRV-Linuxppc64
7.1.7.000-TIV-TSMSRV-WIN
7.1.7.000-TIV-TSMSRV-Linuxx86_64
7.1.7.000-TIV-TSMSRV-HP-UX
7.1.7.000-TIV-TSMSRV-AIX
IBM Spectrum Protect Server V7.1 Fix Pack 7 (7.1.7.000) Downloads

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