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;