infinite select on specific record in informix

Posted in 2014

LESTER — Wed, 15 Jan 2014 02:17:12 — source: IIUG Forums & Mailing Lists

Good Day, I would like to ask the experts here regarding our problem. We have a record in our informix database that cannot be retrieved. We are running informix 11.70 FC7 and this record (using code number and transaction date) is running continuously without giving the result. This was already proven because when we change the code number or transaction date to any given data, the result is already out in 1 to 3 seconds. Would like to ask on how to trouble shoot this kind of problem or if we have a problem with the index???

↪ replying to LESTER

Art Kagel — Wed, 15 Jan 2014 04:55:34 — source: IIUG Forums & Mailing Lists

Have you run oxygen -cDI know the table? Art On Jan 14, 2014 9:17 PM, "LESTER POLICARPIO" <lpolicarpio2009@yahoo.com> wrote: > Good Day, > > I would like to ask the experts here regarding our problem. We have a > record > in our informix database that cannot be retrieved. We are running informix > 11.70 FC7 and this record (using code number and transaction date) is > running > continuously without giving the result. This was already proven because > when > we change the code number or transaction date to any given data, the > result is > already out in 1 to 3 seconds. Would like to ask on how to trouble shoot > this > kind of problem or if we have a problem with the index??? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c33eaa165e9204effb1e7a

↪ replying to Art Kagel

Everett — Wed, 15 Jan 2014 13:57:27 — source: IIUG Forums & Mailing Lists

How about oncheck -cDI? Darn spellcheckers are designed by rabid squirrels. --EEM > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Art Kagel > Sent: Tuesday, January 14, 2014 10:56 PM > To: ids@iiug.org > Subject: Re: infinite select on specific record in informix [32220] > > Have you run oxygen -cDI know the table? > > Art > On Jan 14, 2014 9:17 PM, "LESTER POLICARPIO" > <lpolicarpio2009@yahoo.com> > wrote: > > > Good Day, > > > > I would like to ask the experts here regarding our problem. We have a > > record in our informix database that cannot be retrieved. We are > > running informix > > 11.70 FC7 and this record (using code number and transaction date) is > > running continuously without giving the result. This was already > > proven because when we change the code number or transaction date to > > any given data, the result is already out in 1 to 3 seconds. Would > > like to ask on how to trouble shoot this kind of problem or if we > have > > a problem with the index??? > > > > > > > > > *********************************************************************** > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a11c33eaa165e9204effb1e7a > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Everett

Art Kagel — Wed, 15 Jan 2014 14:05:34 — source: IIUG Forums & Mailing Lists

AARRGG!! Missed that my phone "corrected" my spelling! Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Jan 15, 2014 at 8:57 AM, Everett Mills < Everett.Mills@nationalbeef.com> wrote: > How about oncheck -cDI? > > Darn spellcheckers are designed by rabid squirrels. > > --EEM > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > Art Kagel > > Sent: Tuesday, January 14, 2014 10:56 PM > > To: ids@iiug.org > > Subject: Re: infinite select on specific record in informix [32220] > > > > Have you run oxygen -cDI know the table? > > > > Art > > On Jan 14, 2014 9:17 PM, "LESTER POLICARPIO" > > <lpolicarpio2009@yahoo.com> > > wrote: > > > > > Good Day, > > > > > > I would like to ask the experts here regarding our problem. We have a > > > record in our informix database that cannot be retrieved. We are > > > running informix > > > 11.70 FC7 and this record (using code number and transaction date) is > > > running continuously without giving the result. This was already > > > proven because when we change the code number or transaction date to > > > any given data, the result is already out in 1 to 3 seconds. Would > > > like to ask on how to trouble shoot this kind of problem or if we > > have > > > a problem with the index??? > > > > > > > > > > > > > > *********************************************************************** > > ******** > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --001a11c33eaa165e9204effb1e7a > > > > > > *********************************************************************** > > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113490fa0c30b804f002cd53

↪ replying to Everett

LESTER — Fri, 17 Jan 2014 04:55:34 — source: IIUG Forums & Mailing Lists

Hi sorry for the late response yes I already ran the command it only displays the index used by the the table no message regarding any errors...