DB2
--
Questions
--
Followers
Top Experts
DB2 Table Spaces Broken ???
Hi There
Ok before i continue please note i work with SQL Server i am completely new to DB2.
We have a serious problem as DB2 will not start , there are many errors in windows event viewer.
For example
2005-02-15-10.00.21.656003
PID:188(db2syscs.exe) TID:3736 Appid:GB140137.LC10.017645
buffer pool services sqlbStartPools Probe:63
ADM6049E The database cannot be restarted because one or more table spaces
cannot be brought online. To restart the database specify the "DROP PENDING
TABLESPACES" option on the RESTART DATABASE command. WARNING! PUTTING A
TABLESPACE INTO THE DROP PENDING STATE MEANS THAT NO FURTHER ACCESS TO THE
TABLESPACE WILL BE ALLOWED. ITS CONTENTS WILL BE INACCESSIBLE THROUGHOUT THE
REMAINDER OF THE LIFE OF THE TABLESPACE AND THE ONLY OPERATION THAT WILL BE
ALLOWED ON IT IS "DROP TABLESPACE". There is no way in which it can be brought
back. It is important that you consider the consequences of this action as
data can be lost as a result. Before proceeding consult the DB2 documentation
and contact IBM support if necessary. The table spaces to specify in the DROP
PENDING TABLESPACES list are: "PSIMGR ".
My question is , is there anyway i can NOT lose whatever data is in this table space?
How can i rectify this problem with minimal data loss? Because DB2 won't even come up i cannot do any investigation about this tables space.
DO i have any option but to lose the table space?
Please help !!
Ok before i continue please note i work with SQL Server i am completely new to DB2.
We have a serious problem as DB2 will not start , there are many errors in windows event viewer.
For example
2005-02-15-10.00.21.656003
PID:188(db2syscs.exe) TID:3736 Appid:GB140137.LC10.017645
buffer pool services sqlbStartPools Probe:63
ADM6049E The database cannot be restarted because one or more table spaces
cannot be brought online. To restart the database specify the "DROP PENDING
TABLESPACES" option on the RESTART DATABASE command. WARNING! PUTTING A
TABLESPACE INTO THE DROP PENDING STATE MEANS THAT NO FURTHER ACCESS TO THE
TABLESPACE WILL BE ALLOWED. ITS CONTENTS WILL BE INACCESSIBLE THROUGHOUT THE
REMAINDER OF THE LIFE OF THE TABLESPACE AND THE ONLY OPERATION THAT WILL BE
ALLOWED ON IT IS "DROP TABLESPACE". There is no way in which it can be brought
back. It is important that you consider the consequences of this action as
data can be lost as a result. Before proceeding consult the DB2 documentation
and contact IBM support if necessary. The table spaces to specify in the DROP
PENDING TABLESPACES list are: "PSIMGR ".
My question is , is there anyway i can NOT lose whatever data is in this table space?
How can i rectify this problem with minimal data loss? Because DB2 won't even come up i cannot do any investigation about this tables space.
DO i have any option but to lose the table space?
Please help !!
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Hi Again
Another error is :
ADM2004E The Event Monitor "DB2DETAILDEADLOCK" was not activated because there
was not enough storage space in the database monitor heap. To remedy this
problem, increase the MON_HEAP_SZ DBM configuration parameter and restart the
instance.
As i said i don't work with DB2 , exactly where do i change configuration parametres?
Thanx
Another error is :
ADM2004E The Event Monitor "DB2DETAILDEADLOCK" was not activated because there
was not enough storage space in the database monitor heap. To remedy this
problem, increase the MON_HEAP_SZ DBM configuration parameter and restart the
instance.
As i said i don't work with DB2 , exactly where do i change configuration parametres?
Thanx
Before you do anything, can you provide the circumstances which brought you to this point, it may help in giving you a solution. You also need to specify the OS platform and version number of DB2.
Do you have a database backup available? If so, simply restore the database.
Do you have a database backup available? If so, simply restore the database.
Hi ghp7000
Ok we are running DB2 SDK 8.1.4 on WIndows Server 2003.
The tablespace issue we are simply going to drop them and recreate.
The main problem now is the other database with the MON_HEAP_SZ DBM problem, now the database has been marked as bad, ibm's site reccomends that one increases the MON_HEAP_SZ_DBM size through memory visualizer BUT this heap is for deadlock information , i think the more important problem is why are there so many deadlocks, could you please maybe help me with commands that will give us information on what objects these deadlocks are happening? As i think deadlocks are more the problem than the memory heap for them, if we resolve the deadlock issue the heap size should be sufficient.
Any input would be appreciated Thanx
Ok we are running DB2 SDK 8.1.4 on WIndows Server 2003.
The tablespace issue we are simply going to drop them and recreate.
The main problem now is the other database with the MON_HEAP_SZ DBM problem, now the database has been marked as bad, ibm's site reccomends that one increases the MON_HEAP_SZ_DBM size through memory visualizer BUT this heap is for deadlock information , i think the more important problem is why are there so many deadlocks, could you please maybe help me with commands that will give us information on what objects these deadlocks are happening? As i think deadlocks are more the problem than the memory heap for them, if we resolve the deadlock issue the heap size should be sufficient.
Any input would be appreciated Thanx
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Regarding deadlocks, of course the easiest way to avoid deadlocks is to NOT HOLD THE LOCK TOO LONG, IE, make sure to committ or rollback the transaction as soon as you are done. If the user sits there with the transaction executing, no amount of configuration will avoid the deadlock.
In addition, there is database parameter you can set as well:
http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.udb.doc/admin/c0005271.htm?resultof=%22%64%65%61%64%6c%6f%63%6b%22%20
In addition, there is database parameter you can set as well:
http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.udb.doc/admin/c0005271.htm?resultof=%22%64%65%61%64%6c%6f%63%6b%22%20
DB2
--
Questions
--
Followers
Top Experts
IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.