Answer / Sandeep Kumar Yadav

DBRM stands for Database Resource Manager in DB2. It is used to control and optimize the allocation of system resources, such as CPU and I/O, among multiple concurrent database sessions.

How to resolve -917 sql code in DB2?

3 Answers   Cap Gemini,

---

What is DCLGEN ?

2 Answers  

---

How can you classify the locks in db2?

1 Answers  

---

when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,

---

What is netezza database?

1 Answers  

---

What is precompiler in db2?

1 Answers  

---

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---

Name the various locking levels available?

1 Answers  

---

How do you eliminate duplicate values in db2?

1 Answers  

---

How to resolve deadlock issue

6 Answers   IBM,

---

How can the duplicate values be eliminated from db2 select?

1 Answers  

---

Name the lockable units in DB2?

1 Answers  

---