IBM Support

IC69367: 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

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * SUNOS                                                        *
    ****************************************************************
    * PROBLEM 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.          *
    * ...                                                          *
    * Too many signals.  Exiting program.                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 4                        *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 Version 9.7 Fix Pack 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC69367

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-06-22

  • Closed date

    2011-05-24

  • Last modified date

    2011-05-24

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

    IC69325

  • 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

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC69367

Modified date: 24 May 2011