WHere did my data go?!
Neil Truby on IDS 11.50.FC8W2XB fragmented a 64 million row table round robin over four dbspaces, then ran alter fragment init in dbs1 to restore it, after which the table was empty. He soon reported he had found the cause, without saying what it was, and asked to move on. Others joked about it. The cause was not stated.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
IBM Informix Dynamic Server Version 11.50.FC8W2XB on Solaris:
I fragmented a table into multiple dbspaces to see how long it would
take. No problems with all this, all 64 million rows fragmented, about
16m into each database:
set pdqpriority 95 ;
alter fragment on table <tablename> init fragment by roundrobin in arcdbs1,arcdbs2,arcdbs3,arcdbs4;
.. took about 20 minutes and moved all 65m rows into 4 new fragments each with
about 16 million rows each, as expected.
Then to put it back as it was:
set pdqpriority 95 ;
alter fragment on table <tablename> init in dbs1;
Took about 22 minutes ... but all the rows are gone!! The table is now
completely empty!
What have I done wrong?
cheers
Neil
Er, I've found out, and would like to gloss over this subject now please! ;-)
What subject? Regards Andy Grantham. > To: ids@iiug.org > From: neil.truby@ardenta.com > Subject: Re: WHere did my data go?! - answered [26622] > Date: Sat, 31 Mar 2012 05:29:28 -0400 > > Er, I've found out, and would like to gloss over this subject now please! ;-) > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
We all do things that we like to gloss over later.... ;-) From: "NEIL TRUBY" <neil.truby@ardenta.com> To: ids@iiug.org Date: 03/31/2012 04:30 AM Subject: Re: WHere did my data go?! - answered [26622] Sent by: ids-bounces@iiug.org Er, I've found out, and would like to gloss over this subject now please! ;-) ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Many times the problem "sits" between the chair and the keyboard... I suppose this was one of those cases? :) On Sat, Mar 31, 2012 at 10:29 AM, NEIL TRUBY <neil.truby@ardenta.com> wrote: > Er, I've found out, and would like to gloss over this subject now please! > ;-) > > > > ******************************************************************************* > 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... --20cf3074afc2309af004bc8d642f