RE: Configuration and usage of high performance loader in SAP

what does the log file and reject log say?, have you set your INFORMIXSERVER to tcp connection ? have you created the onpload database? try creating the onpload database with the below procedure, 1) set informix env variables 2) set INFORMIXSERVER to tcp connection 3) set DISPLAY env variable 4) run 'ipload' command step # 4 should create the ipload database for you, then try re-running the job, if you are still getting the problem(also check the log and reject files), try to use the GUI and create/run a test job to test. "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 > > > > > > sending to informix-list