sp_iqestdbspaces Procedure Example

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