you can do the following to speed it up using HPL,
1. unload the tables using HPL multiple files option and then load it back using HPL multiple files option.
2. make sure to use EXPRESS mode to unload and load the data.
3. do a fake backup after the load



-----Original Message-----
From: owner-informix-list@iiug.org
[mailtowner-informix-list@iiug.org]On Behalf Of Torsten Barth
Sent: Wednesday, July 21, 2004 3:09 AM
To: informix-list@iiug.org; owner-informix-list@iiug.org
Subject: Configuration and usage of high performance loader in SAP







Hi Chris, hi Richard,

these tables are near 16 million pages and need to be reorganized.
Main problem is the time available to do this, because this customer
has 24*7 and only 4 hours to take the action.


Mit freundlichen Grüßen

Torsten Barth
---------------------------------------------------------------------------------------------------------

Barth Rechenzentrum + Systemhaus GmbH & Co. KG
Organisation & SW-Entwicklung
Mühleneschweg 5
D- 49090 Osnabrück
Telefon +49 541 609 10 - 88
Telefax +49 541 609 10 - 89
mailto: tbarth@barth-rz.de


sending to informix-list

sending to informix-list

Hi!,
I'm trying to use HPL to unload a DB (125k tables) from a production
server ...

I run a script to create a couple of projects with onpladm (and later
check when a table is altered, so we can recreate the job)...

But takes forever to unload the tables! (with onpladm run project, i
get some "Error -244 on cursor fetch" and "Connecting to onpload GUI
failed".. any ideas??)

TIA
Andrea F

"Savio Pinto \(s\)" <spinto@cap.org> wrote in message news:<cdmrcs$cdj$1@news.xmission.com>...
> you can do the following to speed it up using HPL,
> 1. unload the tables using HPL multiple files option and then load it back using HPL multiple files option.
> 2. make sure to use EXPRESS mode to unload and load the data.
> 3. do a fake backup after the load
>
>
>

IDS Version?
9.21 by any chance?

"Andrea" <andrea.frias@gmail.com> wrote in message
news:d5ce18a9.0407231335.e685e8a@posting.google.co m...
> Hi!,
> I'm trying to use HPL to unload a DB (125k tables) from a production
> server ...
>
> I run a script to create a couple of projects with onpladm (and later
> check when a table is altered, so we can recreate the job)...
>
> But takes forever to unload the tables! (with onpladm run project, i
> get some "Error -244 on cursor fetch" and "Connecting to onpload GUI
> failed".. any ideas??)
>
> TIA
> Andrea F
>
> "Savio Pinto \(s\)" <spinto@cap.org> wrote in message
news:<cdmrcs$cdj$1@news.xmission.com>...
> > you can do the following to speed it up using HPL,
> > 1. unload the tables using HPL multiple files option and then load it
back using HPL multiple files option.
> > 2. make sure to use EXPRESS mode to unload and load the data.
> > 3. do a fake backup after the load
> >
> >
> >

No, IDS 9.40.. FC2W3 I think...

"Neil Truby" <neil.truby@ardenta.com> wrote in message news:<2mec5eFlo2h5U1@uni-berlin.de>...
> IDS Version?
> 9.21 by any chance?
>
> "Andrea" <andrea.frias@gmail.com> wrote in message
> news:d5ce18a9.0407231335.e685e8a@posting.google.co m...
> > Hi!,
> > I'm trying to use HPL to unload a DB (125k tables) from a production
> > server ...
> >
> > I run a script to create a couple of projects with onpladm (and later
> > check when a table is altered, so we can recreate the job)...
> >
> > But takes forever to unload the tables! (with onpladm run project, i
> > get some "Error -244 on cursor fetch" and "Connecting to onpload GUI
> > failed".. any ideas??)
> >
> > TIA
> > Andrea F
> >