missing records

Posted in 2006

DD MISHRA — Mon, 26 Jun 2006 03:57:38 — source: IIUG Forums & Mailing Lists

Hi I am facing problem with informix 7:31 on HPUX11.11 server. We have application where we 12-13 program getting executed continously.we create raw tables in the first step and some intermediate steps . then we carry out our updates on these table. we modify the base tables from which thse tables are created. And at the end we create ASCII files which will be loaded to another database. I am facing the problem is sometimes during the table read it is missing records. Because of which sometimes file output is not proper. this problem we are unable to simulate but comes at some places. Anybody any such experience or suggestions, please share your suggestions or ideas . Regards Debadatta

↪ replying to DD MISHRA

Simmons, Keith — Mon, 26 Jun 2006 11:46:03 — source: IIUG Forums & Mailing Lists

Debadatta Are you setting an isolation mode anywhere? are you setting a lock mode anywhere? Either of these can affect the records returned from a query. Keith -----Original Message----- From: DD MISHRA [mailto:mishra.dd@gmail.com] Sent: Monday, June 26, 2006 4:58 AM To: ids@iiug.org Subject: missing records [7058] Hi I am facing problem with informix 7:31 on HPUX11.11 server. We have application where we 12-13 program getting executed continously.we create raw tables in the first step and some intermediate steps . then we carry out our updates on these table. we modify the base tables from which thse tables are created. And at the end we create ASCII files which will be loaded to another database. I am facing the problem is sometimes during the table read it is missing records. Because of which sometimes file output is not proper. this problem we are unable to simulate but comes at some places. Anybody any such experience or suggestions, please share your suggestions or ideas . Regards Debadatta ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************** *************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ******************************************************************************** ***************