- To view the log table for history and any errors, execute the following
query.
SELECT * FROM inuser.IN_DB_UTIL_LOG ORDER BY LOG_ID;
- To view active session details, execute the following
procedure.
EXEC inuser.IN_DB_UTIL_SP_SESSIONS_DISPLAY;
- To view call stack details, execute the following
procedure.
EXEC inuser.IN_DB_UTIL_SP_CALLSTACK_PRINT;
- To view the contents of the table containing active session details and attributes, execute the
following command. This table is queried by the IN_DB_UTIL_SP_SESSIONS_DISPLAY
procedure, which should be used
instead.
SELECT * FROM inuser.IN_DB_UTIL_SESSION_ATTRIBUTES ORDER BY IDENTIFIER;
- To view the contents of the table containing call stack depth between stored procedures execute
the following command. This table is queried by the IN_DB_UTIL_SP_CALLSTACK_PRINT
procedure, which should be used
instead.
SELECT * FROM inuser.IN_DB_UTIL_CALLSTACK ORDER BY IDENTIFIER, DEPTH;
- To view the current state of synchronization, execute the following. This table is queried by
the IN_DB_UPGRADE_SP_SYNC_GET_STATUS procedure, which can be used
instead.
SELECT * FROM inuser.SYNC_STATE_DOC;
- To view the history of synchronization activity, execute the following command. This table is
queried by the IN_DB_UPGRADE_SP_SYNC_GET_STATUS procedure, which can be used
instead.
SELECT * FROM inuser.SYNC_HIST_DOC ORDER BY SYNC_DATETIME;
- To view the history of synchronization errors, execute the following command. This table is
queried by the IN_DB_UPGRADE_SP_SYNC_GET_STATUS procedure, which can be used
instead.
SELECT * FROM inuser.SYNC_ERROR_DOC ORDER BY ACTION_DATETIME;