Oninit cdi / Archive
Talk to an expert →

DR Default Isolation Level in SDS Secondary

Posted in 2011

Topics: High Availability & Replication, Transactions, Locking & Isolation

LEONARDI CARDOZO — — source: IIUG Forums & Mailing Lists

Hi I have a question because DR is default in SDS Secondary Server, how i can setup LC like a Default Isolation mode in SDS Secondary Server?.

↪ replying to LEONARDI CARDOZO
Art Kagel — — source: IIUG Forums & Mailing Lists

The easiest way would be to put the SET ISOLATION command into a login procedure for all users. 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 Fri, Sep 16, 2011 at 1:30 PM, LEONARDI CARDOZO < leonardi.cardozo@intl.pepsico.com> wrote: > Hi > > I have a question because DR is default in SDS Secondary Server, how i can > setup LC like a Default Isolation mode in SDS Secondary Server?. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --90e6ba6e8cf6f86b8604ad127506

↪ replying to LEONARDI CARDOZO
John Miller iii — — source: IIUG Forums & Mailing Lists

I would look at using the sysdbopen procedure that is automatically execute by all users at database connect time. John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 09/16/2011 10:30:05 AM: > From: "LEONARDI CARDOZO" <leonardi.cardozo@intl.pepsico.com> > To: ids@iiug.org > Date: 09/16/2011 10:31 AM > Subject: DR Default Isolation Level in SDS Secondary [24950] > Sent by: ids-bounces@iiug.org > > Hi > > I have a question because DR is default in SDS Secondary Server, how i can > setup LC like a Default Isolation mode in SDS Secondary Server?. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Glossary