IBM Support

IT26967: DB2 DATABASE INVENTORY OPERATION MAY FAIL WITH LARGE NUMBER OF DATABASE PATHS

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 if a high number (about
    more than 100) database paths or database container paths are
    used. The Db2 database inventory operation returns as partial or
    failed and the Db2 database cannot be configured for a SLA
    policy in the IBM Spectrum Protect Plus GUI.
    
    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-09-28 09:36:12] DEBUG pid:11927680 MainThread __init__:
    #!/bin/sh
    echo ===SPPAgent-output===
    LANG=C
    db2 connect to T2P
    
    db2 -x 'select substr(type,1,20) as type, path from
    sysibmadm.dbpaths'
    
    [2018-09-28 09:36:12] DEBUG pid:11927680 MainThread __init__:
    sudo -n -u db2t2p -i /tmp/tmpGpbkS6
    [2018-09-28 09:36:12] INFO pid:11927680 MainThread run: Running
    command 'sudo -n -u db2t2p -i /tmp/tmpGpbkS6...'
    [2018-09-28 09:36:12] DEBUG pid:11927680 MainThread run: Trying
    to read stdout/stderr buffers and wait 0.1 seconds
    ...
    [2018-09-28 09:41:15] DEBUG pid:11927680 MainThread run: Trying
    to read stdout/stderr buffers and wait 30.1 seconds
    [2018-09-28 09:41:15] WARN pid:11927680 MainThread
    __get_db2_dbpath_and_dblog: Failed to determine database path
    and log path
    [2018-09-28 09:41:15] DEBUG pid:11927680 MainThread
    log_chained_exception: Printing entire exception chain:
    [2018-09-28 09:41:15] DEBUG pid:11927680 MainThread
    log_chained_exception: Exception type: <type
    'exceptions.TypeError'>
    [2018-09-28 09:41:15] WARN pid:11927680 MainThread
    log_chained_exception: 'NoneType' object is not iterable
    [2018-09-28 09:41:15] JOBLOG pid:11927680 MainThread
    appdiscovery: Detected instance: db2t2p
    [2018-09-28 09:41:15] JOBLOG pid:11927680 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 protecting Db2 *
    * databases.                                                   *
    ****************************************************************
    * 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 high counts of database
    paths or database container paths can be handled correctly and
    the database can be protected.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT26967

  • 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-02-04

  • Last modified date

    2019-02-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

    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