analyse_plan

With this command, you can analyze the output of the db_get_exfmt command.

While analyzing the output of the db_get_exfmt command, the analyse_plan command provides the data of the Objects Used in the Access Plan. The data includes row_count, compression_ratio and other parameters of the objects used. Objects in the SYSIBM schema are not considered.

Usage

analyse_plan [-h] [-host HOST] [-db DB] [-dsn DSN] [-user USER] [-pw PW] -file FILE

Basic parameters

-h | --help: Displays help for the command.

Required parameters

-file FILE: Specifies the file to be analyzed.

Optional parameters

-host HOST: Specifies the hostname for which you want to get details.
Localhost is the default value.
-db DB: Specifies the database for which you want to get stats. The default is BLUDB.
-dsn DSN: An alternative for the -db and -host options.
-user USER: Specifies the database user.
-pw PW: Specifies the database password.

Examples

[bluadmin@host - Db2wh support_tools]$ analyse_plan -file f4.sql.exfmt -u bluadmin -pw bluadmin
Connection successful ..

 Object referred details ..
TABLE               COLUMN      ROW_COUNT      COMPR_RATIO
------------------  ----------  -----------  -------------
BLUADMIN.SHORTLINE  L_ORDERKEY  6,001,215             3.57