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 to access db2 tables in mainframe?

1059

---

What does db2 plan contain?

1031

---

Name the various locking levels available?

1101

---

What is meant by union and union all?

1012

---

What is bind package and plan in db2?

1058

---

Explain various types of locks in db2?

1159

---

What are the contents of dclgen?

1114

---

What is the default page size of buffer pools?

1124

---

Give a brief description of db2 isolation levels?

1076

---

What is db2 catalog database?

1050

---

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2371

---

What is the syntax for FETCH in DB2 ?

1222

---

What action db2 takes when a program aborts in the middle of a transaction?

1156

---

How do I start db2 in windows?

1104

---

On which levels locks can be applied?

1143

---