db2表空間大小限制

今天我表空間無法擴，後來一查，原來超出表空間大小的限制了。看表空間的db2look，表空間為regular的。再一問，這個資料庫是從V8遷移到V9的。

SQL1139N  The total size of the table space is too big.

Explanation:

The size of the current table space is too big. The size of a REGULAR

table space is limited to 0x0100 0000 (16777216) pages while the size of

LARGE and TEMPORARY table spaces are limited to 0x2000 0000 (536870912)

pages.

User response:

Check the administration notification log for details. Reduce the size

of the table space and correct the SQL statement.

 sqlcode: -1139

 sqlstate: 54047

不管pagesize多大，表空間的page限制都是如上所示（db2 v9）

----------------