Re: HPLoader Configuration

I have been look in for manuals but I don't find it ( yet) on IBM's Portal. Do you have the link to it? Regards, --- Superboer <superboer7@planet.nl> escribi': > > 2 ways onploadadm (check manual) and ipload (check manual) > > easiest way is ipload. set your display correctly and start it.(ipload) > > then choose default project and choose Components from the menu. > in there choose first the devices. > --> create one it should be straight forward > --> then choose generate job where you choose the above created > dev array and tables etc. > > to avoid 2 GB limit use fifo's (array type pipe) you have to create > 2 dev arrays one for load one for unload. eq: > > mkfifo /tmp/myfifo > > unload dev: > > cat - > /tmp/myfifo (pipe command) > > load dev > > cat /tmp/myfifo (pipe command) > > Warning the os can muck up here so check your data and results > > Superboer. > > > > > Cesar Cruz schreef: > > 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=F3: > > > > > Or one could create HPL load jobs that copy from table to table bypassi= > ng > > > the need to unload to files altogether. There was not alot of informat= > ion > > > 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 Subj= > ect > > > 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 l= > oad > > > 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 dowlo= > and > > > 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=F3n a Internet y 2GB extra a tu co= > rreo > > > por $100 al mes. http://net.yahoo.com.mx > > > > > > > > > > > > > > > > > > > > > > > > > > ___________________________________________________________ > > Do You Yahoo!? > > La mejor conexi=F3n a Internet y <b >2GB</b> extra a tu correo por $100 a= > l mes. http://net.yahoo.com.mx > >=20 > > 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

Cesar Cruz schrieb: > I have been look in for manuals but I don't find it ( yet) on IBM's Portal. > > Do you have the link to it? > I could not find a hint about your IBM INFORMIX version or OS :( This gives you a list of all titles of the IBM INFORMIX documentation http://www-306.ibm.com/software/data/informix/pubs/library/lists.html Of course a quick look into www.iiug.org or google or the IBM INFORMIX FAQ reveals this for everyone in a few seconds without the old man posting the same thing over & over again (sorry man, I MUST make my cynical remarks if I do the work of others) dic_k -- Richard Kofler SOLID STATE EDV Dienstleistungen GmbH Vienna/Austria/Europe