what is the difference between off-line back up and on-line
back up in ibm db2 udb?
- 2 Answers
- 8288 Views
- Zenith, I also Faced
- E-Mail Answers
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
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
what are the differences of where and if in SAS?
internal architecture
What the different components in replication and what is their use? : sql server DBA
What is dbcc? : sql server DBA
How do you open a cluster administrator? : sql server DBA
how can you process messages in order asynchronously?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
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?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the different types of indexes available in sql server? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What are the recovery models for a database? : sql server DBA
how can you implement fine-grained auditing?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
