IBM Support

IC69325: db2pd commands may fail on Linux/Solaris platforms due to internal memory conflicts

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Running the db2pd command with application-side private memory
    set encounetered the following error msg:
    
    
    bash-3.00$ db2  LIST ACTIVE DATABASES
    
                               Active Databases
    
    Database name                              = TOOLSDB3
    Applications connected currently           = 1
    Database path =
    /product/raid1dsk1/db2/db2inst2/db2inst2/NODE0000/SQL00002/
    
    bash-3.00$ db2 connect to toolsdb3
    
       Database Connection Information
    
     Database server        = DB2/SUN64 9.5.5
     SQL authorization ID   = DB2INST2
     Local database alias   = TOOLSDB3
    
    bash-3.00$ db2pd -memsets -db TOOLSDB3
    
    Database TOOLSDB3 not activated on database partition 0.
    
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Too many signals.  Exiting program.
    
    - same error for memb and mempools.
    
    bash-3.00$ db2pd -memb -db toolsdb3
    Database TOOLSDB3 not activated on database partition 0.
    All memory blocks in Database  set.
    
    bash-3.00$ db2 activate db toolsdb3
    SQL1490W Activate database is successful, however, the database
    already been activated on one or more nodes.
    
    bash-3.00$ db2pd -mempools -db toolsdb3
    Database TOOLSDB3 not activated on database partition 0.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Changing data structure forced command termination.
    Too many signals.  Exiting program.
    bash-3.00$
    

Local fix

Problem summary

  • db2pd commands may fail on Linux/Solaris platforms due to
    internal memory conflicts
    

Problem conclusion

  • First Fixed in DB2 Version 9.5 Fixpack 7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC69325

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-06-18

  • Closed date

    2011-03-16

  • Last modified date

    2011-03-16

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC69367 IC71399

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 March 2011