# ADALOD, LWP, LIP, SORT, TEMP **URL:** \ **Category:** Forum\ **Tags:** Adabas-Natural, Adabas, Adabas-on-Mainframes, Adabas-Utilities-on-Mainframes\ **Created:** [June 11, 2008, 11:03pm UTC](https://techcommunity.softwareag.com/t/adalod-lwp-lip-sort-temp/78288 "2008-06-11T23:03:28Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Dieter\_W\_Storr](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/dieter_w_storr/32/91_2.png) [@Dieter\_W\_Storr](https://techcommunity.softwareag.com/u/Dieter_W_Storr)\ **Post date:** [June 11, 2008, 11:03pm UTC](https://techcommunity.softwareag.com/t/adalod-lwp-lip-sort-temp/78288/1 "2008-06-11T23:03:28Z")
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 > **[Storr Consulting, Inc. - Index](http://www.storrconsulting.com)** > > Mainframe and PC Solutions, Software and Hardware, > Concepts, Design, Performance Analysis, Data Modelling, > Teaching English and Art ---
**Author:** ![Dieter\_W\_Storr](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/dieter_w_storr/32/91_2.png) [@Dieter\_W\_Storr](https://techcommunity.softwareag.com/u/Dieter_W_Storr)\ **Post date:** [June 13, 2008, 3:57am UTC](https://techcommunity.softwareag.com/t/adalod-lwp-lip-sort-temp/78288/2 "2008-06-13T03:57:05Z")
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 ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [April 2, 2021, 2:50pm UTC](https://techcommunity.softwareag.com/t/adalod-lwp-lip-sort-temp/78288/3 "2021-04-02T14:50:29Z")