FILSZ


The File Size (FILSZ) keyword is valid with the Index Build (HIU) function.

FILSZ suppresses the use of SORTWORK. This keyword is available in PLUSIN; it is not available as a global option. The following table describes FILSZ keyword.

To do this

Specify this in PLUSIN

Build an index

INDEX

Estimated number of records.

Limit: between 1 and 4,294,967,295

NO

Internal default: INDEX

The following example shows the syntax for the FILSZ keyword:

FILSZ(INDEXDBD1,100,INDEXDBD2,200,......INDEXDBDXn,99999)

When you build indexes for a database, you can use the FILSZ keyword to specify an estimated number of records for each index file. The FILSZ keyword enables you to specify estimated record counts for as many as 32 indexes.

Error
Warning

If you enter an incorrect value for the FILSZ parameter, the Sort utility performance can be degraded. An incorrect value can also cause wasted DASD space or termination when work space is dynamically allocated. Therefore, it is important to update the record count value whenever the number of records to be sorted changes significantly.

For more information about sorting with the Index Build function, see Sort-considerations-Index-Build-function.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Online Reorg for IMS 5.1