Add dbspace to a Table
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.
ALTER FRAGMENT .. ADD INTERVAL IN (some_new_dbspace).
Please check the syntax guide, ALTER FRAGMENT statement description
On Wed, Feb 27, 2013 at 12:23 AM, MOHAMMAD IRFAN <irfan199@yahoo.com> wrote:
> 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.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
--f46d043d67719a9efb04d6aa2fc6
ALTER FRAGMENT FOR table "informix".order_bulk
FRAGMENT BY RANGE(orderdate) interval(1 units year) store in ( orderdbs03,
orderdbs04, new_dbspaces_here )partition prv_partition
values < date('2010-01-01') in orderdbs03;
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Tue, Feb 26, 2013 at 6:23 PM, MOHAMMAD IRFAN <irfan199@yahoo.com> wrote:
> 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.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--485b390f7b20d7a59904d6ab2827
ALTER FRAGMENT ON TABLE informix.order_bulk
MODIFY INTERVAL STORE IN (orderdbs03,orderdbs04, newdbs);
John F. Miller III
STSM, Lead Architect
miller3@us.ibm.com
503-747-1336
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 02/26/2013 04:23:29 PM:
> From: "MOHAMMAD IRFAN" <irfan199@yahoo.com>
> To: ids@iiug.org
> Date: 02/26/2013 04:49 PM
> Subject: Add dbspace to a Table [29604]
> Sent by: ids-bounces@iiug.org
>
> 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.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Thank you all. Sorry I didn't search the infocenter throughly.