Displays the number of blocks used by each object in the current database and the name of the dbspace in which the object is located.
sp_iqspaceinfo [‘main | [table table-name | index index-name] [...] ‘]
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
For the current database, displays the object name, number of blocks used by each object, and the name of the dbspace. sp_iqspaceinfo requires no parameters.
The information returned by sp_iqspaceinfo is helpful in managing dbspaces.
The following output is from the sp_iqspaceinfo stored procedure run on the iqdemo database. Output for some tables and indexes have been removed in this example.
Name NBlocks dbspace_name
Contacts 19 IQ_SYSTEM_MAIN SalesOrderItems.DBA.ASIQ_IDX_T205_C5_FP 56 IQ_SYSTEM_MAIN Contacts.DBA.ASIQ_IDX_T206_C10_FP 55 IQ_SYSTEM_MAIN Contacts.DBA.ASIQ_IDX_T206_C1_FP 61 IQ_SYSTEM_MAIN ... Contacts.DBA.ASIQ_IDX_T206_C9_FP 55 IQ_SYSTEM_MAIN Contacts.DBA.ASIQ_IDX_T206_I11_HG 19 IQ_SYSTEM_MAIN Customers 20 IQ_SYSTEM_MAIN Customers.DBA.ASIQ_IDX_T207_C1_FP 61 IQ_SYSTEM_MAIN Customers.DBA.ASIQ_IDX_T207_C2_FP 55 IQ_SYSTEM_MAIN ... Customers.DBA.ASIQ_IDX_T207_I10_HG 19 IQ_SYSTEM_MAIN ...
“sp_iqindexinfo procedure”, “sp_iqdbspace procedure”, and “sp_iqdbspaceinfo procedure”
Chapter 5, “Working with Database Objects” in the System Administration Guide: Volume 1
