IBM Support

IT08819: ARITHMETIC DATA OVERFLOW ON "SELECT FROM AUDITOCC"

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

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 number

    IT08819

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-05-11

  • Closed date

    2015-05-22

  • Last modified date

    2015-05-22

  • 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



Document information

More support for: Tivoli Storage Manager

Software version: 71A

Reference #: IT08819

Modified date: 22 May 2015