Chapter 4 Database Administration Utilities
119
The following command translates log information from the server
asademo and places the output in a file named
asademo.sql
.
dbtran -c "eng=asademo;dbn=asademo;uid=DBA;pwd=SQL" -n asademo.sql
♦ Against a transaction log file Run in this way, the utility acts directly
against a transaction log file. You should protect your transaction log
file from general access if you wish to prevent users from having the
capability of running this statement.
dbtran asademo.log asademo.sql
When the
dbtran
utility runs, it displays the earliest log offset in the
transaction log. This can be an effective method for determining the order in
which multiple log files were generated.
$ For more information about the command-line switches, see "Log
translation utility options" on page 119
Log translation utility options
Include uncommitted transactions (–a) The transaction log contains
any changes made before the most recent COMMIT by any transaction.
Changes made after the most recent commit are not present in the transaction
log.
Connection string (–c) When running the command-line utility against a
database server, this parameter specifies the connection string.
DBA authority is required to run
dbtran
.
$ For a description of the connection parameters, see "Connection
parameters" on page 64 of the book ASA User’s Guide.
Display output in chronological order (–d) Transactions are displayed
in order from earliest to latest. This feature is provided primarily for use
when auditing database activity: the output of this command should not be
applied against a database.
Output from last checkpoint only (–f) Only transactions that were
completed since the last checkpoint are output.
Include audit information (–g) If the AUDITING database option is
turned on, auditing information is added to the transaction log. You can
include this information as comments in the output file using this option.
$ For more information, see "AUDITING option" on page 172.
To Next Page
Loading...