Displays the size of the current database.
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
Returns the total size of the database. Also returns the number of pages required to hold the database in memory and the number of IQ pages when the database is compressed (on disk).
Column name |
Description |
|---|---|
Database |
The path name of the database file. |
Physical Blocks |
Total database size in blocks. An IQ database consists of one or more dbspaces. Each dbspace has a fixed size, which is originally specified in units of megabytes. This megabyte quantity is converted to blocks using the IQ page size and the corresponding block size for that IQ page size. The Physical Blocks column reflects the cumulative total of each Sybase IQ dbspace size, represented in blocks. |
KBytes |
The total size of the database in kilobytes. This value is the total size of the database in blocks (Physical Blocks in the previous sp_iqdbsize column) multiplied by the block size. The block size depends on the IQ page size. |
Pages |
The total number of IQ pages necessary to represent in memory all of the data stored in tables and join indexes, as well as the metadata for these objects. This value is always greater than or equal to the value of Compressed Pages (the next sp_iqdbsize column). |
Compressed Pages |
The total number of IQ pages necessary to store on disk the data in tables and join indexes as well as the metadata for these objects. This value is always less than or equal to the value of Pages (the previous sp_iqdbsize column), because Syabse IQ compresses pages when the IQ page is written from memory to disk. The sp_iqdbsize Compressed Pages column represents the number of compressed pages. |
NBlocks |
The total size in blocks used to store the data in tables and join indexes. This value is always less than or equal to the sp_iqdbsize Physical Blocks value. |
Catalog Blocks |
The total size in blocks used to store the metadata for tables and join indexes. |
You can use this procedure in a multiplex environment. See Using Sybase IQ Multiplex > Multiplex Reference > System Procedures > sp_iqdbsize Procedure.