IDS Forum

Re: Intermittent Loss of eAuth Response Comments

Posted By: John Miller iii
Date: Thursday, 12 January 2012, at 2:04 p.m.

In Response To: Intermittent Loss of eAuth Response Comments (Knox, Ernest)

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.
>

Messages In This Thread

• Intermittent Loss of eAuth Response Comments
  Knox, Ernest -- Thursday, 12 January 2012, at 1:27 p.m.
  • Re: Intermittent Loss of eAuth Response Comments
    John Miller iii -- Thursday, 12 January 2012, at 2:04 p.m.
  • Re: Intermittent Loss of eAuth Response Comments
    Art Kagel -- Thursday, 12 January 2012, at 2:37 p.m.
    • RE: Intermittent Loss of eAuth Response Comments
      Knox, Ernest -- Thursday, 12 January 2012, at 11:34 p.m.
    • Re: Intermittent Loss of eAuth Response Comments
      Neville Monteiro -- Thursday, 12 January 2012, at 11:45 p.m.
      • Re: Intermittent Loss of eAuth Response Comments
        Art Kagel -- Friday, 13 January 2012, at 5:41 a.m.
      • RE: Intermittent Loss of eAuth Response Comments
        Paul Watson -- Friday, 13 January 2012, at 6:00 a.m.
    • RE: Intermittent Loss of eAuth Response Comments
      Knox, Ernest -- Thursday, 19 January 2012, at 5:02 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.