Answer / hraju.mr

Hi Naresh,
DB2 is a relational database from IBM and mainly used for
applications like any othr database products from
Oracle.the Procedure here is similar to work with
almost.There are 2 different platforms that you can go
ahead with this technology....as application programmer and
DataBase Architecture.here the second one is the one which
includes the responsibilities of designing
database,Tablespaces ..taking backups running the
Utitlities both Online and Offline..ofcourse this is an
intersting subject that u can always rely upon..

What happens on checkpoint? : sql server DBA

0 Answers  

---

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

0 Answers  

---

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers  

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  

---

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

0 Answers  

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---

what are the differences of where and if in SAS?

0 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  

---