Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
SystemAdmin
SystemAdmin
1143 Posts
ACCEPTED ANSWER

Pinned topic Add dbspace to a Table

‏2013-02-26T12:18:44Z |
Hi, I have a table that create by this statement:

CREATE TABLE informix.order_bulk (
orderdate DATE NOT NULL,
ordernumber INTEGER NOT NULL
)
FRAGMENT BY RANGE(orderdate) interval(1 units year) store in (orderdbs03, orderdbs04)
partition prv_partition
values < date('2010-01-01') in orderdbs03
EXTENT SIZE 4194219 NEXT SIZE 4194219
LOCK MODE ROW;

The question is, if I want to add another dbspace to the table, how do I do it?

Thanks.