IBM Support

IT26971: DB2 INVENTORY FAILS WITH OVERFLOWERROR WHILE CHECKING FOR FREE SPACE ON A VOLUME GROUP

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The IBM Spectrum Protect Plus Db2 Application inventory
    operation of a Db2 database might fail in case of logical
    volumes have very large Device IDs (major, minor).
    
    In the Joblog the inventory operation ends with
    Detecting database: T2P
    Successfully connected to the Db2 database T2P.
    The number of partitions for database T2P: 1
    Detected instance: db2t2p
    --- Finished discovery for db2 agent ---
    
    But no DBPATH or DB_STORAGE_PATH are found. In the corresponding
    command.log the following error can be found:
    
    [2018-10-02 17:48:08] DEBUG pid:17236070 MainThread
    get_VGname_and_size_and_freespace_of_mount_point: Device of
    mountpoint /db2/T2P/log_dir is /dev/logdirlv
    [2018-10-02 17:48:08] DEBUG pid:17236070 MainThread __init__:
    ['sudo', '-n', '-i', '/usr/sbin/mount']
    [2018-10-02 17:48:08] INFO pid:17236070 MainThread run: Running
    command '['sudo', '-n', '-i', '/usr/sbin/mount']...'
    [2018-10-02 17:48:08] DEBUG pid:17236070 MainThread run: Command
    line 'sudo -n -i /usr/sbin/mount' has ended with exit code 0.
    
    stdout:
    [YOU HAVE NEW MAIL]
      node       mounted        mounted over    vfs       date
    options
    -------- ---------------  ---------------  ------ ------------
    ---------------
             /dev/hd4         /                jfs2   Aug 27 15:41
    rw,log=/dev/hd8
             /dev/hd2         /usr             jfs2   Aug 27 15:41
    rw,log=/dev/hd8
    ...
             /dev/sapdata1lv  /db2/T2P/sapdata1 jfs2   Aug 27 17:41
    rw,log=INLINE
             /dev/sapdata2lv  /db2/T2P/sapdata2 jfs2   Aug 27 17:41
    rw,log=INLINE
             /dev/sapdata3lv  /db2/T2P/sapdata3 jfs2   Aug 27 17:41
    rw,log=INLINE
             /dev/sapdata4lv  /db2/T2P/sapdata4 jfs2   Aug 27 17:41
    rw,log=INLINE
    
    stderr:
    
    [2018-10-02 17:48:08] DEBUG pid:17236070 MainThread
    log_chained_exception: Printing entire exception chain:
    [2018-10-02 17:48:08] DEBUG pid:17236070 MainThread
    log_chained_exception: Exception type: <type
    'exceptions.OverflowError'>
    [2018-10-02 17:48:08] WARN pid:17236070 MainThread
    log_chained_exception: can't convert negative number to unsigned
    long
    [2018-10-02 17:48:08] JOBLOG pid:17236070 MainThread
    appdiscovery: Detected instance: db2t2p
    [2018-10-02 17:48:08] JOBLOG pid:17236070 MainThread
    app_discovery: --- Finished discovery for db2 agent ---
    
    
    Products & versions affected:
    IBM Spectrum Protect Plus Version 10.1.2 using Db2 Application
    Agent
    
    Platforms affected:
    AIX, Linux
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of the IBM Spectrum Protect Plus 10.1.2 with DB2 agent *
    * performing application inventory.                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This problem is currently *
    * projected to be fixed IBM Spectrum Protect Plus level        *
    * 10.1.2.271 and 10.1.3. Note that this is subject to change   *
    * at the discretion of IBM.                                    *
    ****************************************************************
    

Problem conclusion

  • The issue has been corrected so that any i-node values will be
    correctly processed.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT26971

  • Reported component name

    SP PLUS

  • Reported component ID

    5737SPLUS

  • Reported release

    A12

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-11-14

  • Closed date

    2019-01-21

  • Last modified date

    2019-01-23

  • 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

    SP PLUS

  • Fixed component ID

    5737SPLUS

Applicable component levels

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A12","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
30 January 2024