how to determine source / destination for autobcp

book

Article ID: 106040

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

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;
un the following query to verify the source DB has the later date: SELECT SCN_TO_TIMESTAMP(MAX(ora_rowscn)) from ujo_proc_event;