Re: Replication Error : HDR,
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.
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).
>>