Use this command to specify an alternate log file to be used by the sysadmin dump_queue and sysadmin sqt_dump_queue commands for output.
Here is the syntax for the sysadmin dump_file command:
sysadmin dump_file [, file_name]
where file_name is the local name of the file where dumps will be directed.
If you omit file_name, the current dump file is closed. If you specify file_name and a dump file currently exists, then the current dump file is closed and a new file is opened. The new file uses the name specified with the optional file_name entry.
These examples demonstrate how to use sysadmin dump_file.
This command dumps the contents of queue 100:1 into the Replication Server log:
sysadmin dump_queue, 100, 1, -1, 1, -2
The following series of commands use sysadmin dump_file to specify an alternate log file.
This command specifies file1 as the alternate log file:
sysadmin dump_file, file1
This command outputs the contents of queue 100:1 into file1:
sysadmin dump_queue, 100, 1, -1, 1, -2
This command closes file1 and opens file2. file2 receives the output from subsequent dumps:
sysadmin dump_file, file2
This command dumps transaction statements from queue 100:1 into file2:
sysadmin sqt_dump_queue, 100, 1, 0
This command closes file2:
sysadmin dump_file
This command dumps the output from queue 103:1 into the Replication Server log:
sysadmin dump_queue, 103, 1, 0, 11, 63