DB2 group summary <Group Name> [Table Name]
Description:
Lists the physical storage allocated to the tables in the group. If a specific table name is provided, only size information for that table is returned.
Example:
This command lists the number of bytes of storage allocated to the tables in the group and some other basic information.
Size Information for GRP25 (TSID 9) the DB2 Tablespace ID for this group
C - compressed. An asterisk (*) indicates that the table is compressed using IBM® DB2® UDB™ 9.x's compression
T - same Type classifications as above, but abbreviated N=NSF, I=NIF (index), U=User (DAV), and ?=Unknown
Name - the name of the DB2 table
Total - allocated bytes of storage
summary:
Container: C:\DB2\NODE0000\SQL00001\25.DB2GRP
Total disk space 4,447,535,104 bytes, actual used 4,444,946,432 bytes (99.9%)
The actual physical container file used by DB2.
The physical size of the container and the summary of the space in use by the tables in the group. The percent indicates the relative "fragmentation" of the physical file. If this number is low, disk space may be recovered by running Compact <NOTE.. need to doc specifics>
Related topics