RE: Configuration and usage of high performance loader in SAP

Posted in 2004

Savio Pinto (s) — Wed, 21 Jul 2004 17:07:05 -0500 — source: Usenet: comp.databases.informix

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 [mailto:owner-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