Move a table to particular DB space
Deepak Joshi asked how to move a table to another dbspace. Ashutosh Khunte and Art Kagel gave ALTER FRAGMENT ON TABLE ... INIT IN dbspace, noting it logs the data movement so large tables need plenty of logical log space. Cesar Inacio Martins added onunload/onload, which do not use the logical log but have prerequisites.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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