SELECT * FROM SYSIBMADM.ADMINTABINFO
Example 3: Identify tables that are eligible to use large RIDs, but are not currently enabled to use large RIDs.
Example 4: Identify which tables are using type-1 indexes and require a reorganization to convert to type-2 indexes.
Example 5: Identify which tables have XML data in type-1 format and require an online table move to convert to type-2 format.
Example 4 (sic): Check the current type of statistics information collected for table T1
The ADMIN_GET_TAB_INFO_V97 table function returns the same information as the ADMINTABINFO administrative view, but allows you to specify a schema and table name.
Example 2: Suppose there exists a non-partitioned table (DBUSER1.EMPLOYEE), with all associated objects (for example, indexes and LOBs) stored in a single table space. Calculate how much physical space the table is using in the table space:
Calculate how much space would be required if the table were moved to another table space, where the new table space has the same page size and extent size as the original table space:
Example 3: Determine the total size for the compression dictionaries for the table DBUSER1.EMPLOYEE.
Example 4: Determine the amount of space reclaimable from a multidimensional clustering table SAMPLE.STAFF: