Convert the tablespace from normal to large

Hello,

Today I faced the following problem:

db2 "alter tablespace 12csdx resize (all 19067605)"
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1139N The total size of the table space is too big. SQLSTATE=54047

There are to option which you can take:
1. review the data stored in the tablespace,
2. convert the tablespace

If you decide to use the second option, use the following command:

db2 "ALTER TABLESPACE CONVERT TO LARGE"

be aware:
* It can be applied only on regular DMS table spaces,
* You cannot convert a table space that contains a data partition of a partitioned table that has data partitions in another table space,
* Conversion cannot be reversed after being committed,

0 members like this

Comment

You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

Comment by Kamalnath Vadapalli on January 21, 2010 at 12:04am: Hello ,

After converting the tablespaces to large , we also have to consider doing a reorg of the indexes for all the tables residing in this tablespace . If index reorg is not performed we some times get errors when trying to insert into the table.

Thanks,
Kamal.