RE: HPLoader Configuration
As part of the CREATE TABLE statement. Should be in the SQL:Guide to
Syntax.
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
Sent by: Martin_Fischer@agsea.com
owner-informix-li cc
st@iiug.org informix-list@iiug.org
Subject
RE: HPLoader Configuration
06/13/2005 12:29
PM
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
sending to informix-list