ADALOD, LWP, LIP, SORT, TEMP

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
www.storrconsulting.com

AOS744 displays the following SORT size for LWP=800000000

15:32:43 ***** A D A B A S BASIC SERVICES ***** 2008-06-12
- SORT Storage - ADALOD LOAD - - PSPSS02

File Number … 165
Number of records ( Default: MAXISN ) … 30000119 (reduce number
if field is NU)
Average compressed descr. length (in Bytes)
of the biggest descriptor … 10
Occurences of periodic groups … 1
Occurences of multiple fields … 1
SORT device-type … 3390
LWP-parameter … 800000000
Database-ID … 134
Password (if required) …

Required number of blocks (minimum) … 2
Required number of cyls. (minimum) … 1