« Technical Interview & Viva Questions : KyaPoocha.com home page
« How would one remove old reorg information from the DB2 catalog ?
Where is the access path logic created by the DB2 Optimizer stored ? »



What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible ?


The tablespace is put into copy pending  status.



Explore posts in the same categories: Database Interview Questions


BOOKMARK THIS : del.icio.us | Digg it | Furl | reddit |

Related Questions :

  • What is a Recovery Model?
    • A recovery model is a database property that controls the basic behavior of the backup and restores operations for a...
  • 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...
  • What is IMAGECOPY ?
    • It is full backup of a DB2 table which can be used in recovery....
  • What is Recovery Console?
    • The Recovery Console is a feature of the Windows 2000 and Windows XP operating systems. It provides the means for...
  • What is cold backup, hot backup, warm backup recovery?
    • Cold backup (All these files must be backed up at the same time, before the databaseis restarted). Hot backup (official...
  • How will you monitor rollback segment status?
    • Querying the DBA_ROLLBACK_SEGS view The status available as follows : IN USE - Rollback Segment is on-line AVAILABLE - Rollback Segment available bur...
  • Why is PeopleSoft no longer supporting Apache Jserv ?
    • Apache JServ was a servlet engine that was supported in PeopleTools 8.1x. This support has been removed from PeopleTools 8.4...
  • How would one remove old reorg information from the DB2 catalog ?
    • Run the MODIFY RECOVERY Utility....
  • Advantages of DBMS??Redundancy is controlled.
    • Unauthorised access is restricted. Providing multiple user interfaces. Enforcing integrity constraints. Providing backup and recovery....
  • What is recovery/error testing?
    • Recovery/error testing is testing how well a system recovers from crashes, hardware failures, or other catastrophic problems....

    Comments are closed.