ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to determine which Oracle database to use as the source when synchronizing via autobcp


Article ID: 106925


Updated On:


CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) Workload Automation Agent


How to determine which Oracle database to use as the source DB and which to use as the destination DB when synchronizing via the script?


After a database failure where one or both of the databases were unreachable, you may not be quite sure which database was updated last.


Component: ATSYS


A row count of the ujo_proc_event table will help you determine which database to use as the source DB: 
select count(*) from ujo_proc_event;

The database with the higher row count is the one you should use as the source DB.

In addition to this, you can run the following query to verify the source DB has a later date than the destination DB:
SELECT SCN_TO_TIMESTAMP(MAX(ora_rowscn)) from ujo_proc_event;