Hi there,

I was loading my database with a batch of new data when I suddenly received this message:

Maximum size of a table object has been exceeded.

I was unaware that there was a maximum size for a table. Is this the case? Do tables get full? Do I have to create a new table and start updating it instead and then do a table join when querying?

It's DB2 8.1 Enterprise Edition.

Thanks for the help.

tables can be limited - but this limit is as big as the database limit :
do not know the exact limit but anyhow Terra.... (see sql reference)
Do you have the sql code for this error ?
do you use dms or sms tablespace
maybe the row length is hitting a limit because of page size used for tablespace.
sqlcode shoul reveal the cause of this error ?
Hope this will help
Best Regards, Guy Przytula

copied from the book
Database Manager Page Size Specific Limits

Description 4K page 8K page size limit 16K page 32K page size limit
Most columns in a table
500 1 012 1 012 1 012
Maximum length of a row including all overhead
4 005 8 101 16 293 32 677
Maximum size of a table per partition (in gigabytes)
64 128 256 512


Best Regards, Guy Przytula

What if I create a partitioned tablespace for this table? Would that solve the problem?

That allows me up to 254 partitions of up to 64GB each, correct?

Thanks very much.

VX