| Parameter | Specify . . . | Minimum | Maximum | Default |
|---|---|---|---|---|
| LWKP2 | the number of Work blocks to use for intermediate ISN lists. | 0 | 16 777 215 | 0 |
This parameter specifies the size (in blocks) of the Adabas Work part 2, which holds intermediate ISN lists during Sx commands.
If LWKP2=0 (the default), Adabas calculates the Work part 2 size automatically using the following formula:
WORK2 = 22 + 2 * (4 * RECORDS / (BLKSIZE - 16))
where
| WORK2 | is the Work part 2 space requirement in blocks. |
| RECORDS | is the number of records in the file with the most records. This number equals TOPISN - MINISN + 1, where TOPISN is the highest ISN currently used in the file. MINISN is the lowest ISN used in the file. The MINISN value is specified with the ADACMP/ADALOD parameter MINISN; 1 is the default. You can use the ADAREP utility to display the TOPISN and MINISN values for the files in a database. |
| BLKSIZE | is the block size of the device where the Work dataset is stored (see the Adabas Installation documentation). |
If you choose not to use LWKP2=0, the minimum value is LWKP2=20 blocks.
Note:
An Adabas internal table requires one byte of storage for each Work
part 2 block.
For this Adabas session, the size of the Adabas Work part 2 is 50,000 blocks.
ADARUN PROG=ADANUC,LWKP2=50000
