what is the difference between off-line back up and on-line
back up in ibm db2 udb?
Answer Posted / 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 |
Post New Answer View All Answers
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What authentication modes does sql server support? : sql server DBA
how can you connect from 10g user to 11g user??
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
how can you process messages in order asynchronously?
What is a system database and what is a user database? : sql server DBA
when does an alert gets signaled?
what do you understand by flashback feature of oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How would you extract DDL of a table without using a GUI tool?
what is logical system in sap basis
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?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What is fill factor? : sql server DBA