Answer Posted / 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

Where do you specify them?

681

---

What is coalesce in db2?

680

---

How to take backup of table in db2?

599

---

What is package in db2 mainframe?

555

---

Define db2.

670

---

---

What is the reason behind not using select * in embedded sql programs?

601

---

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

638

---

What is the purpose of rollback and commit?

593

---

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10760

---

What are the contents of a dclmgen?

628

---

How can you count the number of rows from a table tab?

633

---

What is db2 plan table?

619

---

What is the advantage in De-normalizing tables in DB2?

743

---

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

604

---

Define db2 and its databases?

618

---