Retrieve and Clean Logged Errors

New commands have been added to Replication Server to retrieve and clean errors logged in the database memory. You can use these commands to lookup the errors that were logged into the database, and cleanup the errors that are of no further use or utility.

Syntax

sysadmin dump_error: Use this command to retrieve diagnosable error information from the database:

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.

sysadmin clean_error: Use this command to cleanup error information that is of no further use or utility, for instance, connections already dropped from the system, or a thread already recovered from a previous error. If no parameter specified, all diagnosable errors saved in memory are removed.

Syntax:

sysadmin clean_error
[, thread[, server[, database[, qtype]]]]

Parameters: Refer to the descriptions above.