db_get_exfmt

You can run the db_get_exfmt script to obtain the table format.

The tool is used to achieve the table format which includes:
  • Crucial query execution parameters
  • Optimized query
  • Access plan
  • Plan details

Usage

db_get_exfmt [-h] [-db DB] [-schema SCHEMA] [-sql SQL] [-out OUT] [-user USER] [-pw PW]

Basic parameters

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

Optional parameters

-db DB
Specifies the database for which you want to obtain statistics. The default is BLUDB.
-schema SCHEMA
Specifies the schema under which the query is to be fired.
-sql SQL
Specifies the file container with the SQL query.
-out out
Output file name with details. The default is <input_sql>.exfmt.
-user USER
Specifies the database user.
-pw PW
Specifies the database password

Examples

  • [bluadmin@host - Db2wh support_tools]$ db_get_exfmt -sql f1.sql -user bluadmin -pw bluadmin
DB2 Universal Database Version 11.1, 5622-044 (c) Copyright IBM Corp. 1991, 2017
Licensed Material - Program Property of IBM
IBM DATABASE 2 Explain Table Format Tool

Connect to Database Successful.
Using SYSTOOLS schema for Explain tables.
Output is in f1.sql.exfmt.
Executing Connect Reset -- Connect Reset was Successful.