Answer / s

Information about recovery.

How to check last update on table in db2?

0 Answers  

---

Which is faster delete or truncate?

0 Answers  

---

can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,

---

What is host variable?

0 Answers  

---

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 Answers  

---

What is the connection string to connect to the DB2 Database ?

0 Answers   MCN Solutions,

---

How do you insert a record with a nullable column?

2 Answers  

---

Explain what are the various isolation levels possible?

0 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers  

---

What is an asychronous write?

1 Answers  

---

What is an alias and how does it differ from a synonym?

3 Answers  

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---