Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DB2 inconsistancy

Status
Not open for further replies.

bertkerkhof

Technical User
May 2, 2005
4
NL
Since a few weeks working with db2 on w2k3 srvr but hv noticed databases often hv status inconsistance.like to know how to check why or how this happens

anyone anyidea

thks
bert
 
Database can be in an inconsistent state for various reasons. Here are some ways to check:
1)get db cfg and check for
a)Backup pending
b)Database is consistent
2)check which table is in the load pending or check pending state:
select tabname,status from syscat.tables where status ='C'
3)Can use Health Center to set up some alerts[for Database status - object health indicators]
4)Database snapshots.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top