IBM Support

IT26159: 'DB2INSTANCE -INSTANCE DB2INST2 -LIST' RUN AS ROOT REPORTS ERROR" LIBSQLHA: SQLHAGETOBJECTATTRIBUTE()"

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

  • The following db2diag.log errors are reported when the
    'db2instance -instance db2inst2 -list' command is run as root:
    
    2018-05-18-15.46.06.759068+480 I4098A339            LEVEL: Error
    PID     : 41615730             TID : 1              PROC :
    db2instance
    INSTANCE: db2inst2             NODE : 000
    HOSTNAME: purehost1
    EDUID   : 1
    FUNCTION: <0>, <0>, <0>, probe:3258
    DATA #1 : <preformatted>
    libsqlha: sqlhaGetObjectAttribute() call error from wrapper lib
    36
    2018-05-18-15.46.06.762013+480 I4438A288            LEVEL: Error
    PID     : 41615730             TID : 1              PROC :
    db2instance
    INSTANCE: db2inst2             NODE : 000
    HOSTNAME: purehost1
    EDUID   : 1
    FUNCTION: <0>, <0>, <0>, probe:3259
    DATA #1 : <preformatted>
    clus err msg :
    
    The db2diag.log error messages are being generated because we
    are querying for resource dependencies defined against the
    following db2dump mount resource as shown in lssam, but none
    exist:
    
    Online IBM.ResourceGroup:db2mnt-db2dump-rg Nominal=Online
    '- Online IBM.Application:db2mnt-db2dump-rs
    |- Online IBM.Application:db2mnt-db2dump-rs:purehost3
    |- Online IBM.Application:db2mnt-db2dump-rs:purehost4
    |- Online IBM.Application:db2mnt-db2dump-rs:purehost1
    '- Online IBM.Application:db2mnt-db2dump-rs:purehost2
    
    It is normal that dependencies against the db2dump mount
    resource are not defined because it is not a critical file
    system essential for database functionality.
    
    If these db2diag.log error messages are being observed, they can
    be safely ignored. It is expected to see these db2diag.log error
    messages if the DIAGPATH dbm cfg parameter is set to a
    GPFS(Spectrum Scale) mount path.
    

Local fix

  • Run "db2instance -list" under instance user.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT26159

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-09-02

  • Closed date

    2020-01-16

  • Last modified date

    2020-01-16

  • 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

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 January 2020