Use the example as a reference for sp_iqestdbspaces usage.
sp_iqestdbspaces 12000000000, 65536, 500000000, 2146304000
dbspace files |
Type |
Size |
Msg |
|---|---|---|---|
1 |
min |
2146304000 |
|
2 |
min |
2146304000 |
|
3 |
min |
507392000 |
|
4 |
avg |
2146304000 |
|
5 |
max |
2053697536 |
|
6 |
spare |
1200001024 |
This example estimates the size and number of dbspace segments needed for a 12GB database. SAP Sybase IQ recommends that you create a minimum of 3 segments (listed as min) for the best compression, if you expect little uniqueness in the data. If the data has an average amount of variation, 1 more segment (listed as avg) should be created. Data with a lot of variation (many unique values, requiring extensive indexing), may require 1 more segment (listed as max). You can ensure that your initial load succeeds by creating a spare segment of 1200001024 bytes. Once you have loaded the database, you can delete any unused dbspace segments.