How To Find Table Size In Db2 Luw at Matthew Mendelsohn blog

How To Find Table Size In Db2 Luw. Customer/consultant would like to find out how large each of their controller database tables (for example 'xdb18') are. Dbsize = sum (used_pages * page_size) for each table space (sms & dms). The admintabinfo administrative view returns size and state information for tables, materialized query tables (mqt) and hierarchy tables only. To list tables and their current sizes in descending order by size. Also lists whether table is column or row organized. The database size is calculated as follows: On db2 for luw you can use this query. You can get the underlying table physical size from the sysibmadm.admintabinfo table. You get one row per table data partition (1 row for a non range partitioned table). Perform the select below to know the size one table: Db2 select substr(a.tabname,1,30), (a.fpages*pagesize/1024) as size_k, a.card. You can determine how much of your table space is currently in use with the mon_get_tablespace table function.

On db2 for luw you can use this query. Perform the select below to know the size one table: Also lists whether table is column or row organized. You can determine how much of your table space is currently in use with the mon_get_tablespace table function. The database size is calculated as follows: Customer/consultant would like to find out how large each of their controller database tables (for example 'xdb18') are. Db2 select substr(a.tabname,1,30), (a.fpages*pagesize/1024) as size_k, a.card. Dbsize = sum (used_pages * page_size) for each table space (sms & dms). To list tables and their current sizes in descending order by size. You get one row per table data partition (1 row for a non range partitioned table).

PPT A First Look at Materialized Query Table (MQT) in DB2 LUW

How To Find Table Size In Db2 Luw Db2 select substr(a.tabname,1,30), (a.fpages*pagesize/1024) as size_k, a.card. On db2 for luw you can use this query. Customer/consultant would like to find out how large each of their controller database tables (for example 'xdb18') are. Also lists whether table is column or row organized. The database size is calculated as follows: You can determine how much of your table space is currently in use with the mon_get_tablespace table function. Dbsize = sum (used_pages * page_size) for each table space (sms & dms). To list tables and their current sizes in descending order by size. Perform the select below to know the size one table: Db2 select substr(a.tabname,1,30), (a.fpages*pagesize/1024) as size_k, a.card. You get one row per table data partition (1 row for a non range partitioned table). You can get the underlying table physical size from the sysibmadm.admintabinfo table. The admintabinfo administrative view returns size and state information for tables, materialized query tables (mqt) and hierarchy tables only.