Re: Configuration and usage of high performance loader in SAP
Richard,
How large is the table?
Have you considered using PSORT_NPROCS & PDQPRIORITY settings in your env
to leverage your hardware and speed things along?
-Chris
Richard Kofler <richard.kofler@chello.at>
Sent by: owner-informix-list@iiug.org
07/20/2004 12:00 PM
Please respond to
Richard Kofler <richard.kofler@chello.at>
To
informix-list@iiug.org
cc
Subject
Re: Configuration and usage of high performance loader in SAP
Torsten Barth wrote:
>
> 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 !!
>
Please give IDS version & the platform you are on.
You should read about the onpladm utility, if it is
available in your version:
http://www-106.ibm.com/developerworks/db2/zones/informix/library/techarticle/0307carlson/0307carlson.html
Also search the library for the load articles written by J. Parker
(find pointers in c.d.i. using the search terms +parker +load + faq)
Be aware that I have *absolutely no idea* what you must do with SAP
while
unloading & table drop & reloading & & index recretate &
index rebuild & !!update statistics!!
dic_k
--
Richard Kofler
SOLID STATE EDV
Dienstleistungen GmbH
Vienna/Austria/Europe
sending to informix-list