Hi,
I am just trying to understand what the ROW lenght means exactly in DB2.

My understanding is that the maxium row length is in proportion to the page size.

According to this, it states the row limits:

http://ptgmedia.pearsoncmg.com/image...loads/appd.pdf

4KB Pages --- 4,056 bytes
8KB Pages --- 8,138 bytes
16KB pages --- 16,330 bytes
32KB pages --- 32,714 bytes

Ok so say I have columns of varchars that are 100 bytes each. Does this mean I can only have 40 such columns (max) in a row if my page size is 4KB?

What happens in the cases of CLOBs?

A CLOB can up to 2,147,483,647 bytes?

Surely this will smash row length limits no matter what the size is?

Enlighten me...

I presume the length is calculated whenever create table is executed and does not allow you to create a table with a rowlength that potentialy is larger than a page
a row must fit entirely on a page
lobs are special objects and use large tabelspaces - pages can be chained together to create a large logical page

As Guy says, LOB is stored seperately and therefore does not impact the table row width.
The Inline lobs are different though. They count towards the row width.

HTH

Sathyaram

So I am correct? If I have columns of varchars that are 100 bytes each, I can only have 40 such columns (max) in a row if my page size is 4KB?

yes...............