|
Problem IC71399
|
Status: Closed |
db2pd commands may fail on Linux/Solaris platforms due to internal memory conflicts |
| product: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| 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.
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$ |
| 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: *
* . *
**************************************************************** |
| Local Fix: |
|
| Solution |
Fixed in DB2 Galileo version. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.09.2010
06.06.2011
06.06.2011 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
