Home | Previous Page | Next Page   Configuring and Monitoring Dynamic Server > Configuration Parameters >

TBLTBLFIRST

onconfig.std value
0
units
Kilobytes in multiples of page size
range of values
From the equivalent of 250 pages specified in kilobytes to the size of the first chunk minus the space needed for any system objects.
takes effect
When the database server is initialized

Specifies the first extent size of tblspace tblspace in the root dbspace. You might want to specify first and next extent sizes to reduce the number of tblspace tblspace extents and reduce the frequency of situations when you need to place the tblspace tblspace extents in non-primary chunks. (A primary chunk is the initial chunk in a dbspace.) For more information, see specifying first and next extent size in the chapter on managing dbspaces in the IBM Informix Administrator's Guide.

You can use oncheck -pt and oncheck -pT to show the first and next extent sizes of a tblspace tblspace. For more information about the oncheck utility, see Display Tblspaces for a Table or Fragment with -pt and -pT.

If you want to configure the first extent for a non-root dbspace, see information about the onspaces utility in Managing Storage Spaces with the onspaces Utility.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]