Writes the first transaction in a DSI queue into the exceptions log.
sysadmin log_first_tran, [n], data_server, database
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.
The name of the data server with the database.
The name of the database from whose DSI queue the first transaction is to be written.
Writes the first transaction in this DSI queue to the exceptions log:
sysadmin log_first_tran, SYDNEY_DS, pubs2
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
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 Chapter 8, “Replication Server System Tables,” for detailed descriptions of these tables.
sysadmin log_first_tran requires “sa” permission.
