sysadmin log_first

Writes the first transaction in a DSI queue into the exceptions log.

Syntax

sysadmin log_first_tran, [n], data_server, database

n – Specifies the number of transactions to write to the database exceptions log, and to either the Replication Server log or the alternative log file specified by the sysadmin dump_file command.
data_server – The name of the data server with the database.
database – The name of the database from whose DSI queue the first transaction is to be written.

Example 1 – Writes the first transaction in this DSI queue to the exceptions log:
```
sysadmin log_first_tran, SYDNEY_DS, pubs2
```
Example 2 – Writes the first five transactions in the DSI queue to the database exceptions log, and to either the Replication Server log or the location specified by the sysadmin dump_file command:
```
sysadmin log_first_tran, 5, SYDNEY_DS, pubs2
```
Example 3 – Writes the first two transactions in the DSI queue to the database exceptions log and to the SYDNEY_RS.log file. The last sysadmin dump_file command closes the SYDNEY_RS.log file:
```
sysadmin dump_file SYDNEY_RS.log
sysadmin log_first_tran, 2, SYDNEY_DS, pubs2
sysadmin dump_file
```

Use sysadmin log_first_tran to write the first n transactions in the DSI queue into the exceptions log, and to either the Replication Server log or the alternative log file specified by the sysadmin dump_file command.
This command does not delete the first n transactions from the queue.
The exceptions log consists of three tables, rs_exceptshdr, rs_exceptscmd, and rs_systext. See “Replication Server System Tables” for detailed descriptions of these tables.

sysadmin log_first_tran requires “sa” permission.