Dear experts,
I am setting up database replication from
Scenario1: ASE1(PDS) to ASE2(TDS) via ASE_RS2(PRS) and ASE_RRS(RRS)
Scenario2: PROD(PDS) to UAT(TDS) via ASE_RS(PRS) and ASE_R(RRS)
using the below steps.
1.Create databases
2.Create connections
3.Create direct routes for the involved replication servers
4.Create database replication definition in PRS and subscriptio for the database repdef in RRS
5.Create table in PDS.PDB and check the data is getting replicated in TDS.TDB
Correct me if I have missed any.
********************************************************************************************************************
For scenario1:
1.Create database E30_2 in ASE1,ASE2
2.Create connection for ASE1.E30_2 in ASE_RS2 and connection for ASE2.E30_2 in ASE_RRS.
3.Create direct routes between ASE_RS2 and ASE_RRS.
4.Create replication definition for the database E30_2 in ASE_RS2 using the below command.
create database replication definition RepDep_E30_2_For_ASE_RRS
with primary at ASE1.E30_2
replicate DDL
replicate sqldml
5.Create subscription for the database replication definition using the command,
create subscription SubDef_E30_2_From_ASE_RS2
for RepDep_E30_2_For_ASE_RRS
with primary at ASE1.E30_2
with replicate at ASE2.E30_2
Observation: The database replication definition got created successfully but I am unable to create the subscription for it (due to the issue like - ASE1.E30_2 is not a valid site for ASE_RS2)
*********************************************************************************************************************
For scenario2:
1.Create database E30_2_MSA_Target1 in PROD,UAT
2.Create connection for PROD.E30_MSA_Target1 in ASE_RS and connection for UAT_E30_MSA_Target1 in ASE_R.
3.Create direct routes between ASE_RS and ASE_R.
4.Create replication definition for the database E30_MSA_Target1 in ASE_RS using the below command.
create database replication definition RepDep_E30_MSA_Target1_For_ASE_R
with primary at PROD.E30_MSA_Target1
replicate DDL
replicate sqldml
5.Create subscription for the database replication definition using the command,
create subscription SubDef_E30_MSA_Target1_From_ASE_RS
for RepDep_E30_MSA_Target1_For_ASE_R
with primary at PROD.E30_MSA_Target1
with replicate at UAT.E30_MSA_Target1
Observation: The database replication definition for created successfully and the subscription got created after I specify 'without materialization', however it is going into 'unknown' status(rs_helpdbsub) even I after executing validate subscription
Strange in scenario1 the subscription itself is not getting created and in scenario2 that validate subscription even though it prompted the output "subscription is now valid" but still showing the status of it as unknown.
Please advise.