Max record size?

[DB_2]

I was looking at DB2 SQL reference books by IBM and saw the maxium
size limits on CHAR, VARCHAR and other data types.

Is there a similar limit on the total number of bytes per row? In
other words, what is the maximum number of bytes that a table can have
per record?

Thanks in advance!

[Mark A]

"DB_2" <de*******@yahoo.com> wrote in message
news:9b**************************@posting.google.c om...

I was looking at DB2 SQL reference books by IBM and saw the maxium
size limits on CHAR, VARCHAR and other data types.

Is there a similar limit on the total number of bytes per row? In
other words, what is the maximum number of bytes that a table can have
per record?

Thanks in advance!

A row has to fit on a page. So it depends on what page size is defined for
the tablespace that the table is utilizing (either explicitly or by
default). The largest page size is about 32K (with room needed for page and
row overhead). Certain kinds of large objects can be stored by DB2 that are
larger than 32K (which I assume you know about), but these not stored in a
normal tablespace.

DB2 limits are documented in Appendix A SQL Limits. of the "SQL Reference
Vol 1".