what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,

---

What is a view? Why use it?

3 Answers  

---

If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

2 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,

---

How to resolve -504 sql code in DB2?

2 Answers   Cap Gemini,

---

---

Can one database have multiple instances?

0 Answers  

---

What is a recovery log?

1 Answers  

---

What is meant by AUTO COMMIT?

3 Answers  

---

Name some fields from SQLCA.

2 Answers  

---

Are view updateable?

0 Answers  

---

What is a plan and package in db2?

0 Answers  

---

What is the physical storage length of the data types date, time, and timestamp?

0 Answers  

---