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 execute stored procedure in db2 command editor?

1094

---

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1137

---

What is db2 stogroup?

1220

---

What are the various data types available in db2?

1142

---

what is diffrence b/w file-aid tool and file-aid utility???

4958

---

Explain about rct.

1128

---

Which is faster delete or truncate?

1175

---

When do you specify the isolation level?

1068

---

What is the clustering index in the db2 database?

1044

---

What does a deadlock mean in DB2?

1215

---

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

1114

---

What is buffer pool?

1155

---

What is the maximum No of rows per page?

1107

---

What is the maximum size of varchar data type in db2?

1174

---

How to resolve deadlock issue

20300

---