What is the relation between LWP and SORT?
ADCMP and AOS display different recommendations.
ADACMP: TEMP 347 Cyls, SORT 830 Cyls, LWP 40,894,464
SYSAOS: TEMP 446 Cyls, SORT 1060 Cyls (min), no LWP values
I thought, when I increase LWP, the usage of SORT would decrease. But when I doubled LWP, also SORT usage doubled.
FIRST RUN:
ADALOD LOAD FILE=123,NAME=‘ADABAS-FILE1’
ADALOD ISNSIZE=4
ADALOD LWP=200000000
ADALOD LIP=200000000
ADALOD ISNREUSE=YES
ADALOD DSSIZE=6300000B
ADALOD UISIZE=2160B
ADALOD NISIZE=108000B,INDEXCOMPRESSION=YES
ADALOD MAXISN=30000000
ADALOD TEMPDEV=3390,TEMPSIZE=16605,SORTDEV=3390,SORTSIZE=19926
DDSORTR1 and DDSORTR2
19812641 Input Records Processed
33356 blocks used on TEMP-Dataset (2%)
210437 blocks used on SORT Part 1 (23%)
0 blocks used on SORT Part 2 (0%)
SECOND RUN:
ADALOD LOAD FILE=123,NAME=‘ADABAS-FILE1’
ADALOD ISNSIZE=4
ADALOD LWP=400000000
ADALOD LIP=200000000
ADALOD ISNREUSE=YES
ADALOD DSSIZE=6300000B
ADALOD UISIZE=2160B
ADALOD NISIZE=108000B,INDEXCOMPRESSION=YES
ADALOD MAXISN=30000000
ADALOD TEMPDEV=3390,TEMPSIZE=16605,SORTDEV=3390,SORTSIZE=19926
DDSORTR1 and DDSORTR2
19812641 Input Records Processed
33356 blocks used on TEMP-Dataset (2%)
420871 blocks used on SORT Part 1 (46%)
0 blocks used on SORT Part 2 (0%)
I also tried it with LWP=800,000,000 and received the message:
ERROR-110, SORT dataset too small
Supply a larger SORT dataset.
See the ADABAS Utilities Manual for instructions how
to calculate the SORT dataset size.
The utility manual pointed to AOS and AOS calculated 1060 Cyl (see above).
Any explanations for LWP and SORT?
The value for LIP was calculated by the formula
(length of ISN + length of RABN + 1) * number of ISNs
9 * 19,864,375 = 178,779,375 BYTES
LIP=200,000,000 and TEMP still has been used 2%
Thanks,
Dieter Storr