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)

Explain packages.

660

---

What is meant by union and union all?

583

---

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1801

---

What is db2 purescale?

545

---

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

658

---

---

What is the syntax for FETCH in DB2 ?

672

---

How to find the number of rows in db2 tables?

614

---

What is buffer pool in the db2 database?

614

---

How does a cursor work?

554

---

What is runstats and reorg in db2?

791

---

Define data page.

628

---

Define sqlca.

647

---

What is image copy in db2?

566

---

What is a db2 package?

597

---

What is a page in db2?

609

---