Results 1 to 2 of 2

Thread: DB2 Large Tablespace has one container that's exceed limit 4TB

  1. #1
    Join Date
    Apr 2023
    Posts
    1

    DB2 Large Tablespace has one container that's exceed limit 4TB

    Hi all,

    I used DB2 11.1, and has application that created table with USERSPACE1 using large tablespace to store large table with LOB column.

    Yesterday, I got this below message when try to insert new records:
    MESSAGE : ZRC=0x8404000A=-2080112630=SQLD_RC_MAX_OBJ_SIZE
    "ARCHITECTURAL PAGE LIMIT REACHED"
    DIA8710E Maximum table size was reached.

    As I investigated, I was found there is one large tablespace container file as below has 4TB.
    F:\DB2\NODE0000\{DbName}\T0000002\C0000000.LRG

    This Database has used Automatic Storage when created, and this tablespace is DMS.

    I tried to add new tablespace container into this tablespace but unfortune there is this error:

    DB2 ALTER TABLESPACE {TableSpace} ADD (FILE 'C0000001.LRG' 500G)

    SQL20318N The ALTER TABLESPACE statement failed because the change is not
    allowed for the type of table space. Table space name: "{TableSpace}". Table
    space type: "AUTOMATIC STORAGE". Incompatible clause: "ADD". SQLSTATE=42858


    How can I force this tablespace to create new container file to avoid used existing tablespace container that already exceeded 4TB limited file size?

    Best regards,
    DBA who was found nightmare.

  2. #2
    Join Date
    Feb 2014
    Location
    Riviera Beach, Maryland, USA
    Posts
    86

Tags for this Thread

Posting Permissions

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