IBM Support

IT14001: "SELECT * FROM LOG" FAILS WITH ANR0162W AND "SQL0413N IF ONE OF THE OUTPUT FIELDS IS OVER 99TB (99,999,999 MB)

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • "select * from log" run  from dsmadmc will fail with:
    
    ANR0162W Supplemental database diagnostic
    information:  -1:22003:-413 ([IBM][CLI Driver][DB2/LINUXX8664]
    SQL0413N
    Overflow occurred during numeric data type conversion.
    SQLSTATE=22003).
    
    ANR0516E SQL processing for statement select * from
    log  failed.
    
    if one or more of the outputs is larger than 99,999,999 MB
    
    The select run in DB2 will also fail:
    
    db2 "select * from log"
    
    SQL0413N  Overflow occurred during numeric data type conversion.
    SQLSTATE=22003
    
    
    "query log" and "query log f=d" will still report correctly.
    
    
    
    
    
    Tivoli Storage Manager Versions Affected:
    Tivoli Storage Manager Server 6.3.x and 7.1.x on all supported
    platforms
    
    
    Initial Impact: low
    
    Additional Keywords: SP TSM Spectrum Protect select log overflow
    size
    

Local fix

  • Run:
    "q log f=d"
    to get full outputs.
    

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.6. 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 number

    IT14001

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71L

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-02-26

  • Closed date

    2016-03-04

  • Last modified date

    2016-03-04

  • 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: 7.1.3

Reference #: IT14001

Modified date: 04 March 2016