DB2 add tablespace container but error SQL20318N

[former_member1332892]

I have experience with DB2 10.1. Since old tablespace exceed limit 4TB. I cannot fill-in table in that tablespace

(Error: DIA8710E Maximum table size was reached. )

So I tried to add new tablespace container by command:

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

But there is error:

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

As I check my tablespaces will be like this

C:\IBM\SQLLIB\BIN>db2 list tablespace containers for 2 show detail

Tablespace Containers for Tablespace 2

Container ID = 0

Name = F:\DB2\NODE0000\{DbName}\T0000002\C0000000.LRG

Type = File

Total pages = {NumberofPages}

Useable pages = {NumberofPages}

Accessible = Yes

How can I do?

[AlexGourdet]

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with Community Q&A, as the overview provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a Picture to your profile you encourage readers to respond.

[maria_shen]

Hello,

Regarding the LOB Object size limit, another reference could be note 2118415, where the reference notes of range partition are included.

2118415 - DB6: SQL0659 when accessing LONG / LOB data.

Thank you.