Answer Posted / sabahat khan

any table space will be in copy pending status
After a load is performed on the DB2 table,with log no
parameter
or
if load is performed without taking an image copy
or
if the job abend during load
or
if NOCOPYPEND parameter is not specified in syspunch dataset

in all of the above scenario our table space will be in
COPYPENDIND status.

-START(DBname)TBSPACE(Tablespace)ACCESS(FORCE)

What is meant by explain?

1194

---

What is the difference between bind and rebind in db2?

1511

---

What is lock escalation in db2?

1083

---

Define db2 and its databases?

1112

---

How can you find out the # of rows updated after an update statement?

1154

---

What does db2 plan contain?

1087

---

Define declaration generator (dclgen).

1172

---

What is null indicator in cobol db2?

1111

---

Why do we use cursor?

1162

---

How do I optimize a query in db2?

1148

---

What is bind plan?

1095

---

What is difference between isnull and coalesce?

1106

---

What is node in db2?

1102

---

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3205

---

What is a cursor in programming?

1112

---