2011年12月30日 星期五

Examples of DB2 system commands

http://www.ibm.com/developerworks/data/library/techarticle/0307fierros/0307fierros.html

Examples of DB2 system commands

Command Description
db2audit DB2 provides an audit facility to assist in the detection of unknown or unanticipated access to data. This utility can be used to automate security auditing as described in Scripting scenarios.
db2batch Reads SQL statements from either a flat file or standard input, dynamically prepares and describes the statements, and returns an answer set. This DB2 command can be used within a script designed for benchmarking different instance and database configuration parameters. You will want to restart the instance and capture system information such as DB2 registry, instance, and database configurations before invoking this utility.
db2exfmt Formats the contents of the explain tables. This DB2 command can be used within a script designed for SQL tuning because you can use it to automate the explaining, extraction, and formatting of SQL statement. Scripting this DB2 command allows a large number of SQL statements to be explained, extracted, and formatted for review at a later time.
db2chkbk This utility can be used to test the integrity of a backup image and to determine whether or not the image can be restored. This utility can be very useful at the end of a database backup script to generate a backup completion report.
db2flsn Returns the name of the database transaction log file that contains the log record identified by a specified log sequence number (LSN). This utility can be very useful as part of a database transaction log pruning script when log retain is enabled for recovery and you are running data replication and need to determine where to start pruning transaction logs.

沒有留言:

張貼留言