SQL Error 195 after CDR DEFINE SERVER
Hi masters!
I'm creating a ER Domain between IDS 10.00.FC11 and IDS 10.00.fc8w4x5 and when
i run the "CDR DEFINE SERVER" command in one, i get the error:
"SQL Error (195)"
My ER Domain consists of:
- two member servers AIX6;
- a server version 10.00.fc8w4x5 (g_ssegh)
- the another version 10.00.fc11 (g_u01h)
- primaty-target replication;
- master is g_ssegh;
- slave is g_u01h;
- the onconfig's cdr parameters is OK;
- there are navegability between the intances:
- i can access the instances through groups;
- user informix is OK;
- the directories ATS and RIS have permissions OK in the SO and they can by
accessed and writen by informix user;
- session variables is OK;
- /etc/services is OK too;
I ran the command successfully "cdr define server --init g_ssegh
--ats=$INFORMIXDIR/tmp/ats --ris=$INFORMIXDIR/tmp/ris" in the g_ssegh.
but when you run the command "cdr define server --connect=g_u01h
--ats=$INFORMIXDIR/tmp/ats --ris=$INFORMIXDIR/tmp/ris --sync=g_ssegh --init
g_u01h", it returned the error SQL Error (195). I then tried to run the
command in g_u01h's console but the error continued.
The online.log (g_ssegh) show no error.
The online.log (g_u01h) show no error, just that:
12:24:16 Maximum server connections 2
12:25:22 Loading Module <SPLNULL>
12:25:22 Unloading Module <SPLNULL>
12:25:22 Building 'syscdr' database ...
12:25:22 Loading Module <SPLNULL>
12:25:22 'syscdr' database built successfully.
12:25:22 Unloading Module <SPLNULL>
12:25:32 Loading Module <SPLNULL>
12:25:33 Unloading Module <SPLNULL>
12:25:33 Building 'syscdr' database ...
12:25:33 Loading Module <SPLNULL>
12:25:33 'syscdr' database built successfully.
12:25:33 Unloading Module <SPLNULL>
12:29:16 Checkpoint loguniq 7, logpos 0x37530b8, timestamp: 0xc72c7cd
The g_u01h and g_ssegh SQLHosts file:
dbu01h onipcshm server01 sqlu01h
g_u01h group - - i=1011u01h onsoctcp *server01 sqldu01h g=g_u01h
dbssegh onipcshm server01 sqlssegh
g_ssegh group - - i=1021ssegh onsoctcp *server01 sqldssegh g=g_ssegh
Observation:
My instance g_u01h at version 10.00.fc8w4x7 and when I ran the command "cdr
define server --ats=$INFORMIXDIR/tmp/ats --ris=$INFORMIXDIR/tmp/ris
--sync=g_ssegh --init g_u01h", the error "General Error (1) (1)" that was
generated. See my previous post...
So that there will be some problem with the Sqlhosts, Onconfig or what else
might be wrong? My environment is apparently is OK...
anyone have any ideas?
tks!!
Hugo.
hugomna@ig.com.br
Please confirm that the following are valid.
CDR_DBSPACE
CDR_QHDR_DBSPACE
CDR_QDATA_SBSPACE.
Also include the message log file on both g_ssegh and g_u01h.
M.P.
From: "HUGO AGUIAR" <hugomna@ig.com.br>
To: ids@iiug.org
Date: 02/25/2011 07:53 AM
Subject: SQL Error 195 after CDR DEFINE SERVER [22930]
Sent by: ids-bounces@iiug.org
Hi masters!
I'm creating a ER Domain between IDS 10.00.FC11 and IDS 10.00.fc8w4x5 and
when
i run the "CDR DEFINE SERVER" command in one, i get the error:
"SQL Error (195)"
My ER Domain consists of:
- two member servers AIX6;
- a server version 10.00.fc8w4x5 (g_ssegh)
- the another version 10.00.fc11 (g_u01h)
- primaty-target replication;
- master is g_ssegh;
- slave is g_u01h;
- the onconfig's cdr parameters is OK;
- there are navegability between the intances:
- i can access the instances through groups;
- user informix is OK;
- the directories ATS and RIS have permissions OK in the SO and they can by
accessed and writen by informix user;
- session variables is OK;
- /etc/services is OK too;
I ran the command successfully "cdr define server --init g_ssegh
--ats=$INFORMIXDIR/tmp/ats --ris=$INFORMIXDIR/tmp/ris" in the g_ssegh.
but when you run the command "cdr define server --connect=g_u01h
--ats=$INFORMIXDIR/tmp/ats --ris=$INFORMIXDIR/tmp/ris --sync=g_ssegh --init
g_u01h", it returned the error SQL Error (195). I then tried to run the
command in g_u01h's console but the error continued.
The online.log (g_ssegh) show no error.
The online.log (g_u01h) show no error, just that:
12:24:16 Maximum server connections 2
12:25:22 Loading Module <SPLNULL>
12:25:22 Unloading Module <SPLNULL>
12:25:22 Building 'syscdr' database ...
12:25:22 Loading Module <SPLNULL>
12:25:22 'syscdr' database built successfully.
12:25:22 Unloading Module <SPLNULL>
12:25:32 Loading Module <SPLNULL>
12:25:33 Unloading Module <SPLNULL>
12:25:33 Building 'syscdr' database ...
12:25:33 Loading Module <SPLNULL>
12:25:33 'syscdr' database built successfully.
12:25:33 Unloading Module <SPLNULL>
12:29:16 Checkpoint loguniq 7, logpos 0x37530b8, timestamp: 0xc72c7cd
The g_u01h and g_ssegh SQLHosts file:
dbu01h onipcshm server01 sqlu01h
g_u01h group - - i=1011u01h onsoctcp *server01 sqldu01h g=g_u01h
dbssegh onipcshm server01 sqlssegh
g_ssegh group - - i=1021ssegh onsoctcp *server01 sqldssegh g=g_ssegh
Observation:
My instance g_u01h at version 10.00.fc8w4x7 and when I ran the command "cdr
define server --ats=$INFORMIXDIR/tmp/ats --ris=$INFORMIXDIR/tmp/ris
--sync=g_ssegh --init g_u01h", the error "General Error (1) (1)" that was
generated. See my previous post...
So that there will be some problem with the Sqlhosts, Onconfig or what else
might be wrong? My environment is apparently is OK...
anyone have any ideas?
tks!!
Hugo.
hugomna@ig.com.br
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Hi MP!
Follow my g_u01h CDR variables:
CDR_EVALTHREADS 1,2
CDR_DSLOCKWAIT 5
CDR_QUEUEMEM 8192
CDR_NIFCOMPRESS 0
CDR_SERIAL 10,1
CDR_DBSPACE rootdbs
CDR_QHDR_DBSPACE erdbs
CDR_QDATA_SBSPACE ersbs
CDR_SUPPRESS_ATSRISWARN 2,3,4
CDR_MAX_DYNAMIC_LOGS 62
The g_u01h CDR chunks are OK.
If i run alone in g_u01h the command "cdr define server --init g_u01h
--ats=$INFORMIXDIR/tmp/ats --ris=$INFORMIXDIR/tmp/ris"
the error remains...
tks, Hugo