reading committed data on hdr

We are using informix IDS 12.1 with an HDR in near_sync mode. Some applications read data from hdr. We found that uncommitted data is also read n hdr that some times rollaback and information delivered at that instance does not recoincile. One solution might be keep the hdr in full_sync mode. But we are unaware of potential performance issues of setting hdr in full_sync mode. Please guide if there is a way to read only ccommitted data on hdr.

https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqls.doc/id s_sqs_2012.htm Enabling the UPDATABLE_SECONDARY parameter would allow supporting Committed Read, or Committed Read Last Committed transaction isolation levels. Regards, David. > On 12 January 2018 at 15:14 KAMRAN HAQ <khaq@i2cinc.com> wrote: > > > We are using informix IDS 12.1 with an HDR in near_sync mode. Some > applications read data from hdr. We found that uncommitted data is also read n > hdr that some times rollaback and information delivered at that instance does > not recoincile. One solution might be keep the hdr in full_sync mode. But we > are unaware of potential performance issues of setting hdr in full_sync mode. > Please guide if there is a way to read only ccommitted data on hdr. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >