bertkerkhof
Technical User
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
anyone anyidea
thks
bert
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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DB2 inconsistancy
- Thread starter bertkerkhof
- Start date
- Status
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.
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
Similar threads
- Locked
- Question