Re: Replication Error : HDR,

In article <690g6s$lgc$1@gte1.gte.net>, Rus Ambler <rnspambler@vsol.com> writes >Same boxes etc, different error; One of the instances is in constant >replication (the instance is marked in recovery mode) and all works fine for >selects, however, I am unable to create temporary tables under it. > DO CREATE TEMP TABLE a(...) WITH NO LOG ^^^^^^^^^^^ SELECT...INTO TEMP xx WITH NO LOG ^^^^^^^^^^^ You cannot create logical/physical log entries on the secondary server. >There errors that I'm getting are SQL -229, ISAM -131 and the error is >instantaneous. This error occurs for both normal users and the INFORMIX >user. > >The following is from the onstat -d output > >---------------------------------------------------------------------------- >-- >1 2001 5 1 N T informix dbtemp > >5 5 0 500000 482721 PO- /dev/informix/dbtemp >---------------------------------------------------------------------------- >-- > >onstat -c gives me :> >---------------------------------------------------------------------------- >-- >DBSPACETEMP dbtemp >---------------------------------------------------------------------------- >--> >Is this because the db is being replicated and thus in readonly mode ? If >this is the case, does this mean that you cannot create temp tables in a r/o >database ? > >Cheers in advance > >Rus Ambler > >David Williams wrote in message ... >>In article <68tu49$852$1@gte1.gte.net>, Hitesh Dave <davehit@vsol.com> >>writes >>>Hi folks, >>> >>> We have informix ver 7.23 running on solaris 5.5.1. We have two >>>informix instances configured in data replication pair (HDR). >>> > > > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care