Move a table to particular DB space
Hi All, How we can a move a particular table from one dbspace to another dbspace? Please help. Thx
Without unloading to a file and then loading the data in new tablespace, you
can use this statment to dynamically move the data :
alter fragment on table <table-name> init in <dbspace-name>
Be aware that that this statement logs the data movement activity (in a
logging database) . So if you have a large table to move you should have
plenty of logical log space.
--- On Sun, 10/11/09, DEEPAK JOSHI <djoshih@hotmail.com> wrote:
From: DEEPAK JOSHI <djoshih@hotmail.com>
Subject: Move a table to particular DB space [17473]
To: ids@iiug.org
Date: Sunday, October 11, 2009, 1:08 PM
Hi All,
How we can a move a particular table from one dbspace to another dbspace?
Please help.
Thx
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
ALTER FRAGMENT ON <tablename> INIT< IN dbspacename | fragmentation-clause>;
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. 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 Sun, Oct 11, 2009 at 4:08 PM, DEEPAK JOSHI <djoshih@hotmail.com> wrote:
> Hi All,
>
> How we can a move a particular table from one dbspace to another dbspace?
> Please help.
>
> Thx
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0023545bda28f9fb8a0475beac84
You can use the Alter fragment like Art and Ashutosh write or use the
onload/onunload command. they not affect your logical log.
Read the manual, have some pre-requisite to use onunload / onload.
document.write(this.location)http://publib.boulder.ibm.com/infocenter/idshelp/v1
15/topic/com.ibm.mig.doc/ids_mig_194.htm
document.write(this.location)
http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.mig.doc/ids_
mig_191.htm
--- Em dom, 11/10/09, DEEPAK JOSHI <djoshih@hotmail.com> escreveu:
De: DEEPAK JOSHI <djoshih@hotmail.com>
Assunto: Move a table to particular DB space [17473]
Para: ids@iiug.org
Data: Domingo, 11 de Outubro de 2009, 18:08
Hi All,
How we can a move a particular table from one dbspace to another dbspace?
Please help.
Thx
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
________________________________________________________________________________
____
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com