Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what is the difference between off-line back up and on-line
back up in ibm db2 udb?

Answers were Sorted based on User's Feedback



what is the difference between off-line back up and on-line back up in ibm db2 udb?..

Answer / guest

online backup:

1.Inconsistent
2.database in open state.
3.Archive mode must set

offline:

1.consistent
2.db in close
3.No need archive mode

Is This Answer Correct ?    21 Yes 4 No

what is the difference between off-line back up and on-line back up in ibm db2 udb?..

Answer / vishal sharna

offline backup is the traditional backup in which we cannot
take the backup untill the application is closed but its
quite consistent,but as we know its very cost effective to
close all the application and then take the backup,so we
will take the online backup.in this case we an take the
backup of running aplication but set the recovery log mod
to rollforward,with the help of it we can restore our
database to the most recent state.

Is This Answer Correct ?    5 Yes 4 No

Post New Answer

More DB Administration Interview Questions

Oracle 11g new features?

2 Answers  


List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers  


what do you understand by fine-grained auditing?

0 Answers   Oracle,


what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  


what is grd?

0 Answers   Oracle,


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  


What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  


how can you schedule a job in database?

0 Answers   Oracle,


How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  


What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  


Give two examples of referential integrity constraints.

2 Answers  


Categories