Re: Configuration and usage of high performance loader in SAP

Posted in 2004

Topics: Performance & Tuning, Migration, Import/Export & Data Conversion

Andrea — 23 Jul 2004 14:35:55 -0700 — source: Usenet: comp.databases.informix

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 > > >

↪ replying to Andrea

Neil Truby — Sat, 24 Jul 2004 07:00:02 +0100 — source: Usenet: comp.databases.informix

IDS Version? 9.21 by any chance? "Andrea" <andrea.frias@gmail.com> wrote in message news:d5ce18a9.0407231335.e685e8a@posting.google.com... > 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 > > > > > >

↪ replying to Neil Truby

Andrea — 26 Jul 2004 13:23:17 -0700 — source: Usenet: comp.databases.informix

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.com... > > 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 > >

Related threads

updatable SDS