IT08819: ARITHMETIC DATA OVERFLOW ON "SELECT FROM AUDITOCC"

7.1.3.000-TIV-TSMSRV-WIN
7.1.3.000-TIV-TSMSRV-SolarisSPARC
7.1.3.000-TIV-TSMSRV-Linuxx86_64
7.1.3.000-TIV-TSMSRV-Linuxs390x
7.1.3.000-TIV-TSMSRV-Linuxppc64
7.1.3.000-TIV-TSMSRV-HP-UX
7.1.3.000-TIV-TSMSRV-AIX

APAR status

• Closed as program error.

Error description

• On Tivoli Storage Manager client nodes with very large
  filespaces, a dsmadmc select against the auditocc table might
  result in arithmetic data overflow.
  
  Here an example that compares Q AUDITOCC against the SELECT
  command:
  
  q auditocc LARGENODE
  
                        Node Name: LARGENODE
         Backup Storage Used (MB): 658 110 080.00
        Archive Storage Used (MB): 0.00
  Space-Managed Storage Used (MB): 1 549 424 896.00
          Total Storage Used (MB): 2 207 535 104.00
  
   Whereas the select would report the following TOTAL_MB:
  
   select * from auditocc where node_name='LARGENODE'
  
          NODE_NAME: LARGENODE
          BACKUP_MB: 548115264
     BACKUP_COPY_MB: 109994832
         ARCHIVE_MB: 0
    ARCHIVE_COPY_MB: 0
         SPACEMG_MB: 516492544
    SPACEMG_COPY_MB: 1032932352
           TOTAL_MB: -2087432192
  
  See the value reported for TOTAL_MB.
  The symptom is seen if the value reported exceeds what can be
  represented by an INTEGER value (2,147,483,647).
  
    Tivoli Storage Manager Versions Affected: all supported
    Initial Impact: Low
    Additional Keywords: TSM
  

Local fix

• consult Q AUDITOCC output
  

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.3. Note that this is      *
  * subject to change at the discretion of IBM.                  *
  ****************************************************************
  

Problem conclusion

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

• R71A PSY

     UP

• R71H PSY

     UP

• R71L PSY

     UP

• R71S PSY

     UP

• R71W PSY

     UP