IC80659: TIVOLI STORAGE MANAGER V6 SQL COMMAND SELECT * FROM MGMTCLASSES RETURNS ZERO ROWS WHEN THE TABLE CONTAINS DATA

APAR status

• Closed as program error.

Error description

• A Tivoli Storage Manager SQL select command against the
  MGMTCLASSES table can incorrectly return zero rows if
  the DESCRIPTION column is set to "No Limit".
  
  Example:
  
  SELECT * FROM MGMTCLASSES
  ANS8001I Return code 4.
  
  while QUERY MGMTCLASS produces
  
  Policy    Policy    Mgmt       Default   Description
  Domain    Set Name  Class      Mgmt
  Name                Name       Class ?
  --------- --------- ---------  --------- -----------
  STANDARD  ACTIVE    FOREVER    Yes       No Limit
  
  
  Tivoli Storage Manager Versions Affected:
  Tivoli Storage Manager Server version 6.1, 6.2 and 6.3 on all
  platforms
  
  Initial Impact:
  low
  
  Additional Keywords:
  zz61 zz62 zz63 TSM select mgmt
  

Local fix

• - Remove or change the "No Limit" value in the DESCRIPTION field
    for the mgmtclass
  - Use the "QUERY MGMTCLASS" command to get the information.
  

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.2.5 and 6.3.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 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

• R62A PSY

     UP

• R62H PSY

     UP

• R62L PSY

     UP

• R62S PSY

     UP

• R62W PSY

     UP

• R63A PSY

     UP

• R63H PSY

     UP

• R63L PSY

     UP

• R63S PSY

     UP

• R63W PSY

     UP