SQL Tips for DB2 LUW

with Tags: length

Featured Blog Entries

All posts

Size matters: A handy routine to compute the defined row size of a table

Comments (10) Visits (25532)

Background Have you ever seen: "SQL0670N The row length of the table exceeded a limit of "<length>" bytes. (Table space "<tablespace-name>".)" When creating or altering a table DB2 imposes limits on the total worst case size of a row. This size depends on the page size of the tablespace in which the table resides: 4005 bytes in a table space with a 4K page size 8101 bytes in a table space with an 8K page size 16293 bytes in a table space with an 16K page size 32677 bytes in a table space with an 32K... [More]

Tags: table row width length size sql0670n 670 sqlcode pagesize getrowsize

Blogs

SQL Tips for DB2 LUW

About this blog

Links

Tags

Recent tweets

Size matters: A handy routine to compute the defined row size of a table