Show TOC

sysadmin dump_errorLocate this document in the navigation structure

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.

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

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.


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.


Identifies the type of thread to retrieve errors from. Acceptable parameter values are <DSI EXEC>, <DIST>, <SQT>, <SQM>, and so on.


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.


Applicable only if you are retrieving error information for SQM/SQT thread.