SEO

This is how I do it using the onpload GUI interface as I haven't played
with the CLI as of yet. IDS9.3 on AIX 5.2

create your new table (No indexes)

in the HPL GUI, Components | Devices create a pipe device array and the
pipe command should be '/usr/bin/cat'

back at the main screen, Components | Generate Job,
no conversion job (Very quick and easy)
table=copy from table
device=name of device just created

create another pipe device array and this time the pipe command will be :
'onpload -p project_name -j name_of_job1 -fu'

generate another no conversion job
table=copy to table
device=name of second device created

From the command line 'onpload -p project_name -j name_of_job2 -fl'

The load job uses the output of the unload job as input.

Create your indexes.

HTH.

Martin Fischer
Database Administrator
Associated Grocers, Inc.


NOTICE: This email message is for the sole use of the intended
recipient(s) and may contain confidential and privileged information. Any
unauthorized review, use, disclosure or distribution is prohibited. If you
are not the intended recipient, please contact the sender by reply email
and destroy all copies of the original message. Thank you.




Cesar Cruz
<markaragnos17@ya
hoo.com.mx> To
Martin_Fischer@agsea.com,
06/07/2005 04:29 informix-list@iiug.org
PM cc
Cesae Cruz
<markaragnos17@yahoo.com.mx>
Subject
RE: HPLoader Configuration










That's the problem

I don't know how to do it.

Have you an example or something that can help me?

Regards,


--- Martin_Fischer@agsea.com escribió:

> Or one could create HPL load jobs that copy from table to table bypassing
> the need to unload to files altogether. There was not alot of
information
> in the initial post to determine a proper solution.
>
> Martin Fischer
> Database Administrator
> Associated Grocers, Inc.
>
>
> NOTICE: This email message is for the sole use of the intended
> recipient(s) and may contain confidential and privileged information.
Any
> unauthorized review, use, disclosure or distribution is prohibited. If
you
> are not the intended recipient, please contact the sender by reply email
> and destroy all copies of the original message. Thank you.
>
>
>
>
> "Savio Pinto
> \(s\)"
> <spinto@cap.org>
To
> Sent by: "Cesae Cruz"
> owner-informix-li <markaragnos17@yahoo.com.mx>,
> st@iiug.org <informix-list@iiug.org>
>
cc
>
> 06/07/2005 01:09
Subject
> PM RE: HPLoader Configuration
>
>
>
>
>
>
>
>
>
>
> you can create a Load jobs in HPL to do this, you can create a HPL jobs
to
> unload the table into multiple files, and then create a single job to
load
> the multiple files to the table. you may do this from the gui (ipload) or
> using onpladm.
>
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailtowner-informix-list@iiug.org]On Behalf Of Cesae Cruz
> Sent: Monday, June 06, 2005 4:24 PM
> To: informix-list@iiug.org
> Subject: HPLoader Configuration
>
>
>
> Hi,
>
>
> I need know how i can configurate/setting the HPloader for
dowloand
> from dbspace1 and upload the same Table on dbspace8 ( 39,000,000
> Records )
>
>
> I tryed with onunload but at 25,000,000 Records it Fails.
>
>
> Regards,
>
>
> Do You Yahoo!? La mejor conexión a Internet y 2GB extra a tu correo
> por $100 al mes. http://net.yahoo.com.mx
>
>
>
>






__________________________________________________ _________
Do You Yahoo!?
La mejor conexión a Internet y <b >2GB</b> extra a tu correo por $100 al
mes. http://net.yahoo.com.mx




sending to informix-list