HP3000-L Archives

January 2003, Week 2

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Reply To:
Date:
Sat, 11 Jan 2003 16:32:05 -0600
Content-Type:
text/plain
Parts/Attachments:
text/plain (52 lines)
 From purely a system performance point of view, put the detail set and
automatic master on separate drives with neither one of them on ldev 1. You
have likely done this, so I'll leave the rest to the Image guru's.


":-) Craig Lalley" <[log in to unmask]> wrote in message
news:3e209445$3@skycache-news.fidnet.com...
> OK,
>
> I have a detail data set with 48.3 million records.
> It has one path to an automatic master.
> The customer just did an archive and deleted 14.3 million records.
> (Nice delete chain)
> The highwater mark is 65.6 million.
>
> Make no mistake we are talking about a jumbo data set about 6.4 Gb in
> size.
>
> My problem is that I want to repack the data set and remove the delete
> chain.  (currently on a 969) In the last 5 hours it has gone 15% with
> Adager.  This is a test run to determine how long it will take.
>
> So my question is, "How do I make it go faster, given current
> hardware."
>
> I am sure many of you have tried some of these senarios, so your input
> would help.
>
> Option A)  Do a serial repack the first week and a sorted pack the
> second.
> Option B)  Remove the path, do a sorted repack and add the path back.
>
> Has anyone ever timed these options?  Or does anyone have any better
> options that don't involve upgrading to an N-Class?  :)
>
> Thanks for the help.
>
> -Craig
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2