re-orging a table in 11.50FC3

Posted in 2014

Topics: Migration, Import/Export & Data Conversion

MARK UNDERWOOD — Thu, 27 Mar 2014 18:15:47 — source: IIUG Forums & Mailing Lists

What's the best way w/o unloading,dropping and recreating the table? Can't use repack and shrink, b/c we don't have the patch. Anyone know of another way? One of the tables is over 55 gig. Thanks!!

↪ replying to MARK UNDERWOOD

Everett Mills — Thu, 27 Mar 2014 18:44:42 — source: IIUG Forums & Mailing Lists

Have you tried ALTER FRAGMENT ON TABLE myTable INIT IN mydbspace? > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > MARK UNDERWOOD > Sent: Thursday, March 27, 2014 1:16 PM > To: ids@iiug.org > Subject: re-orging a table in 11.50FC3 [32839] > > What's the best way w/o unloading,dropping and recreating the table? > Can't use repack and shrink, b/c we don't have the patch. Anyone know > of another way? > One of the tables is over 55 gig. Thanks!! > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to MARK UNDERWOOD

Art Kagel — Thu, 27 Mar 2014 18:53:37 — source: IIUG Forums & Mailing Lists

Modify the table's mode to RAW, ALTER FRAGMENT ON tabname INIT IN dbspacename;, modify the mode back to STANDARD, archive the server. The dbspace you list in the ALTER FRAGMENT statement can be the same dbspace or a different on, it just has to have enough free space for the copy of the table. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on 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 Thu, Mar 27, 2014 at 2:15 PM, MARK UNDERWOOD <munderwood786@gmail.com>wrote: > What's the best way w/o unloading,dropping and recreating the table? Can't > use > repack and shrink, b/c we don't have the patch. Anyone know of another way? > One of the tables is over 55 gig. Thanks!! > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113459e611f5f904f59b1a9e