Intermittent Loss of eAuth Response Comments

IDS: 10.00.TC9X3 OS: MS Windows 2000 SP4 =20 Would the TRACE ON and TRACE OFF help in the below case? =20 In a nutshell, we are intermittently losing the update to a column containing fleet management work order authorization comments. We know that the update initially occurs, but for unknown reasons the update does not stick or is somehow set to null later. There are no error return codes to indicate why. The problem can be recreated in the lab, and users would like to trace this in a lab environment. =20 Is there an easy way to turn on a trace within Informix that might give us more information? =20 It would be helpful to confirm that subsequent SQL is not setting the column to null after the update. We could not find any evidence of this in the application code ... just want to eliminate this for sure as a potential root cause. =20 Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd. Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com <mailto:2244650553@messaging.sprintpcs.com>=20 Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com Informix Primary: INFORMIXDBAPrimaryPager@searshc.com Informix Secondary: INFORMIXDBASecondaryPager@searshc.com MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com MySQL Primary: MYSQLDBAPrimaryPager@searshc.com MySQL Secondary: MYSQLDBASecondaryPager@searshc.com =20 " Yes we can make a Change! " " It's always a great day to watch Sports: " " Lets GO Detroit: Lions, Tigers, Pistons, and Red Wings! " " Lets GO Chicago: Bears, Cubs, White Sox, Bulls, and Black Hawks! " GSU ******************************************************************* This message, including any attachments, is the property of Sears Holdings = Corporation and/or one of its subsidiaries. It is confidential and may cont= ain proprietary or legally privileged information. If you are not the inten= ded recipient, please delete it without reading the contents. Thank you.

The two options I see are: 1) You can turn on auditing 2) You can review the logical logs. a) Find the partnum of the table in questions b) Find the rowid in questions c) onlog -t <<partnum>> d) Review all records for the specific rowid John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) (Embedded image moved to file: pic48828.gif) ids-bounces@iiug.org wrote on 01/12/2012 10:27:54 AM: > From: "Knox, Ernest" <Ernest.Knox@searshc.com> > To: ids@iiug.org > Date: 01/12/2012 10:29 AM > Subject: Intermittent Loss of eAuth Response Comments [25908] > Sent by: ids-bounces@iiug.org > > IDS: 10.00.TC9X3 > > OS: MS Windows 2000 SP4 > > =20 > > Would the TRACE ON and TRACE OFF help in the below case? > > =20 > > In a nutshell, we are intermittently losing the update to a column > containing fleet management work order authorization comments. We know > that the update initially occurs, but for unknown reasons the update > does not stick or is somehow set to null later. There are no error > return codes to indicate why. The problem can be recreated in the lab, > and users would like to trace this in a lab environment. > > =20 > > Is there an easy way to turn on a trace within Informix that might give > us more information? > > =20 > > It would be helpful to confirm that subsequent SQL is not setting the > column to null after the update. We could not find any evidence of this > in the application code ... just want to eliminate this for sure as a > potential root cause. > > =20 > > Thanks, > > ******************************************************************* > > Ernie Knox > > IT Database Administrator Specialist > > Sears Holdings - BU: I & T Group > > 3333 Beverly Rd. > > Hoffman Estates, IL. 60179 > > Office: (847) 286-5735 > > Email: Ernest.Knox@searshc.com > > Blackberry: 2244650553@messaging.sprintpcs.com > <mailto:2244650553@messaging.sprintpcs.com>=20 > > Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com > > Informix Primary: INFORMIXDBAPrimaryPager@searshc.com > > Informix Secondary: INFORMIXDBASecondaryPager@searshc.com > > MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com > > MySQL Primary: MYSQLDBAPrimaryPager@searshc.com > > MySQL Secondary: MYSQLDBASecondaryPager@searshc.com > > =20 > > " Yes we can make a Change! " > > " It's always a great day to watch Sports: " > > " Lets GO Detroit: Lions, Tigers, Pistons, and Red Wings! " > > " Lets GO Chicago: Bears, Cubs, White Sox, Bulls, and Black Hawks! " > > GSU > > ******************************************************************* > > This message, including any attachments, is the property of Sears Holdings = > Corporation and/or one of its subsidiaries. It is confidential and may cont= > ain proprietary or legally privileged information. If you are not the inten= > ded recipient, please delete it without reading the contents. Thank you. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

TRACE ON/OFF only works within stored procedures. Couple of options that I see: 1. You can try the xtrace utility and see what it catches. 2. Try to catch the offending SQL using AGS Sentinel 3. See if iWatch from Exact-Solutions can work with 10.00 (don't remember). If it does it will capture the update and the session details of where the update came from. Art Art S. Kagel 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 my employer, Advanced DataTools, 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 Thu, Jan 12, 2012 at 1:27 PM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > IDS: 10.00.TC9X3 > > OS: MS Windows 2000 SP4 > > =20 > > Would the TRACE ON and TRACE OFF help in the below case? > > =20 > > In a nutshell, we are intermittently losing the update to a column > containing fleet management work order authorization comments. We know > that the update initially occurs, but for unknown reasons the update > does not stick or is somehow set to null later. There are no error > return codes to indicate why. The problem can be recreated in the lab, > and users would like to trace this in a lab environment. > > =20 > > Is there an easy way to turn on a trace within Informix that might give > us more information? > > =20 > > It would be helpful to confirm that subsequent SQL is not setting the > column to null after the update. We could not find any evidence of this > in the application code ... just want to eliminate this for sure as a > potential root cause. > > =20 > > Thanks, > > ******************************************************************* > > Ernie Knox > > IT Database Administrator Specialist > > Sears Holdings - BU: I & T Group > > 3333 Beverly Rd. > > Hoffman Estates, IL. 60179 > > Office: (847) 286-5735 > > Email: Ernest.Knox@searshc.com > > Blackberry: 2244650553@messaging.sprintpcs.com > <mailto:2244650553@messaging.sprintpcs.com>=20 > > Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com > > Informix Primary: INFORMIXDBAPrimaryPager@searshc.com > > Informix Secondary: INFORMIXDBASecondaryPager@searshc.com > > MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com > > MySQL Primary: MYSQLDBAPrimaryPager@searshc.com > > MySQL Secondary: MYSQLDBASecondaryPager@searshc.com > > =20 > > " Yes we can make a Change! " > > " It's always a great day to watch Sports: " > > " Lets GO Detroit: Lions, Tigers, Pistons, and Red Wings! " > > " Lets GO Chicago: Bears, Cubs, White Sox, Bulls, and Black Hawks! " > > GSU > > ******************************************************************* > > This message, including any attachments, is the property of Sears Holdings > = > Corporation and/or one of its subsidiaries. It is confidential and may > cont= > ain proprietary or legally privileged information. If you are not the > inten= > ded recipient, please delete it without reading the contents. Thank you. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --90e6ba6e89144e480204b659e1dc

Thanks everyone for your ideas on this. I will take it back to the custome= r for review and if they wish to rent or purchase additional products to as= sist in the investigation. Lastly, so looking into the logical logs really wouldn't give any additiona= l information as to the issue. I guess it really wouldn't show any rollbac= ks of data or would it?=20 Thanks, ******************************************************************* Ernie Knox IT Database=A0Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd. Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry:=A02244650553@messaging.sprintpcs.com Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com Informix Primary: INFORMIXDBAPrimaryPager@searshc.com Informix Secondary: INFORMIXDBASecondaryPager@searshc.com MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com MySQL Primary: MYSQLDBAPrimaryPager@searshc.com MySQL Secondary: MYSQLDBASecondaryPager@searshc.com " Yes we can make a Change! " " It's always a great day to watch=A0Sports: " " Lets GO Detroit: Lions, Tigers, Pistons, and Red Wings! " " Lets GO Chicago: Bears, Cubs, White Sox, Bulls, and Black Hawks! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art K= agel Sent: Thursday, January 12, 2012 2:38 PM To: ids@iiug.org Subject: Re: Intermittent Loss of eAuth Response Comments [25912] TRACE ON/OFF only works within stored procedures. Couple of options that I see:=20 1. You can try the xtrace utility and see what it catches.=20 2. Try to catch the offending SQL using AGS Sentinel=20 3. See if iWatch from Exact-Solutions can work with 10.00 (don't=20 remember). If it does it will capture the update and the session details=20 of where the update came from.=20 Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/=20 Disclaimer: Please keep in mind that my own opinions are my own opinions an= d do not reflect on my employer, Advanced DataTools, the IIUG, nor any othe= r 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 ent= ities themselves.=20 On Thu, Jan 12, 2012 at 1:27 PM, Knox, Ernest <Ernest.Knox@searshc.com>wrot= e:=20 > IDS: 10.00.TC9X3 >=20 > OS: MS Windows 2000 SP4 >=20 > =3D20 >=20 > Would the TRACE ON and TRACE OFF help in the below case?=20 >=20 > =3D20 >=20 > In a nutshell, we are intermittently losing the update to a column=20 > containing fleet management work order authorization comments. We know=20 > that the update initially occurs, but for unknown reasons the update=20 > does not stick or is somehow set to null later. There are no error=20 > return codes to indicate why. The problem can be recreated in the lab,=20 > and users would like to trace this in a lab environment. >=20 > =3D20 >=20 > Is there an easy way to turn on a trace within Informix that might=20 > give us more information? >=20 > =3D20 >=20 > It would be helpful to confirm that subsequent SQL is not setting the=20 > column to null after the update. We could not find any evidence of=20 > this in the application code ... just want to eliminate this for sure=20 > as a potential root cause. >=20 > =3D20 >=20 > Thanks, >=20 > ******************************************************************* >=20 > Ernie Knox >=20 > IT Database Administrator Specialist >=20 > Sears Holdings - BU: I & T Group >=20 > 3333 Beverly Rd.=20 >=20 > Hoffman Estates, IL. 60179 >=20 > Office: (847) 286-5735 >=20 > Email: Ernest.Knox@searshc.com >=20 > Blackberry: 2244650553@messaging.sprintpcs.com > <mailto:2244650553@messaging.sprintpcs.com>=3D20 >=20 > Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com >=20 > Informix Primary: INFORMIXDBAPrimaryPager@searshc.com >=20 > Informix Secondary: INFORMIXDBASecondaryPager@searshc.com >=20 > MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com >=20 > MySQL Primary: MYSQLDBAPrimaryPager@searshc.com >=20 > MySQL Secondary: MYSQLDBASecondaryPager@searshc.com >=20 > =3D20 >=20 > " Yes we can make a Change! "=20 >=20 > " It's always a great day to watch Sports: "=20 >=20 > " Lets GO Detroit: Lions, Tigers, Pistons, and Red Wings! "=20 >=20 > " Lets GO Chicago: Bears, Cubs, White Sox, Bulls, and Black Hawks! "=20 >=20 > GSU >=20 > ******************************************************************* >=20 > This message, including any attachments, is the property of Sears=20 > Holdings =3D Corporation and/or one of its subsidiaries. It is=20 > confidential and may cont=3D ain proprietary or legally privileged=20 > information. If you are not the inten=3D ded recipient, please delete it= =20 > without reading the contents. Thank you. >=20 >=20 >=20 >=20 ***************************************************************************= ****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 >=20 --90e6ba6e89144e480204b659e1dc=20 ***************************************************************************= **** Forum Note: Use "Reply" to post a response in the discussion forum.=20 This message, including any attachments, is the property of Sears Holdings = Corporation and/or one of its subsidiaries. It is confidential and may cont= ain proprietary or legally privileged information. If you are not the inten= ded recipient, please delete it without reading the contents. Thank you.

Sir, Is this AGS Sentinel and iWatch free software or one has to purchase it ? Neville. On Fri, Jan 13, 2012 at 1:07 AM, Art Kagel <art.kagel@gmail.com> wrote: > TRACE ON/OFF only works within stored procedures. Couple of options that I > see: > > 1. You can try the xtrace utility and see what it catches. > > 2. Try to catch the offending SQL using AGS Sentinel > > 3. See if iWatch from Exact-Solutions can work with 10.00 (don't > > remember). If it does it will capture the update and the session details > > of where the update came from. > > Art > Art S. Kagel > 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 my employer, Advanced DataTools, 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 Thu, Jan 12, 2012 at 1:27 PM, Knox, Ernest <Ernest.Knox@searshc.com > >wrote: > > > IDS: 10.00.TC9X3 > > > > OS: MS Windows 2000 SP4 > > > > =20 > > > > Would the TRACE ON and TRACE OFF help in the below case? > > > > =20 > > > > In a nutshell, we are intermittently losing the update to a column > > containing fleet management work order authorization comments. We know > > that the update initially occurs, but for unknown reasons the update > > does not stick or is somehow set to null later. There are no error > > return codes to indicate why. The problem can be recreated in the lab, > > and users would like to trace this in a lab environment. > > > > =20 > > > > Is there an easy way to turn on a trace within Informix that might give > > us more information? > > > > =20 > > > > It would be helpful to confirm that subsequent SQL is not setting the > > column to null after the update. We could not find any evidence of this > > in the application code ... just want to eliminate this for sure as a > > potential root cause. > > > > =20 > > > > Thanks, > > > > ******************************************************************* > > > > Ernie Knox > > > > IT Database Administrator Specialist > > > > Sears Holdings - BU: I & T Group > > > > 3333 Beverly Rd. > > > > Hoffman Estates, IL. 60179 > > > > Office: (847) 286-5735 > > > > Email: Ernest.Knox@searshc.com > > > > Blackberry: 2244650553@messaging.sprintpcs.com > > <mailto:2244650553@messaging.sprintpcs.com>=20 > > > > Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com > > > > Informix Primary: INFORMIXDBAPrimaryPager@searshc.com > > > > Informix Secondary: INFORMIXDBASecondaryPager@searshc.com > > > > MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com > > > > MySQL Primary: MYSQLDBAPrimaryPager@searshc.com > > > > MySQL Secondary: MYSQLDBASecondaryPager@searshc.com > > > > =20 > > > > " Yes we can make a Change! " > > > > " It's always a great day to watch Sports: " > > > > " Lets GO Detroit: Lions, Tigers, Pistons, and Red Wings! " > > > > " Lets GO Chicago: Bears, Cubs, White Sox, Bulls, and Black Hawks! " > > > > GSU > > > > ******************************************************************* > > > > This message, including any attachments, is the property of Sears > Holdings > > = > > Corporation and/or one of its subsidiaries. It is confidential and may > > cont= > > ain proprietary or legally privileged information. If you are not the > > inten= > > ded recipient, please delete it without reading the contents. Thank you. > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --90e6ba6e89144e480204b659e1dc > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Warm Regards, Neville Monteiro. --bcaec53f37ed054f6704b6618ad7

Sentinel, along with AGS's Server Studio, is delivered with the Informix engine, and you can activate a 30 day free trial anytime you want (basic Server Studio functionality is free, but Sentinel is part of the Enterprise level license which is extra after the trial period). iWatch is a for-purchase product. Art Art S. Kagel 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 my employer, Advanced DataTools, 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 Thu, Jan 12, 2012 at 11:45 PM, Neville Monteiro < nevillemonteiro@gmail.com> wrote: > Sir, > > Is this AGS Sentinel and iWatch free software or one has to purchase it ? > > Neville. > > On Fri, Jan 13, 2012 at 1:07 AM, Art Kagel <art.kagel@gmail.com> wrote: > > > TRACE ON/OFF only works within stored procedures. Couple of options that > I > > see: > > > > 1. You can try the xtrace utility and see what it catches. > > > > 2. Try to catch the offending SQL using AGS Sentinel > > > > 3. See if iWatch from Exact-Solutions can work with 10.00 (don't > > > > remember). If it does it will capture the update and the session details > > > > of where the update came from. > > > > Art > > Art S. Kagel > > 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 my employer, Advanced DataTools, 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 Thu, Jan 12, 2012 at 1:27 PM, Knox, Ernest <Ernest.Knox@searshc.com > > >wrote: > > > > > IDS: 10.00.TC9X3 > > > > > > OS: MS Windows 2000 SP4 > > > > > > =20 > > > > > > Would the TRACE ON and TRACE OFF help in the below case? > > > > > > =20 > > > > > > In a nutshell, we are intermittently losing the update to a column > > > containing fleet management work order authorization comments. We know > > > that the update initially occurs, but for unknown reasons the update > > > does not stick or is somehow set to null later. There are no error > > > return codes to indicate why. The problem can be recreated in the lab, > > > and users would like to trace this in a lab environment. > > > > > > =20 > > > > > > Is there an easy way to turn on a trace within Informix that might give > > > us more information? > > > > > > =20 > > > > > > It would be helpful to confirm that subsequent SQL is not setting the > > > column to null after the update. We could not find any evidence of this > > > in the application code ... just want to eliminate this for sure as a > > > potential root cause. > > > > > > =20 > > > > > > Thanks, > > > > > > ******************************************************************* > > > > > > Ernie Knox > > > > > > IT Database Administrator Specialist > > > > > > Sears Holdings - BU: I & T Group > > > > > > 3333 Beverly Rd. > > > > > > Hoffman Estates, IL. 60179 > > > > > > Office: (847) 286-5735 > > > > > > Email: Ernest.Knox@searshc.com > > > > > > Blackberry: 2244650553@messaging.sprintpcs.com > > > <mailto:2244650553@messaging.sprintpcs.com>=20 > > > > > > Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com > > > > > > Informix Primary: INFORMIXDBAPrimaryPager@searshc.com > > > > > > Informix Secondary: INFORMIXDBASecondaryPager@searshc.com > > > > > > MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com > > > > > > MySQL Primary: MYSQLDBAPrimaryPager@searshc.com > > > > > > MySQL Secondary: MYSQLDBASecondaryPager@searshc.com > > > > > > =20 > > > > > > " Yes we can make a Change! " > > > > > > " It's always a great day to watch Sports: " > > > > > > " Lets GO Detroit: Lions, Tigers, Pistons, and Red Wings! " > > > > > > " Lets GO Chicago: Bears, Cubs, White Sox, Bulls, and Black Hawks! " > > > > > > GSU > > > > > > ******************************************************************* > > > > > > This message, including any attachments, is the property of Sears > > Holdings > > > = > > > Corporation and/or one of its subsidiaries. It is confidential and may > > > cont= > > > ain proprietary or legally privileged information. If you are not the > > > inten= > > > ded recipient, please delete it without reading the contents. Thank > you. > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --90e6ba6e89144e480204b659e1dc > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Warm Regards, > Neville Monteiro. > > --bcaec53f37ed054f6704b6618ad7 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --90e6ba6e889228195104b66682e6

Purchase In the case of iWatch it is actual written just around the corner from where you are based Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Neville Monteiro Sent: Thursday, January 12, 2012 10:46 PM To: ids@iiug.org Subject: Re: Intermittent Loss of eAuth Response Comments [25918] Sir, Is this AGS Sentinel and iWatch free software or one has to purchase it ? Neville. On Fri, Jan 13, 2012 at 1:07 AM, Art Kagel <art.kagel@gmail.com> wrote: > TRACE ON/OFF only works within stored procedures. Couple of options that I > see: > > 1. You can try the xtrace utility and see what it catches. > > 2. Try to catch the offending SQL using AGS Sentinel > > 3. See if iWatch from Exact-Solutions can work with 10.00 (don't > > remember). If it does it will capture the update and the session details > > of where the update came from. > > Art > Art S. Kagel > 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 my employer, Advanced DataTools, 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 Thu, Jan 12, 2012 at 1:27 PM, Knox, Ernest <Ernest.Knox@searshc.com > >wrote: > > > IDS: 10.00.TC9X3 > > > > OS: MS Windows 2000 SP4 > > > > =20 > > > > Would the TRACE ON and TRACE OFF help in the below case? > > > > =20 > > > > In a nutshell, we are intermittently losing the update to a column > > containing fleet management work order authorization comments. We know > > that the update initially occurs, but for unknown reasons the update > > does not stick or is somehow set to null later. There are no error > > return codes to indicate why. The problem can be recreated in the lab, > > and users would like to trace this in a lab environment. > > > > =20 > > > > Is there an easy way to turn on a trace within Informix that might give > > us more information? > > > > =20 > > > > It would be helpful to confirm that subsequent SQL is not setting the > > column to null after the update. We could not find any evidence of this > > in the application code ... just want to eliminate this for sure as a > > potential root cause. > > > > =20 > > > > Thanks, > > > > ******************************************************************* > > > > Ernie Knox > > > > IT Database Administrator Specialist > > > > Sears Holdings - BU: I & T Group > > > > 3333 Beverly Rd. > > > > Hoffman Estates, IL. 60179 > > > > Office: (847) 286-5735 > > > > Email: Ernest.Knox@searshc.com > > > > Blackberry: 2244650553@messaging.sprintpcs.com > > <mailto:2244650553@messaging.sprintpcs.com>=20 > > > > Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com > > > > Informix Primary: INFORMIXDBAPrimaryPager@searshc.com > > > > Informix Secondary: INFORMIXDBASecondaryPager@searshc.com > > > > MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com > > > > MySQL Primary: MYSQLDBAPrimaryPager@searshc.com > > > > MySQL Secondary: MYSQLDBASecondaryPager@searshc.com > > > > =20 > > > > " Yes we can make a Change! " > > > > " It's always a great day to watch Sports: " > > > > " Lets GO Detroit: Lions, Tigers, Pistons, and Red Wings! " > > > > " Lets GO Chicago: Bears, Cubs, White Sox, Bulls, and Black Hawks! " > > > > GSU > > > > ******************************************************************* > > > > This message, including any attachments, is the property of Sears > Holdings > > = > > Corporation and/or one of its subsidiaries. It is confidential and may > > cont= > > ain proprietary or legally privileged information. If you are not the > > inten= > > ded recipient, please delete it without reading the contents. Thank you. > > > > > > > > > > **************************************************************************** *** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --90e6ba6e89144e480204b659e1dc > > > > **************************************************************************** *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Warm Regards, Neville Monteiro. --bcaec53f37ed054f6704b6618ad7 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

IDS: 10.00.TC9X3 OS: MS Windows 2000 SP4 ODBC Driver: Informix 3.33 32 Bit Version 3.33.00.10688 Question: Is there a 2k limit on the text entered in the following field, w= hich could be based on the IDS version or the ODBC driver version? It work= s fine for data entered below 2k, but seems to be lost if greater than 2k. fleet_cust_comment lvarchar=20 default null, DBSCHEMA Schema Utility INFORMIX-SQL Version 10.00.TC9X3=20=20 Copyright IBM Corporation 1996, 2006 All rights reserved { TABLE "informix".cc_repair_rational row size =3D 4448 number of columns = =3D 41 index=20 size =3D 14 } create table "informix".cc_repair_rational=20 ( workorder_no char(7) not null , seq_no smallint not null , date_time_sent datetime year to second, date_time_received datetime year to second, epo_status char(1), shc_comments lvarchar=20 default null, fleet_cust_comment lvarchar=20 default null, in_shop char(1), towed_in char(1), coupon_number varchar(20), min_brk_pad_rf decimal(8,3), min_brk_pad_rr decimal(8,3), min_brk_pad_lf decimal(8,3), min_brk_pad_lr decimal(8,3), tire_tread_lf_in smallint, tire_tread_lf_mid smallint, tire_tread_lf_out smallint, tire_tread_lr_in smallint, tire_tread_lr_mid smallint, tire_tread_lr_out smallint, tire_tread_rf_in smallint, tire_tread_rf_mid smallint, tire_tread_rf_out smallint, tire_tread_rr_in smallint, tire_tread_rr_mid smallint, tire_tread_rr_out smallint, spare_tread_in smallint, spare_tread_mid smallint, spare_tread_out smallint, roter_actual_sp_lf decimal(9,3), roter_actual_sp_rf decimal(9,3), roter_actual_sp_lr decimal(9,3), roter_actual_sp_rr decimal(9,3), eng_dia_code1 varchar(10), eng_dia_code2 varchar(10), eng_dia_code3 varchar(10), eng_dia_desc1 varchar(50), eng_dia_desc2 varchar(50), eng_dia_desc3 varchar(50), error_code smallint, error_desc varchar(30), primary key (workorder_no,seq_no) constraint "informix".ct_cc_repair_r= a1 ) extent size 32 next size 32 lock mode page; Thanks, ******************************************************************* Ernie Knox IT Database=A0Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd. Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry:=A02244650553@messaging.sprintpcs.com Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com Informix Primary: INFORMIXDBAPrimaryPager@searshc.com Informix Secondary: INFORMIXDBASecondaryPager@searshc.com MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com MySQL Primary: MYSQLDBAPrimaryPager@searshc.com MySQL Secondary: MYSQLDBASecondaryPager@searshc.com " Yes we can make a Change! " " It's always a great day to watch=A0Sports: " " Lets GO Detroit: Lions, Tigers, Pistons, and Red Wings! " " Lets GO Chicago: Bears, Cubs, White Sox, Bulls, and Black Hawks! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art K= agel Sent: Thursday, January 12, 2012 2:38 PM To: ids@iiug.org Subject: Re: Intermittent Loss of eAuth Response Comments [25912] TRACE ON/OFF only works within stored procedures. Couple of options that I see:=20 1. You can try the xtrace utility and see what it catches.=20 2. Try to catch the offending SQL using AGS Sentinel=20 3. See if iWatch from Exact-Solutions can work with 10.00 (don't=20 remember). If it does it will capture the update and the session details=20 of where the update came from.=20 Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/=20 Disclaimer: Please keep in mind that my own opinions are my own opinions an= d do not reflect on my employer, Advanced DataTools, the IIUG, nor any othe= r 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 ent= ities themselves.=20 On Thu, Jan 12, 2012 at 1:27 PM, Knox, Ernest <Ernest.Knox@searshc.com>wrot= e:=20 > IDS: 10.00.TC9X3 >=20 > OS: MS Windows 2000 SP4 >=20 > =3D20 >=20 > Would the TRACE ON and TRACE OFF help in the below case?=20 >=20 > =3D20 >=20 > In a nutshell, we are intermittently losing the update to a column=20 > containing fleet management work order authorization comments. We know=20 > that the update initially occurs, but for unknown reasons the update=20 > does not stick or is somehow set to null later. There are no error=20 > return codes to indicate why. The problem can be recreated in the lab,=20 > and users would like to trace this in a lab environment. >=20 > =3D20 >=20 > Is there an easy way to turn on a trace within Informix that might=20 > give us more information? >=20 > =3D20 >=20 > It would be helpful to confirm that subsequent SQL is not setting the=20 > column to null after the update. We could not find any evidence of=20 > this in the application code ... just want to eliminate this for sure=20 > as a potential root cause. >=20 > =3D20 >=20 > Thanks, >=20 > ******************************************************************* >=20 > Ernie Knox >=20 > IT Database Administrator Specialist >=20 > Sears Holdings - BU: I & T Group >=20 > 3333 Beverly Rd.=20 >=20 > Hoffman Estates, IL. 60179 >=20 > Office: (847) 286-5735 >=20 > Email: Ernest.Knox@searshc.com >=20 > Blackberry: 2244650553@messaging.sprintpcs.com > <mailto:2244650553@messaging.sprintpcs.com>=3D20 >=20 > Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com >=20 > Informix Primary: INFORMIXDBAPrimaryPager@searshc.com >=20 > Informix Secondary: INFORMIXDBASecondaryPager@searshc.com >=20 > MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com >=20 > MySQL Primary: MYSQLDBAPrimaryPager@searshc.com >=20 > MySQL Secondary: MYSQLDBASecondaryPager@searshc.com >=20 > =3D20 >=20 > " Yes we can make a Change! "=20 >=20 > " It's always a great day to watch Sports: "=20 >=20 > " Lets GO Detroit: Lions, Tigers, Pistons, and Red Wings! "=20 >=20 > " Lets GO Chicago: Bears, Cubs, White Sox, Bulls, and Black Hawks! "=20 >=20 > GSU >=20 > ******************************************************************* >=20 > This message, including any attachments, is the property of Sears=20 > Holdings =3D Corporation and/or one of its subsidiaries. It is=20 > confidential and may cont=3D ain proprietary or legally privileged=20 > information. If you are not the i