Show TOC

rs_delexception_rangeLocate this document in the navigation structure

Deletes a range of transactions identified by originating site or user , or destination site in the exceptions log in the rs_exceptscmd, rs_exceptshdr, and rs_systext system tables.

Syntax
rs_delexception_range 
{{"origin"|"org"}, "<origin_data_server>.<origin_database>" | 
, {"destination"|"dest"}, "<destination_data_server>.<destination_database>" | 
, "user", "<origin_user>"}
Parameters
"origin"/"org", "<origin_data_server>.<origin_database>"

Enter "origin" or the short form—"org" and specify the data server and database that originated the transactions you want to delete from the exceptions log. Enclose these parameters in double quotation marks, and use commas to separate the parameters from each other.

"destination"/"dest", "<destination_data_server>.<destination_database>"

Enter destination or the short form—"dest" and specify the data server and database that received the transactions you want to delete from the exceptions log. Enclose these parameters in double quotation marks, and use commas to separate the parameters from each other.

"user", "<origin_user>"

Enter "user" and specify the user that originated the transactions you want to delete from the exceptions log. Enclose these parameters in double quotation marks, and use commas to separate the parameters from each other.

Examples
Example 1

Deletes from the exceptions log the transactions that originated from the south_db database of the SYDNEY_DS data server.

rs_delexception_range "org", "SYDNEY_DS.south_db"
Example 2

Deletes from the exceptions log the transactions that were received by the east_db database of the TOKYO_DS data server.

rs_delexception_range "destination", "TOKYO_DS.east_db"
Example 3

Deletes from the exceptions log the transactions that originated from the rsuser1 user.

rs_delexception_range "user", "rsuser1"
Usage
  • You can enter only one parameter and the corresponding value at a time. For example, you cannot enter "org", "<origin_dataserver.origin_database>" followed by "user", "<origin_user>".

  • You must enter a parameter and specify a value. If you do not specify any parameter, rs_delexception_range displays an error message. See the Origin Site, Dest. Site, and Dest. User columns when you execute rs_helpexception or rs_delexception with no parameters, to obtain a current list of values for the respective columns for valid transaction in the exceptions log.

  • If you enter only "origin", "destination", or "user" with rs_delexception_range, and do not specify the corresponding values, rs_delexception_range displays an error message.

  • rs_delexception_range displays an error message if the command you enter does not result in any transactions being deleted.
Related Information