Re: De-fragmenting a table
One of the environment I have is pretty much same. We did the similar stuff not long ago. With the general recommended settings like PDQPRIORITY=100 etc. It should take you around 3 hours with the indexes. With multi-CPU and PDQPRIORITY , system is used upto it's fullest. Vivek Chaudhary ______________________________ Reply Separator _________________________________ Subject: Re: De-fragmenting a table Author: obnoxio (obnoxio@hotmail.com) at internet Date: 5/19/00 3:56 AM From: "Neil Truby" <ntruby@netcomuk.co.uk> > >IDS v7.24 on HP-UX 10.20. > >I've got a 13GByte, 12 million row table in 175 extents and I need to >defrag >it. Urgently! > >I ran an ALTER TABLE FRAGMENT INIT last night and, fourteen hours later it >still hadn't finished. this was with logging temporarily turned off for >the >database. I only have a 12 hour downtime wondow. > >Any other ideas? I'm testing a High perfoamnce load but, although therows >take only 20 minutes or so, the indexes are going to be damned slow. Upgrade to a more recent version. :-) Indexes don't have to be damn slow to build: use PSORT_DBTEMP and PSORT_NPROCS and you might be impressed. :-) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
Hah! It took 3 hours and 20 minutes. So what do you know?! Vivek.CHAUDHARY@st.com wrote in message <8g43v4$nta$1@news.xmission.com>... > > One of the environment I have is pretty much same. We did the similar > stuff not long ago. With the general recommended settings like > PDQPRIORITY=100 etc. It should take you around 3 hours with the > indexes. With multi-CPU and PDQPRIORITY , system is used upto it's > fullest. > > > Vivek Chaudhary > > >______________________________ Reply Separator _________________________________ >Subject: Re: De-fragmenting a table >Author: obnoxio (obnoxio@hotmail.com) at internet >Date: 5/19/00 3:56 AM > > >From: "Neil Truby" <ntruby@netcomuk.co.uk> >> >>IDS v7.24 on HP-UX 10.20. >> >>I've got a 13GByte, 12 million row table in 175 extents and I need to >>defrag >>it. Urgently! >> >>I ran an ALTER TABLE FRAGMENT INIT last night and, fourteen hours later it >>still hadn't finished. this was with logging temporarily turned off for >>the >>database. I only have a 12 hour downtime wondow. >> >>Any other ideas? I'm testing a High perfoamnce load but, although therows >>take only 20 minutes or so, the indexes are going to be damned slow. > >Upgrade to a more recent version. :-) > >Indexes don't have to be damn slow to build: use PSORT_DBTEMP and >PSORT_NPROCS and you might be impressed. :-) > >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com >