db_tables_row_count

Run the command to get the row count for all of the specified tables or tables in a schema.

Usage

db_tables_row_count [-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 the table exists.
-table TABLE
Specifies the table for which you are looking up statistics.
-user USER
Specifies the database user.
-pw PW
Specifies the database password.

Examples

  • [bluadmin@host - Db2wh support_tools]$ db_tables_row_count -schema admin -table shortline
'DB_USER' not exported. Enter username for BLUDB: bluadmin
'DB_PASSWORD' not exported. Enter password for bluadmin@BLUDB:

 Table Row Information ...
TABLENAME          ROWCOUNT
---------------  ----------
ADMIN.SHORTLINE     6001215