Answer / s

Yes denormalization is done performance reasons.
Normalization will keep the related data in separate
tables. In order to get the data from the tables, DB2 uses
JOIN which could be resource intensive depending on the
number of tables used in the join and the size of the table.

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

0 Answers  

---

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

0 Answers  

---

What are the four lockable units for DB2?

1 Answers  

---

Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,

---

What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)

2 Answers  

---

---

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,

---

what is the role of the cursor in db2?

0 Answers  

---

What does CURRENTDATA option in bind indicate

1 Answers   IBM,

---

What is isolation level?

4 Answers  

---

What is db2 catalog database?

0 Answers  

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,

---

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,

---