Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    12

    Unanswered: maximum size of a table object has been exceeded.

    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.

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    table limits

    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

  3. #3
    Join Date
    Nov 2004
    Posts
    374

    table limits

    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

  4. #4
    Join Date
    Jun 2004
    Posts
    12

    Solution?

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •