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

How can you enable a trace for a session?

1 Answers  


what is the difference between db2start command and start database manager command?

1 Answers  


What's the benefit of "dbms_stats" over "analyze"?

1 Answers  


What is replication? : sql server DBA

0 Answers  


How would you determine the time zone under which a database was operating?

2 Answers  


currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  


If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  


If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  


Where in the Oracle directory tree structure are audit traces placed?

1 Answers  


hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,


What would you do with an "in-doubt" distributed transaction?

0 Answers  


Categories