Answer Posted / rshk

After a load is performed on the DB2 table, it will be in
Copy pending status. When the table is in copy pending
status, you cannot access the table. In order to release the
table from copy pending status, we need to force complete it
using the Db2 command:
-START(DBname)TBSPACE(Tablespace)ACCESS(FORCE)

Pls check the syntax of the above command.

What are iseries servers?

1075

---

Which isolation level provides highest data integrity?

1117

---

What is runstats utility in db2?

1019

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2852

---

How do we specify index to include or not during bind process.

2126

---

What is a system catalog table in db2?

1186

---

What is iseries database?

1046

---

Explain db2.

1034

---

What is the difference between drop table and delete table?

1208

---

How to restart a DB2 program?

1902

---

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

1185

---

What does reorg do in db2?

1029

---

What is rebind in db2?

1060

---

Explain the contention situations caused by locks?

1070

---

What is dbrm? What it contains? When it will be created?

1050

---