db_table_skew

With db_table_skew, you can obtain the skew ratio for all the tables specified in the schema.

Usage

db_table_skew [-h] [-host HOST] [-db DB] [-dsn DSN] [-schema SCHEMA] [-table TABLE] [-user USER] [-pw PW]

Basic parameters

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

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.
-schema SCHEMA
Specifies the schema under which all of the tables exist.
-table TABLE
Specifies the table for which you are looking up statistics. Separate the entries with a comma. If the parameter is not provided, the skew info for all the tables in a user-defined schema is displayed.
-user USER
Specifies the database user.
-pw PW
Specifies the database password.

Examples

  • [bluadmin@host - Db2wh support_tools]$ db_table_skew
'DB_USER' not exported. Enter username for BLUDB: bluadmin
'DB_PASSWORD' not exported. Enter password for bluadmin@BLUDB:

 Table Skew Information ...
TABLENAME             SKEW_RATIO
--------------------  ------------
BLUADMIN.T1           0.00-0.00