Size sbspace metadata

The first chunk of an sbspace must have a metadata area. It is important to size the metadata area for an sbspace correctly to ensure that the sbspace does not run out of metadata space.

When you add smart large objects and chunks to the sbspace, the metadata area grows. In addition, the database server reserves 40 percent of the user area to be used in case the metadata area runs out of space.

To ensure that this does not happen, you can either:
  • Let the database server calculate the size of the metadata area for the new sbspace chunk.
  • Specify the size of the metadata area explicitly.

For instructions on estimating the size of the sbspace and metadata area, see table performance considerations in the HCL Informix® Performance Guide. Also see Monitoring the metadata and user-data areas.

Copyright© 2018 HCL Technologies Limited