Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Richard Kofler — — source: Usenet: comp.databases.informix
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.