The storagepool table

The storagepool table in sysadmin database contains information about all of the entries in the storage pool in an Informix® instance. Each entry represents free space that the server can use when automatically expanding a storage space.

Table 1. The storagepool table
Column Type Description
entry_id SERIAL The ID of the storage pool entry.
path VARCHAR (255) The path for the file, directory, or device that the server can use when additional storage space is required.
beg_offset BIGINT The initial offset in kilobytes into the device at which the server can begin allocating space.

If the storage pool information is for a directory, the end offset value is 0.

end_offset BIGINT The initial offset in kilobytes into the device at which the server must stop allocating space.

If the storage pool information is for a directory, the offset value is 0.

chunk_size BIGINT The initial size of a chunk allocated from this entry.
status VARCHAR (255) The status of the storage pool entry. Status values are:
  • Active = A functional storage pool entry. The server can allocate chunks from this entry.
  • Full = There is no more free space in the storage pool entry. The server cannot allocate any more chunks from this entry.
  • Error = The storage pool entry generated an error when the server tried to allocate a chunk from the entry.
priority INT The priority of the directory, file, or device when the server searches through the storage pool for space. The server allocates space from a high-priority entry before it allocates space from a lower priority entry.
  • 1 = High priority
  • 2 = Medium priority
  • 3 = Low priority
last_alloc DATETIME (year to second) The date and time of the last allocation from this entry.
logid INT The ID of the log that was current at the time this entry was last used. The server uses this flag with the logused value when choosing between entries of identical priorities.
logused INT The position within the log that was current at the time this entry was last used. The server uses this flag with the logid value when choosing between entries of identical priorities.

Copyright© 2019 HCL Technologies Limited