Answer / Jay Prakash

In DB2, there are several types of locks including Share Locks (S-locks), Exclusive Locks (X-locks), Intent Share Locks (IS-locks), and Intent Exclusive Locks (IX-locks). These locks are used to manage concurrent access to database objects.

How can you display the current date & current time ?

1 Answers   Cap Gemini,

---

What is index cardinality?

3 Answers  

---

I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,

---

What is the difference between TYPE 1 index & TYPE 2 index

1 Answers   IBM,

---

how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,

---

What will the DB2 optimizer do?

2 Answers  

---

What information is held in SYSIBM.SYSCOPY?

1 Answers  

---

how to unload different table data into different gdg files/ vsam files.

3 Answers  

---

I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

1 Answers   Cap Gemini,

---

What are the Isolation levels possible ?

5 Answers  

---

What is DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  

---

Where is the output of EXPLAIN stored?

2 Answers  

---