How to check DB2 LUW database write suspend state with db2pd

23 May,2017 by Jack Vamvas

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)

 

 

 

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

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.

Working...

Post a comment on How to check DB2 LUW database write suspend state with db2pd

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright