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 | local | [ table table-name | index index-name ] [...] ‘]
DBA authority required.
“sp_iqindexinfo procedure”, “sp_iqdbspace procedure”, and “sp_iqdbspaceinfo procedure”
Chapter 5, “Working with Database Objects” in the Sybase IQ System Administration Guide
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. If the database is a multiplex database, the default is main, the size of the shared IQ main store. The optional parameter local specifies only information about the local IQ store owned by the query server.
The information returned by sp_iqspaceinfo is helpful in managing dbspaces.
The following output is from the sp_iqspaceinfo stored procedure run on the asiqdemo database. Note that lines of output for some tables and indexes have been removed in this example.
Name NBlocks dbspace_name
contact 19 IQ_SYSTEM_MAIN sales_order_items.DBA.ASIQ_IDX_T205_C5_FP 56 IQ_SYSTEM_MAIN contact.DBA.ASIQ_IDX_T206_C10_FP 55 IQ_SYSTEM_MAIN contact.DBA.ASIQ_IDX_T206_C1_FP 61 IQ_SYSTEM_MAIN ... contact.DBA.ASIQ_IDX_T206_C9_FP 55 IQ_SYSTEM_MAIN contact.DBA.ASIQ_IDX_T206_I11_HG 19 IQ_SYSTEM_MAIN customer 20 IQ_SYSTEM_MAIN customer.DBA.ASIQ_IDX_T207_C1_FP 61 IQ_SYSTEM_MAIN customer.DBA.ASIQ_IDX_T207_C2_FP 55 IQ_SYSTEM_MAIN ... customer.DBA.ASIQ_IDX_T207_I10_HG 19 IQ_SYSTEM_MAIN ...
