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)

Is ibm db2 open source?

1013

---

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1029

---

What is temporal table in db2?

988

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2167

---

What are the rules for db2 programming?

1041

---

What is collection in db2 bind?

961

---

What is difference between isnull and coalesce?

1006

---

B37 abend during spufi?

1405

---

Why do chiropractors use drop table?

1044

---

What is database reorganization?

1053

---

What is commit in db2?

996

---

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1102

---

What is an instance in db2?

982

---

Is db2 a programming language?

983

---

How many databases are there?

989

---