"bad page", especially in table, is a risk for database maintenance.
The particular access
attempt for corrupt blocks may not occur often, and corrupt DB2 blocks
are not recognized during a database backup, corrupt blocks can remain
undetected in an UDB system for a long time.
The potential solution is:
1) Restore from a GOOD backup and rollforward (Recommended). The
problem is backup normally is kept for 30 days so we must find the bad
page in DB with retention period.
2) db2dart /DDEL to dump the data, db2dart /IP to initialize the
corrupt page, and then recreate the tabel, upload the data. The
problem is data lost may happen and we need open an PMR.
Anyway, we need check the bad page efficiently. My question is:
* Which tool is recommended? db2dart or "inspect database" command?
* Can we inspect a backup instead of the online database to avoid
performance issue?
* In general, how fast is it? Suppose it takes 10 hours for us to
backup the database to Tivoli.
P.S. It is a simple DBA task on Oracle platform.
Any comment is appreciated.
TIA
James