Answer / s

The obvious benefit is savings in disk space. Thus reduced
row length means more rows per page which means lesser
getpages. Fewer getpages mean less locks hence less CPU
costs and less I/O. Use of VARCHAR reduces the number of
bytes passed between DB2 and application. There is a CPU
cost associated with each byte of data moved.

Answer / sunil1405

when u declare a column with 10 bytes and only the field is
using 6bytes of storage , the balance 4 bytes will be
reclaimed ie its not wasted.

Answer / kums

Rather than storing the object in the data base, specify
the location of the object (image) by creating a column
with VARCHAR. This kind of approach may be used in web
technologies. pl correct if I'm wrong.

What are the isolation levels possible ?

3 Answers  

---

What is the significance of DB2 free space and what parameters control it?

1 Answers  

---

what is the soft code for deadlock ?

2 Answers   Logica CMG,

---

What does db2 mean?

0 Answers  

---

How to test SQL -911 error while developing COB-DB2 program

1 Answers   Satyam,

---

Update command

1 Answers  

---

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 Answers  

---

Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

3 Answers   IBM,

---

Return code 100 means?

6 Answers   Cap Gemini,

---

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers   CTS, IBM,

---

What is sqlcode -922 ?

2 Answers  

---

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  

---