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 are the steps you will take to improve performance of a poor performing query?
what is asm?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
internal architecture
what is a user-defined lock?
What are statistics, under what circumstances they go out of date, how do you update them?
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
what is a crs resource?
what do you understand by flashback feature of oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
how can you schedule a job in database?
what is logical system in sap basis
how can a session indicate its interest in receiving alerts?