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)

How do you concatenate the firstname and lastname from emp table to give a complete name?

603

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2279

---

Why select is not preferred in embedded sql programs?

715

---

Define sqlca.

649

---

How can we retrieve the total number of records in RPG & CLLE?

197

---

---

How can you classify the locks in db2?

636

---

Explain about rct.

654

---

How do I create a view in db2?

606

---

What is the purpose of using commit?

618

---

What is node in db2?

610

---

What is copy pending and check pending in db2?

578

---

What is bind package and plan in db2?

595

---

What is host variable?

597

---

What is null indicator in db2?

604

---

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

624

---