what is the difference between off-line back up and on-line
back up in ibm db2 udb?
- 2 Answers
- 8088 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
What is the difference between clustered and non-clustered index? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What is replication? : sql server DBA
what is grd?
What are the different types of indexes available in sql server? : sql server DBA
how can you enable flashback feature?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
how can you find out if a table can be redefined?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What is dbcc? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
