What is a recovery log ?
A recovery log is a collection of records that describes the sequence of events that occur in DB2. The information is needed for recovery in the event of a failure during execution.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is the Difference between OLTP and OLAP ? 25.09.08
OLTP Current data Short database transactions Online update/insert/delete Normalization is promoted High volume transactions Transaction recovery...How will you monitor rollback segment status? 23.05.08
Querying the DBA_ROLLBACK_SEGS view The status available as follows : IN USE - Rollback Segment is on-line AVAILABLE - Rollback Segment available bur not on-...What are the uses of rollback segment ? 05.05.08
To generate read-consistent database information during database recovery and to rollback uncommitted transactions by the users....What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible ? 12.04.08
The tablespace is put into copy pending status....How would one remove old reorg information from the DB2 catalog ? 12.04.08
Run the MODIFY RECOVERY Utility....What is IMAGECOPY ? 18.03.08
It is full backup of a DB2 table which can be used in recovery....What is Recovery Console? 20.02.07
The Recovery Console is a feature of the Windows 2000 and Windows XP operating systems. It provides the means for administrators to perform a limited range of t...What is a Recovery Model? 16.08.06
A recovery model is a database property that controls the basic behavior of the backup and restores operations for a database. Recovery models determine how tra...What is recovery/error testing? 12.07.06
Recovery/error testing is testing how well a system recovers from crashes, hardware failures, or other catastrophic problems....Advantages of DBMS??Redundancy is controlled. 08.03.06
Unauthorised access is restricted. Providing multiple user interfaces. Enforcing integrity constraints. Providing backup and recovery....