Answer Posted / lakshmisudha

locks are 2 types
1.explicet locks
cs,rr,ur,rs
2.implicet locks
shared,exclusive,update

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1185

---

Is schema the same as database?

1060

---

Explain how can you do the explain of a dynamic sql statement?

1126

---

What is an instance database?

1054

---

What is the purpose of using commit?

1100

---

How to view db2 table structure?

1018

---

What is the connection string to connect to the DB2 Database ?

1128

---

Is ibm db2 open source?

1076

---

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2099

---

What is db2? Explain.

1044

---

What is a db2 cursor?

1056

---

What is difference between rollback and commit?

1164

---

what is the responsibility of the construction superintendent

2147

---

What is the meaning concurrency in the db2 database?

1110

---

What action db2 takes when a program aborts in the middle of a transaction?

1156

---