Use these statements to see available adapters, remote sources and agents. Can see whether CDC (Changed Data Capture) is supported in remote_sources view. Can use task operations executions view to see whether logical partitioning of task worked and which queries were ran.
-- View available EIM adapters SELECT * FROM adapters; -- View remote sources SELECT * FROM remote_sources; -- View agent running on remote server SELECT * FROM agents; -- Find recently executed tasks with processed rows and last time executed SELECT * FROM "SYS".M_TASKS; -- View task operations executions SELECT * FROM "_SYS_TASK"."TASK_OPERATIONS_EXECUTIONS:; -- View remote subscriptions SELECT * FROM remote_subscriptions; -- View remote subscription exceptions: SELECT * FROM REMOTE_SUBSCRIPTION_EXCEPTIONS; -- Process an Remote Subscription / Source error PROCESS REMOTE SUBSCRIPTION EXCEPTION <oid> RETRY;