|
Some customers told me that ADAORD's restructure file (REF) and store (STORE) is up to 10 times faster than reorder file (REORFILE). When SAG combined REF and STORE in one function REORFILE, at least one step should run a little faster than two steps.
ADABAS Support told one customer to use the ADARUN parameters LBP, LWP, and LS to improve runtime of ADAORD (request #589018). This would make sense to me if running in single-user-mode but not in MODE=MULTI.
Jim Poole did some tests but couldn't find a runtime difference by using the above mentioned ADARUN parameters. Wayne Campus also couldn't detect an increase in virtual storage with MAINVIEW, when using 400MB for LBP, 25MB for LWP, and 12MB for LS.
As you also can see from the following test matrix (decision table), I received differences in CPU time, duration, and EXCPs (I/Os). At least the CPU time should be the same. I will do more tests.
An ADAORD specialist from SAG Darmstadt confirmed that the paramters LBP, LWP, and LS will be ignored by the ADAORD utility. They are for the ADABAS nucleus only.
I only could reduce my runtime for ADAORD significantly by not using the SORTSEQ=ISN parameter (from 4:46 to 4:21).
| Type of Test / Control Statements |
Test 1 |
Test 2 |
Test 3 |
Test 4 |
Test 5 |
Restore original file 138 before ADAORD
ADARUN DBID=001,SVC=254
ADARUN DEVICE=9990,LP=65535
ADARUN PROGRAM=ADASAV,TNAX=18000
ADASAV RESTORE BUFNO=2
ADASAV FMOVE=138,OVERWRITE
|
--
|
YES
|
YES
|
YES
|
YES
|
ADARUN DBID=001,SVC=254
ADARUN DEVICE=9990,LP=65535
ADARUN PROGRAM=ADAORD
ADARUN MODE=MULTI
ADARUN IGNDIB=NO
|
YES
|
YES
|
YES
|
YES
|
YES
|
ADARUN LBP=16777215
|
--
|
YES
|
--
|
YES
|
--
|
ADARUN LBP=100000000
|
--
|
--
|
--
|
--
|
YES
|
ADARUN LWP=4000000
ADARUN LS=3950000
|
--
|
YES
|
--
|
YES
|
YES
|
ADAORD REORFILE FILE=138 SORTSEQ=ISN
ADAORD ISNSIZE=4,MAXISN=20000000
ADAORD ASSOPFAC=1,DATAPFAC=1
ADAORD INDEXCOMPRESSION=YES,LIP=210000K
|
YES
|
YES
|
--
|
--
|
YES
|
STEP 1 Restructure File (REF):
ADAORD REFADAORD FILE=138 *SORTSEQ=ISN
ADAORD ASSOPFAC=1,DATAPFAC=1
ADAORD INDEXCOMPRESSION=YES,LIP=210000K
ADAORD ISNSIZE=4
|
--
|
--
|
YES
|
YES
|
--
|
STEP2 Store File:
ADAORD STORE FILE=138,OVERWRITE
ADAORD ISNSIZE=4,MAXISN=20000000
ADAORD ASSOPFAC=1,DATAPFAC=1
ADAORD INDEXCOMPRESSION=YES,LIP=210000K
|
--
|
--
|
YES
|
YES
|
--
|
|
Results from the ADAORD step
|
R 1
|
R 2
|
R 3
|
R 4
|
R 5
|
| Restore time |
-- |
12:45:06-12:45:17 |
17:01:46-17:01:55 |
10:45:03-10:45:10 |
16.05.45-16.09.08 |
| CPU time in seconds for REORFILE |
16.93 |
16.25 |
-- |
-- |
17.09 |
| CPU time in seconds for REF |
-- |
-- |
7.92 |
7.57 |
-- |
| CPU time in seconds for STORE |
-- |
-- |
9.66 |
8.75 |
-- |
| CPU time in seconds for REF and STORE |
-- |
-- |
17.58 |
16.32 |
-- |
| Duration in minutes : seconds for REORFILE |
3:10 |
1:36 |
-- |
-- |
2:27 |
| Duration in minutes : seconds for REF and STORE |
-- |
-- |
5:08 |
1:36 |
-- |
| Number of EXCPs (I/Os) for REORFILE |
24,350 |
24,345 |
-- |
-- |
24,349 |
| Number of EXCPs (I/Os) for REF and STORE |
-- |
-- |
24,603 |
24,585 |
-- |
 Top Page
|
ADABAS Tips, Tricks, Techniques -- Overview