IT10903: "QUERY AUDITOCC" OUTPUT SHOWS WRAPPED FIELDS

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

APAR status

• Closed as program error.

Error description

• Fields in "QUERY AUDITOCC" output  are wrapped if the value does
  not fit into the corresponding fields.
  
  
  
  Example:
  
  QUERY AUDITOCC
  ==============
  Node Name  Backup       Archive  Space-Managed      Total
             Storage      Storage   Storage Used     Sorage
             Used (MB)  Used (MB)            (MB)  Used (MB)
  ---------  ---------  ---------  -------------   ---------
  NODE1      11,109,90          0              0   11,109,90 <====
                     1                                     1 <====
  NODE2         40,755          0              0      40,755
  
  
  select * from occupancy
  =======================
  NODE_NAME                 BACKUP_MB
  --------------------      ---------
  NODE1                      11109901
  NODE2                         40755
  
  
  This is caused by a field overflow in the record, where the
  fields are wrapped to the next line.
  
  (see the lines marked with "<====").
  
  
  Tivoli Storage Manager Versions Affected:
  Tivol Storage Manager 6.3.x , 7.1.x on all platforms
  
  Initial Impact: Low|Medium|High
  Low
  
  Additional Keywords:
  zz63, zz71, AUDITO, AUDITOCC, OCCUPANCY,TSM
  

Local fix

• You might see wrapped fields like this occasionally, so if you
  are using scripts to analyze columns you might want to take this
  into consideration.
  
  Use  'select * from occupancy' instead of 'QUERY AUDITOCC'
  

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