sysadmin dump_error

The sysadmin dump_error command has been added to retrieve diagnosable error information logged in Replication. You can use this command to lookup all or specific errors that were logged into the database memory.

Syntax

sysadmin dump_error
[, row_id [, option]]
[, thread[, {conn_id | server[, database]}[, qtype]]]

Parameters

row_id: If this is not specified, the command searches for and returns multiple diagnosable errors, and does not search look for a unique thread instance, or for multiple errors that were logged for a unique thread instance. The first column in the output indicates the row number.
option: Identifies additional options to dump diagnosable errors. Currently, the only acceptable value for this parameter is <diag>, which instructs Replication Server to dump all additional internal information.
thread: Identifies the type of thread to retrieve errors from. Acceptable parameter values are <DSI EXEC>, <DIST>, <SQT>, <SQM>, and so on.
conn_id: Identifies the thread instance. For DSI and DIST threads, this is the Database ID. For SQT and SQM threads, it is the queue number.
server; database: These parameters identify the instance name of the thread for which you want to retrieve the error.
qtype: Applicable only if you are retrieving error information for SQM/SQT thread.