Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 Answers  

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

Which catalog tables contain authorization information?

1 Answers  

---

What is meant by the attachment facility?

3 Answers  

---

why we create view.

5 Answers  

---

---

When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  

---

What is lock contention?

1 Answers  

---

What is Skeleton cursor table (SKCT)?

2 Answers  

---

How many Buffer pools are there in DB2 and what are they?

1 Answers   IBM,

---

which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,

---

What is declare cursor?

0 Answers  

---

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,

---