Answer / s

When the number of row, page locks held per tablespace
exceeds the LOCKMAX value or NUMLKUS or NUMLKTS, the lock
is escalated to a tablespace lock

Answer / andank

The Answer # 1 is perfect. When Lock esculation happens,
DB2 issues a warning message, DSNI031I.

Please beaware Lock Escalation and Lock Promotion are two
different concepts.

Lock promotion is the action of exchanging one lock on a
resource for a more restrictive lock on the same resource,
held by the same application process.

database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

1 Answers  

---

What is cascading rollback?

0 Answers  

---

What is a Cartesian product?

2 Answers  

---

What are the three lock types?

2 Answers  

---

Can a Db2 table data be retrived through JCL?

4 Answers  

---

---

How does cobol compile db2 program?

0 Answers  

---

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---

how can we retrieve the 100 records of the file ?

2 Answers   IBM,

---

What are leaf pages?

3 Answers  

---

what is rebinding ?

1 Answers   IBM,

---

Is db2 relational database?

0 Answers  

---

how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,

---