sp_iqspaceinfo procedure

Function

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.

Syntax

sp_iqspaceinfo [‘main 
| [table table-name | index index-name] [...] ‘] 

Permissions

DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.

Description

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.

Example

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 
...

See also

“sp_iqindexinfo procedure”, “sp_iqdbspace procedure”, and “sp_iqdbspaceinfo procedure”

Chapter 5, “Working with Database Objects” in the System Administration Guide: Volume 1