IC65336: SELECT OUTPUT FOR NUMERICAL DATA FROM VOLUMES TABLE IS INCORRECTLY LEFT JUSTIFIED

APAR status

• Closed as program error.

Error description

• Customer select output for numerical data from volumes table in
  TSM 5.5 is right justified. After upgrading to TSM 6.1 the same
  select numerical data output is now left justified.
  Customer/L2 Diagnostics (if applicable)
  Example of Select statement issued:
  select -
    cast(stgpool_name as char(16)) as "Storage Pool", -
    cast(access as char(15)) as "Access", -
    cast(status as char(10)) as "Status", -
    cast(count(*) as decimal(3,0)) as "Tapes", -
    cast(sum(est_capacity_mb / 100 * pct_utilized) / 1024 -
    as decimal(9,1)) as "Gbyte Used", -
    cast(sum(est_capacity_mb) / 1024 as decimal(9,1)) as "Gbyte
  Cap." -
  from volumes -
  where -
    stgpool_name like '%LTO%' -
  group by stgpool_name, access, status
  TSM 5.5 select output:
  Storage Pool       Access          Status     Tapes  Gbyte Used
  Gbyte Cap.
  ------------------ --------------- ---------- ----- -----------
  -----------
  BACKLTO1           READWRITE       FILLING        8      2037.7
  3658.6
  BACKLTO1           READWRITE       FULL          21      7673.7
  11407.7
  BACKLTO3           READWRITE       FILLING        5      1003.6
  2000.0
  BACKLTO3           READWRITE       FULL          47     13996.3
  18522.9
  BACKLTO6           READWRITE       FILLING       29     10689.1
  14674.6
  BACKLTO6           READWRITE       FULL         246    163648.9
  202987.1
  COPYLTO2           READWRITE       EMPTY         21         0.0
  0.0
  COPYLTO2           READWRITE       FILLING        6      4430.3
  6318.3
  COPYLTO2           READWRITE       FULL         173    193969.1
  253404.4
  TSM 6.1 select output:
  Storage Pool      Access           Status      Tapes  Gbyte Used
  Gbyte Cap.
  ----------------- ---------------- ----------- ------
  ------------ ------------
  BACKLTO1          READWRITE        FILLING     8      2425.6
  3811.2
  BACKLTO1          READWRITE        FULL        20     7255.9
  10721.9
  BACKLTO3          READWRITE        FILLING     6      1004.0
  2400.0
  BACKLTO3          READWRITE        FULL        49     14634.0
  19313.6
  BACKLTO6          READWRITE        FILLING     35     11113.9
  16744.1
  BACKLTO6          READWRITE        FULL        228    150206.9
  187826.1
  COPYLTO2          READWRITE        EMPTY       23     0.0
  0.0
  COPYLTO2          READWRITE        FILLING     6      5201.7
  6218.1
  COPYLTO2          READWRITE        FULL        171    182656.8
  250386.6
  *NOTE*
  Both TSM 5.5 and 6.1 show the data types as being the same -
  decimal.  Decimal is a valid DB2 data type.
  Select output for numerical data for all TSM 6.1 tables may be
  incorrectly left justified.
  Platforms affected:
  TSM 6.1 Unix/Linux/Windows
  
  Initial Impact: Low
  Additional Keywords: select TSM column data
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager server users of   *
  *                 the SELECT command.                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: See ERROR DESCRIPTION.                  *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available. This      *
  *                 problem is currently projected to be fixed   *
  *                 in level 6.1.4. Note that this is            *
  *                 subject to change at the discretion of IBM.  *
  ****************************************************************
  *
  

Problem conclusion

• This problem was fixed.
  Affected platforms: AIX, HP-UX, Sun 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

• R61A PSY

     UP

• R61H PSY

     UP

• R61L PSY

     UP

• R61S PSY

     UP

• R61W PSY

     UP

• R61Z PSY

     UP