Re: HPL error

On 8/4/06, Guo, Denny <DGuo@livingstonintl.com> wrote: > I am trying HPL but get error message. > "error occurred when attempting to update the database" > > I log in as "informix" to perform this job. > > OS: AIX 4.3.3 > Informix: V7.31UD3 > I'm not the HPL expert. You should be planning to upgrade both IDS and AIX in the near future, or preferably should have planned to do so in the not so recent past. You have not given us much information to work with. What exactly were you trying to do? Set up an HPL job? Execute it? Which program were you running? Can you find any errors in the IDS log? What sort of update were you trying? -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

We are going to upgrade our system and database in future. But I have to try out HPL in case we need to play with it. The error comes when I try to create the device array. I have checked the IDS log, there is no error been reported. Any body has idea? Thanks, Denny -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Jonathan Le.... Sent: August 6, 2006 9:05 AM To: ids@iiug.org Subject: Re: HPL error [7234] On 8/4/06, Guo, Denny <DGuo@livingstonintl.com> wrote: > I am trying HPL but get error message. > "error occurred when attempting to update the database" > > I log in as "informix" to perform this job. > > OS: AIX 4.3.3 > Informix: V7.31UD3 > I'm not the HPL expert. You should be planning to upgrade both IDS and AIX in the near future, or preferably should have planned to do so in the not so recent past. You have not given us much information to work with. What exactly were you trying to do? Set up an HPL job? Execute it? Which program were you running? Can you find any errors in the IDS log? What sort of update were you trying? -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/ ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************* The information contained in this e-mail message may contain privileged and confidential information. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you have received this message in error, please notify the sender by return e-mail, delete this message and destroy any copies. Internet e- mail is not guaranteed to be secure or error-free. Messages could be intercepted, corrupted, lost, arrive late or contain viruses. The sender will not be liable for these risks. ******************************************* Ce message electronique pourrait contenir des informations privilegiees et confidentielles. Si vous n'en etes pas le recipiendaire prevu, nous vous signalons qu'il est strictement interdit d'examiner, de diffuser, de distribuer et de reproduire le present message. Si vous l'avez recu par erreur, veuillez prevenir l'expediteur par courriel, puis effacer ce message et en detruire toute copie. Le courrier electronique n'est pas garanti securitaire ni exempt d'erreurs. Les messages pourraient etre interceptes, corrompus, egares, retardes ou contamines par des virus. L'exp'editeur n'est pas responsable de ces risques .

"What EXACTLY were you trying to do?" ...and how are you trying to do it? Is this an unload or load job? Are you sure the device name is unique? Try dropping the onpload database and starting over. Then come back here with step-by-step details of what you're trying to do..... -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Guo, Denny Sent: Tuesday, August 08, 2006 8:07 AM To: ids@iiug.org Subject: RE: HPL error [7239] We are going to upgrade our system and database in future. But I have to try out HPL in case we need to play with it. The error comes when I try to create the device array. I have checked the IDS log, there is no error been reported. Any body has idea? Thanks, Denny -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Jonathan Le.... Sent: August 6, 2006 9:05 AM To: ids@iiug.org Subject: Re: HPL error [7234] On 8/4/06, Guo, Denny <DGuo@livingstonintl.com> wrote: > I am trying HPL but get error message. > "error occurred when attempting to update the database" > > I log in as "informix" to perform this job. > > OS: AIX 4.3.3 > Informix: V7.31UD3 > I'm not the HPL expert. You should be planning to upgrade both IDS and AIX in the near future, or preferably should have planned to do so in the not so recent past. You have not given us much information to work with. What exactly were you trying to do? Set up an HPL job? Execute it? Which program were you running? Can you find any errors in the IDS log? What sort of update were you trying? -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/ ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************* The information contained in this e-mail message may contain privileged and confidential information. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you have received this message in error, please notify the sender by return e-mail, delete this message and destroy any copies. Internet e- mail is not guaranteed to be secure or error-free. Messages could be intercepted, corrupted, lost, arrive late or contain viruses. The sender will not be liable for these risks. ******************************************* Ce message electronique pourrait contenir des informations privilegiees et confidentielles. Si vous n'en etes pas le recipiendaire prevu, nous vous signalons qu'il est strictement interdit d'examiner, de diffuser, de distribuer et de reproduire le present message. Si vous l'avez recu par erreur, veuillez prevenir l'expediteur par courriel, puis effacer ce message et en detruire toute copie. Le courrier electronique n'est pas garanti securitaire ni exempt d'erreurs. Les messages pourraient etre interceptes, corrompus, egares, retardes ou contamines par des virus. L'exp'editeur n'est pas responsable de ces risques . ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

I am tryiny to move data from one table to another table. Lot of people suggest to use HPL and PIPE. Below is the steps I have done. 1. login as informix 2. create a named pipe file; 3. run " ipload" 4. create a new project; 5. try to create device array for both unload and load job, but get error message "error occurred when attempting to update the database" however, when I quit "ipload" and re-run the "ipload", I do see the device array which I created moment ago with error message. But the device array contains no detail information. Thanks, Denny -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Hamilton, Jerry Sent: August 8, 2006 9:11 AM To: ids@iiug.org Subject: RE: HPL error [7240] "What EXACTLY were you trying to do?" ....and how are you trying to do it? Is this an unload or load job? Are you sure the device name is unique? Try dropping the onpload database and starting over. Then come back here with step-by-step details of what you're trying to do..... ******************************************* The information contained in this e-mail message may contain privileged and confidential information. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you have received this message in error, please notify the sender by return e-mail, delete this message and destroy any copies. Internet e- mail is not guaranteed to be secure or error-free. Messages could be intercepted, corrupted, lost, arrive late or contain viruses. The sender will not be liable for these risks. ******************************************* Ce message electronique pourrait contenir des informations privilegiees et confidentielles. Si vous n'en etes pas le recipiendaire prevu, nous vous signalons qu'il est strictement interdit d'examiner, de diffuser, de distribuer et de reproduire le present message. Si vous l'avez recu par erreur, veuillez prevenir l'expediteur par courriel, puis effacer ce message et en detruire toute copie. Le courrier electronique n'est pas garanti securitaire ni exempt d'erreurs. Les messages pourraient etre interceptes, corrompus, egares, retardes ou contamines par des virus. L'exp'editeur n'est pas responsable de ces risques .

Denny, why don't you create a device array with many files and create two jobs, one to unload and another to load? I always use HPL in this way and it works fine and very fast. take care about how many files you'll use depending on your server cpu and disk. Celso Coimbra ClearTech Ltda "Unlock your revenue" NOVO Tel: (019) 2104-4509 E-mail: ccoimbra@cleartech.com.br -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]Em nome de Guo, Denny Enviada em: terça-feira, 8 de agosto de 2006 11:19 Para: ids@iiug.org Assunto: RE: HPL error [7241] I am tryiny to move data from one table to another table. Lot of people suggest to use HPL and PIPE. Below is the steps I have done. 1. login as informix 2. create a named pipe file; 3. run " ipload" 4. create a new project; 5. try to create device array for both unload and load job, but get error message "error occurred when attempting to update the database" however, when I quit "ipload" and re-run the "ipload", I do see the device array which I created moment ago with error message. But the device array contains no detail information. Thanks, Denny -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Hamilton, Jerry Sent: August 8, 2006 9:11 AM To: ids@iiug.org Subject: RE: HPL error [7240] "What EXACTLY were you trying to do?" .....and how are you trying to do it? Is this an unload or load job? Are you sure the device name is unique? Try dropping the onpload database and starting over. Then come back here with step-by-step details of what you're trying to do..... ******************************************* The information contained in this e-mail message may contain privileged and confidential information. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you have received this message in error, please notify the sender by return e-mail, delete this message and destroy any copies. Internet e- mail is not guaranteed to be secure or error-free. Messages could be intercepted, corrupted, lost, arrive late or contain viruses. The sender will not be liable for these risks. ******************************************* Ce message electronique pourrait contenir des informations privilegiees et confidentielles. Si vous n'en etes pas le recipiendaire prevu, nous vous signalons qu'il est strictement interdit d'examiner, de diffuser, de distribuer et de reproduire le present message. Si vous l'avez recu par erreur, veuillez prevenir l'expediteur par courriel, puis effacer ce message et en detruire toute copie. Le courrier electronique n'est pas garanti securitaire ni exempt d'erreurs. Les messages pourraient etre interceptes, corrompus, egares, retardes ou contamines par des virus. L'exp'editeur n'est pas responsable de ces risques . ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.