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 difference between alias and synonym in db2?

1138

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2322

---

What is performance tuning db2?

1058

---

How do I connect my db2 database to ibm?

1045

---

What is the connection string to connect to the DB2 Database ?

1123

---

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

1170

---

Define db2 and its databases?

1054

---

What is schema in db2?

1018

---

What are catalog tables in db2?

1045

---

How would you find out the total number of rows in a db2 table?

1049

---

What is the role of union all and union

1122

---

what are bind concepts in db2 cobol?

1090

---

Why do chiropractors use drop table?

1101

---

What is the max length of sqlca?

1214

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1100

---