-
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.
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
-
Forum Rules
|
|