How can we check the size of a table in db2?

2 years ago
Noah Thompson
1 minute

In DB2, you can determine the size of a table’s data using the following methods:

  1. The SYSCAT.TABLES.
SELECT TABSCHEMA, TABNAME, CARD
FROM SYSCAT.TABLES
WHERE TABSCHEMA = 'your_schema_name' AND TABNAME = 'your_table_name';

your_schema_name and your_table_name represent the schema and table names of the tables to be queried. CARD indicates the size of the data in the table.

  1. Retrieve information about a table using the SYSPROC.ADMIN_GET_TAB_INFO method.
CALL SYSPROC.ADMIN_GET_TAB_INFO('your_schema_name', 'your_table_name', NULL, NULL, -1);

Your_schema_name and your_table_name are respectively the schema and table names of the tables you want to query.

  1. Generate the schema DDL statements for a DB2 database.
db2look -d your_database_name -e -t your_schema_name.your_table_name | grep -i "Estimated number of rows"

your_database_name, your_schema_name, and your_table_name respectively refer to the database, schema, and table names of the tables being queried.

Note: The table names in the above method are case-sensitive and may need adjustment based on the actual situation.

bannerAds