ADD IB() command for the Build Index function of FPA

Syntax for ADD IB() command for the Build Index function of FPA

The basic format of the ADD command is described in Parameters for ADD command. Shown here is the syntax for those parameters that are associated with the Build Index function of FPA.

Parameter reference for ADD IB() command for the Build Index function of FPA

The use of the IB() keyword on the ADD command indicates that indexes associated with recovered database data sets are to be rebuilt after the DBDS is recovered for OUTPUT(PRO) only. The IB statement is ignored for OUTPUT(DUP).

The following reference shows the options for the Build Index function of FPA that can be specified on the IB() keyword within the ADD command.

BLD_FP_PGROUP(secidxdbname)

secidxdbname

Use this parameter to identify the first index in a logical partition group of indexes, and to indicate that all indexes in the partition group are to be built.

BLD_SECONDARY(ALL | secixdbname1,secixdbname2,secixdbname3...)

Use this parameter to rebuild the secondary index databases of the dbname/areaname specified on the ADD DB() command.

Important: When BLD_SECONDARY(ALL) is specified, all secondary indexes are rebuilt. It is not necessary to specify BLD_SECONDARY(secixdbname1,secixdbname2,secixdbname3).

Note: Only BLD_SECONDARY(ALL) is supported when this parameter is specified on the UTILGBL() environmental statement.

ICHECK(NODEFER | DEFER)

Use this parameter to control the input devices.

NODEFER

Gets access to all devices that are associated with the input data sets at a time.

DEFER

Access to devices for obtaining input data sets are limited to the number that is specified by the ITASKCTL keyword.

ICINCOMP (No | Yes)

Use this parameter to specify, when an image copy is used as an input data set, whether the image copy records are to be compressed by using the CSRCESRV MVS macro when they are stored into a data space storage.

IMS Fast Path Advanced Tool IMS Fast Path Advanced Tool stores all image copy records into a data space storage when an image copy is used as an input data set. Because the maximum size of one data space is 2 GB, if the total size of the records exceeds the limit, IMS Fast Path Advanced Tool ends with an error.

Try to reduce the total size of the records to under 2 GB by specifying ICINCOMP=YES. FPA compresses the image copy records by using the CSRCESRV macro before storing them into a data space and expands them when they are processed.

The data compression and expansion process increases the amount of CPU time.

No

The image copy records are stored into a data space storage without compression.

Yes

The image copy records are stored into a data space storage after compression.

ICNDX(NO | YES)

This parameter specifies that indexes are to be image copied.

This parameter does not apply to HALDB primary index and ILE data sets because they are not recoverable.

This parameter also does not apply to secondary indexes that are not recoverable.

However, if you specify ICNDX(YES), secondary indexes for Full Function, Fast Path and HALDB databases are image copied. For Full Function databases, recoverable primary indexes are image copied.

NO is the default.

Note: If ICNDX(YES) is coded, it does not take effect unless the IC() keyword is present on the ADD command.

ITASKCTL(AREA | nnnn)

Use this parameter to specify the maximum number of input areas to be processed concurrently.

AREA

The number of input areas.

nnnn

Specify a value from 1 to 2048. Specify a value less than or equal to the number of input areas.

If you specify a value that is greater than the number of input areas, it is replaced by the number of input areas.

In case of the CHANGE command in the REORG mode, the following value is set: (ITASKCTL + OTASKCTL)/2 (the value is rounded off)

OTASKCTL(nnnn)

Use this parameter to specify the maximum number of output areas to be processed concurrently.

nnnn

Specify a value from 1 to 2048. Specify a value less than or equal to the number of output areas.

If you specify a value that is greater than the number of output areas, it is replaced by the number of output areas.

In case of the CHANGE command in the REORG mode, the following value is set: (ITASKCTL + OTASKCTL)/2 (the value is rounded off)