Re: Configuration and usage of high performance loader in SAP

Hello Torsten, you can use ipload (GUI to HPL) to configure the lot easier when newbie; you need X though. Done this stuff in the past; table without blobs are very good candidates. used fifos to do the copying see mkfifo. (CAREFULL PLEASE IF os mucks up you're in trouble) build 2 jobs one for load and one for unload in express mode please. Afterwards create level 0 archive. the unload writes to the fifo(s) and the load job reads from it. this means you build a new table to store the data in; later when reloaded drop the old table and make sure things like views etc are also corrected. See you Superboer. Torsten Barth <tbarth@barth-rz.de> wrote in message news:<cdipar$6sf$1@news.xmission.com>... > Hi, > > I am not experienced in using hpl and I need to know how to configure and > use > the HPL to reorg large tables. > We have to reorg some very large tables in just 5 hours (24*7). So I cannot > use > SAP's sapdba. Somebody out there who has real advise for me ? > Thanks in advance !! > > Regards > > 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