RE: HPLoader Configuration
Hi, Martin
But how I indicate it, load to "dbspace8"?
Regards,
--- Martin_Fischer@agsea.com escribi':
> 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
> > [mailto:owner-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
>
__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam 'gratis!
Reg'strate ya - http://correo.yahoo.com.mx/
sending to informix-list