MichaelB.
7/29/2018 - 6:54 PM

Check SDI system information

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;