Answer / Vinika Choudhary

Logging in DB2 is used to record events that occur within the database, such as user activity, errors, and performance statistics. It helps in monitoring database activities, troubleshooting issues, and maintaining audit trails.

Can i insert bulk records into a db2 table using qmf of spufi only............!!!

2 Answers  

---

Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers  

---

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,

---

What do you mean by NOT NULL? When will you use it?

3 Answers  

---

What is DCLGEN ?

3 Answers  

---

How to resolve -917 sql code in DB2?

3 Answers   Cap Gemini,

---

Explain how can you do the explain of a dynamic sql statement?

1 Answers  

---

What is reorg and runstats in db2?

1 Answers  

---

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers   CTS, IBM,

---

what is Static and dynamic linking

1 Answers   Virtusa,

---

can all users have the privilage to use the sql statement select * (dml)?

1 Answers   IBM,

---

what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers   HCL,

---