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.

How to find schema of a table in db2?

1008

---

What does sqlcabc has?

1046

---

What is difference between alias and synonym in db2?

1136

---

what is the role of the cursor in db2?

1060

---

What is the meaning concurrency in the db2 database?

1108

---

What do you mean by cursor?

988

---

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1233

---

What is the syntax for creating a table in the db2 database?

1103

---

What is lock escalation in db2?

1027

---

How to test SQL -911 error while developing COB-DB2 program

7556

---

Why do we need reorg in db2?

981

---

What is schema in db2?

1018

---

What is the difference between cursor stability and repeatable read isolation levels?

1169

---

What does db2 blu stand for?

1164

---

What is a bind in db2?

1039

---