To avoid difficulties when a database or a particular dbspace is full,
estimate dbspace requirements before you create the database and the objects in
it.
You can run SAP Sybase IQ stored
procedures to estimate how much space and how many dbspaces your
databases will require.
- Run sp_iqestspace to estimate the amount of
space you will need to create a database, based on the
number of rows in the underlying database tables. For each
table that you plan to create: sp_iqestspace
table_name, rows[, iqpagesize].
The amount of space needed by each table is returned as “RAW DATA index_size”.
- Run sp_iqestdbspaces to determine how many
dbspace files to create from the given space and what size
they should be. Use the total index sizes calculated in step
number 5 as the minsize
and maxsize
parameters:
sp_iqestdbspaces (dbsize [,iqpagesize]
[,minsize] [,maxsize] ...
All these calculations are estimates. Results vary based on the columns and
indexes you create for your database. See Reference: Building Blocks, Tables, and Procedures > System
Procedures for syntax and usage notes for each
procedure.