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

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

Question Posted / guest

2 Answers
9151 Views
Zenith, I also Faced
E-Mail Answers

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

What purpose does the model database server? : sql server DBA

0 Answers

Name a tablespace automatically created when you create a database.

5 Answers

What is checkpoint?

3 Answers Accenture,

What types of replication are supported in sql server? : sql server DBA

0 Answers

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers

When a user process fails, what background process cleans up after it?

1 Answers

what is the purpose of catlaog in oracle rman?

2 Answers Value Labs,

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers

What is the difference between LMT & DLT?

1 Answers CTS,

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

0 Answers EDS,

Name three advisory statistics you can collect.

1 Answers

How to start SQL Server in minimal configuration mode?

1 Answers

For more DB Administration Interview Questions Click Here