Answer / s

LOCKSIZE is defined with the CREATE TABLESPACE DDL.

Answer / techie

Can anyone of you explain me the below statement.

"A solution used for lock escalation in past jobs have been
to have the jobs take an explicit lock on the partition
which prevents lock escalation."

How do i take lock on the partition level, what would be
the definition for it. I googled but couldnt get any

what are the SQL codes u freequently got?

2 Answers   Logica CMG,

---

What is cursor?

2 Answers  

---

What is the function of buffer manager?

1 Answers  

---

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers   IBM,

---

What is db2 isolation?

2 Answers  

---

How do I delete a table in db2?

0 Answers  

---

How do you prepare a COBOL + DB2 program from coading till execution ?

1 Answers   Amdocs, Xansa,

---

what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?

3 Answers   Cap Gemini, Tech Mahindra,

---

what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 Answers  

---

Can you access the DB2 Directory table using SQL?

3 Answers  

---

What is db2 connect?

0 Answers  

---

How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,

---