IDS Forum

Re: Compression Shrink Option

Posted By: Peter_Logan@spartanstores.com
Date: Thursday, 13 January 2011, at 8:50 a.m.

In Response To: Compression Shrink Option (DAN MUELLER)

Hi Dan,

In my testing of these .. The compression takes the most time ...
followed by the repack .. and finally the shrink. When I tested them
individually the shrink took only a few seconds ... From what I
understand that no matter where the process fails, it picks up from that
point and continues when you restart the process ... Ie. the repack
portion is taking from the back of a table, and loading that into holes at
the front of the table ... The compression will indicate in the header
when the table is compressed .. So, I think you should be ok if you have
to stop the process to then do the archive ...
Hope this helps ... and if I messed anything up, I'm sure that Art or
John can correct my errors....

Peter

Peter Logan
Senior Database Administrator
Phone: 616/878-8309

From:
"DAN MUELLER" <dan.mueller@trnswrks.com>
To:
ids@iiug.org
Date:
01/13/2011 08:36 AM
Subject:
Compression Shrink Option [22401]
Sent by:
ids-bounces@iiug.org

Good Morning,

IDS 11.50.FC5
AIX 5.3

I am just beginning to take advantage of the compression feature. All went

well testing but when I went to a prod server I ran into a problem with
the
shrink option. As soon as it started it failed with the following message
in
the online.log:

20:39:06 rscCommand: This operation cannot run concurrently with an
archive.isfd = 12, table = 'fin2:"informix".maintenance_log', iserrno 147
20:39:06 ERROR fin2:"informix".maintenance_log: rscCommand failed for
partnum
2097386
20:39:06 Shrink operation failed for fin2:"informix".maintenance_log,
iserrno
0
20:39:06 ERROR: admin_fragment_command('fragment compress repack shrink
','2097386') failed

>From the error, I obviously cannot run the shrink option while an archive
is
active but my question is what happens when I restart the shrink? Does it
somehow take off where it failed or restart from the beginning? When I
tested
this in dev, it took about 3 days to compress, repack, & shrink a fragment
in
this partition. If this behavior repeats itself in prod, i am looking at
not
being able to run an archive for 3 days???

Obviously I have something to take back to the dev box and test but I
would
like any insight that anyone may already have on this.

Thanx,
Dan

*******************************************************************************

Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Compression Shrink Option
  DAN MUELLER -- Thursday, 13 January 2011, at 8:36 a.m.
  • Re: Compression Shrink Option
    Peter_Logan@spartanstores.com -- Thursday, 13 January 2011, at 8:50 a.m.
  • Re: Compression Shrink Option
    Art Kagel -- Thursday, 13 January 2011, at 9:56 a.m.
    • Re: Compression Shrink Option
      John Miller iii -- Thursday, 13 January 2011, at 2:00 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.