TechQA.

alter tablespace db2 when the Table space type is "AUTOMATIC STORAGE"

1.6k views Asked by Panadol Chong At 18 November 2014 at 09:56

Good day,

I would like to alter a tablespace to bigger size. The following is my query:

ALTER TABLESPACE USERSPACE1
     resize (ALL 8192)

Then I hit error as follow:

[Error Code: -20318, SQL State: 42858]  The ALTER TABLESPACE statement failed because the change is not allowed for the type of table space. Table space name: "USERSPACE1". Table space type: "AUTOMATIC STORAGE". Incompatible clause: "RESIZE".. SQLCODE=-20318, SQLSTATE=42858, DRIVER=4.15.82

Look like the automatic storage restrict me to extends the size. Any ideas?

There are 0 answers