1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / guest

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 are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

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

2 Answers  

What are the recovery models for a database? : sql server DBA

0 Answers  

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

0 Answers  




Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

How can you gather statistics on a table?

3 Answers  

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

For more DB Administration Interview Questions Click Here
Categories