Search dba-db2.com
*Use the Comments section for questions
Recent Posts
How to check DB2 LUW database write suspend state with db2pd
23 May,2017 by Tom Collins
DB2 LUW write suspend state is commonly checked during a splitting of mirrored database.I’d like the flexibility of checking via the db2pd monitoring tool, How can I get the output in db2pd to check if a DB2 database is in the write suspend state?
Answer: There’s a couple of different things you can check in this situation. The db2pd tool will allow you to check and report on the database configuration and to identify if the database is in write suspend state.
This command will return the relevant information. Check for the item “database is in write suspend state”
db2pd -db MYDB -dbcfg
Another thing you may want to check if the database is active. Essentially you’re checking if there are any connections. Use:
Db2 list active databases
If you'd like to read more about using db2pd , here are some posts which will assist in explaining db2pd option
db2pd troubleshooting guide (DBA DB2)
DB2 performance monitoring with db2pd (DBA DB2)
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright
Posted by: |