Database Administrators Asked by Tittus on February 15, 2021
if anyone knows what is the error? Can not use active or standby connection names for subscriptions
I got this error when I’m trying to create my subscriptions. I have already created a repdef WITH PRIMARY AT pb1.customer and when I tried to run my subscription, WITH REPLICATE AT pb2.customer. It is showing the error. I have also created a logical connection pb1.customer for dump/load db.
pb1 and pb2 are both ASE, ASE15.5 and ASE15.7 respectively.
Please advise.
The error message indicates you're using a WarmStandby (WS) setup, in which case there are no subscriptions required (nor supported), period.
If you're trying to use the WS pair as a source for replicating into a 3rd db, then the repdef will need to reference the WS logical pair as the primary db.
If you're trying to replicate into the WS pair from a 3rd db, then the subscription will reference the WS logical pair as the replicate db.
Answered by markp-fuso on February 15, 2021
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP