Source and Destination for autobcp when DB is Oracle
book
Article ID: 106925
calendar_today
Updated On:
Products
CA Workload Automation AE - Business Agents (AutoSys)CA Workload Automation AE - Scheduler (AutoSys)CA Workload Automation Agent
Issue/Introduction
how to determine source / destination for autobcp when using Oracle as the DB?
Environment
Release: Component: ATSYS
Resolution
Do a row count of the ujo_proc_event table from each Event Server and use the Event Server which has the higher count as the source DB for autobcp. select count(*) from ujo_proc_event; Run the following query to verify the source DB has the later date: SELECT SCN_TO_TIMESTAMP(MAX(ora_rowscn)) from ujo_proc_event;