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.

Can you tell me how can you find out the # of rows updated after an update statement?

709

---

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

706

---

What kind of database is db2?

662

---

How connect db2 database to datastage?

866

---

How to check last update on table in db2?

708

---

---

What does db2 stand for?

672

---

How to view db2 table structure?

684

---

How to create backup table in db2?

741

---

What is the use of value function?

728

---

What are the various data types available in db2?

711

---

Explain what are the various isolation levels possible?

676

---

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1737

---

How to get the ddl of a table in db2?

759

---

What is the maximum No of rows per page?

708

---

What is an instance in db2?

647

---