I've been preparing two systems for Primary-Target replication and I've successfully defined the primary the primary database server. However, when I try to define the secondary server I get the following error.
command failed -- *Error* <-1> is not a known Enterprise Replication error (-1)
The command I used to define the primary server is:
cdr define server --init g_development
I've tried several commands for the secondary server:
This command is run from the primary server:
cdr define server --connect=demo_on --init --sync=g_development g_swxtest2
These commands were run from the secondary server:
cdr define server --init g_swxtest2
cdr define server --init --sync=g_development g_swxtest2
In dbaccess on both servers I can successfully access the databases on either server.
Entries in the services file on both servers:
onnet 1526/tcp
idsrep 1530/tcp
Entries in the hosts.equiv file on both servers:
swxtest2 informix
development informix
sqlhosts on swxtest2:
s2_demo onipcshm on_hostname on_servername
demo_se seipcpip se_hostname sqlexec
#develop101 onipcshm swxtest2 online
#develop101inet onsoctcp swxtest2 onnet
g_development group - - i=101
develop101inet onsoctcp development onnet g=g_development
g_swxtest2 group - - i=102
demo_on onsoctcp swxtest2 idsrep g=g_swxtest2
sqlhosts on development:
#demo_on onipcshm on_hostname on_servername
#demo_se seipcpip se_hostname sqlexec
develop101 onipcshm development online
#develop101inet onsoctcp development onnet
g_development group - - i=101
develop101inet onsoctcp development onnet g=g_development
g_swxtest2 group - - i=102
demo_on onsoctcp swxtest2 idsrep g=g_swxtest2
#develop101inet onsoctcp swxtest2 onnet g=g_swxtest2
onconfig files attached.
Last several lines of the online.log on swxtest2:
15:41:27 Maximum server connections 0
15:41:27 Dropping temporary TBLspace 0x100139, recovering 28 pages.
15:41:27 Checkpoint Completed: duration was 0 seconds.
15:41:27 Checkpoint loguniq 6, logpos 0x8f0c8, timestamp: 87881
15:41:27 Maximum server connections 0
15:41:27 On-Line Mode
15:45:19 Booting Language <spl> from module <>
15:45:19 Loading Module <SPLNULL>
15:45:20 CDR catalog statement failed 'create database syscdr with log' error: -312 -131
15:45:20 CDR Initialization failed (Catalog Initialization Failed).
15:46:57 Checkpoint Completed: duration was 0 seconds.
15:46:57 Checkpoint loguniq 6, logpos 0xf9018, timestamp: 96610
15:46:57 Maximum server connections 1
15:47:15 CDR catalog statement failed 'create database syscdr with log' error: -312 -131
15:47:15 CDR Initialization failed (Catalog Initialization Failed).
15:48:46 CDR catalog statement failed 'create database syscdr with log' error: -312 -131
15:48:46 CDR Initialization failed (Catalog Initialization Failed).
15:50:10 CDR catalog statement failed 'create database syscdr with log' error: -312 -131
15:50:10 CDR Initialization failed (Catalog Initialization Failed).
15:50:11 Logical Log 6 Complete, timestamp:122523.
15:50:11 Process exited with return code 127: /bin/sh /bin/sh -c /usr/informix/etc/alarmprogram.sh 2 23 "Logical Log 6 Complete, timestamp:122523." "Logical Log 6 Comp
15:51:57 Checkpoint Completed: duration was 0 seconds.
15:51:57 Checkpoint loguniq 7, logpos 0x40018, timestamp: 122533
15:51:57 Maximum server connections 1
15:56:56 Checkpoint Completed: duration was 0 seconds.
15:56:56 Checkpoint loguniq 7, logpos 0x41018, timestamp: 122538
I believe it may have something to do with the failure to create the syscdr database shown in the log above.
Thanks in advance for your help.
Mark
Go SOCA WARRIORS - World Cup 2006