版次注意事項


10.2 db2cap (new command)

db2cap - CLI/ODBC Static Package Binding Tool

Binds a capture file to generate one or more static packages. A capture file is generated during a static profiling session of a CLI/ODBC/JDBC application, and contains SQL statements that were captured during the application run. This utility processes the capture file so that it can be used by the CLI/ODBC/JDBC driver to execute static SQL for the application.

For more information on how to use static SQL in CLI/ODBC/JDBC applications, see the Static Profiling feature in the CLI Guide and Reference.

Authorization

Command Syntax

>>-db2cap----+----+--bind--capture-file----d--database_alias---->
             +--h-+
             '--?-'
 
>-----+--------------------------------+-----------------------><
      '--u--userid--+---------------+--'
                    '--p--password--'
 

Command Parameters

-h/-?
Displays help text for the command syntax.

bind capture-file
Binds the statements from the capture file and creates one or more packages.

-d database_alias
Specifies the database alias for the database that will contain one or more packages.

-u userid
Specifies the user ID to be used to connect to the data source.

Note:
If a user ID is not specified, a trusted authorization ID is obtained from the system.

-p password
Specifies the password to be used to connect to the data source.

Usage Notes

The command must be entered in lowercase on UNIX platforms, but can be entered in either lowercase or uppercase on Windows operating systems and OS/2.

This utility supports a number of user-specified bind options that can be found in the capture file. For performance and security reasons, the file can be examined and edited with a text editor to change these options.

The SQLERROR(CONTINUE) and the VALIDATE(RUN) bind options can be used to create a package.

When using this utility to create a package, static profiling must be disabled.

The number of packages created depends on the isolation levels used for the SQL statements that are recorded in the capture file. The package name consists of up to a maximum of the first seven characters of the package keyword from the capture file, and one of the following single-character suffixes:

To obtain specific information about packages, the user can:


[ 頁面頂端 | 前一頁 | 下一頁 | 目錄 | 索引 ]