- To view the log table for the history and errors, execute the following
query.
SELECT * FROM IN_DB_UTIL_LOG ORDER BY LOG_ID;
- To view active session details for the SYNC and UPGRADE identifiers, execute the following
command.
EXEC IN_SESSIONS_DISPLAY 'ALL';
- To view active session details for the IN_DB_UTIL identifier, execute the following
command.
EXEC IN_SESSIONS_DISPLAY 'IN_DB_UTIL';
- To view call stack details, execute the following
command.
EXEC IN_CALLSTACK_PRINT 'ALL';
- 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.
SELECT * FROM IN_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.
SELECT * FROM IN_CALLSTACK ORDER BY IDENTIFIER, DEPTH;
- To view the application resource locks for the stored procedures and identifiers, that have
been allocated and are being held by each session, execute the following
query:
SELECT resource_description, request_session_id, request_reference_count
FROM sys.dm_tran_locks
WHERE resource_database_id = DB_ID('INOW')
AND resource_type = 'APPLICATION'
AND request_owner_type = 'SESSION';