Home The Company Publications Products Links Tips Jobs

Last update: 25 July 2005

ADARUN Parameters

By Dieter Storr - Efficient Database Usage of ADABAS

ISBN 3-528-15289-3

Click on the parameter to get more info
ADARUN
Parm
Description Parm
Influence
RC SC Effect, etc.
ASYTVS Asynchronous Buffer Flush
YES = asynchronously (default)
NO = not asynchronously
ASYTVS=YES in connection with FMXIO>1 (number of parallel I/O operations) by LFIOP flush processing reduces the time for a buffer flush

Important for performance!
LBP
LP
TFLUSH
LFIOP
FMXIO
FIC
-- -- Number and duration of a buffer flush
FMXIO Parallel LFIOP I/O Operations
The maximum number of parallel I/O operations by LFIOP flush processing
Values 1 - 16

Important for performance!
LBP
LP
TFLUSH
ASYTVS
FIC
-- -- Fewer and faster buffer flushes, more I/Os per disk
LBP Length of Buffer Pool
Used to store ASSO and DATA blocks for processing.
In 31-bit mode (EXCPVR), the buffer pool is automatically allocated above the 16-megabyte line
64-bit mode is also possible: "EXCPVR is being used for this run in ESA64 mode"

Most important for performance!
LP
TFLUSH
LFIOP
87
97
160
161
162
163
170
-- low values = poor buffer efficiency, more physical ASSO and DATA I/Os, more buffer flushes
high values = increased paging
Parm error 12
Parm error 71
LCP Lenght of Security Pool
Security pool for ADASEC

Important for performance!
LP
--
204 -- Access to security file
LDEUQP Length of Unique Descriptor Pool
The unique descriptor (UQ) pool (value + 11 bytes) should hold all UQ descriptors that are being changed by all transactions
Checks whether UQ DE value exist
-- 197
198
-- --
LDTP Length of Distributed Transaction Processing Area (Work part 4)
For use with DTP=RM (resource manager)
DTP=RM
LP
17 4 --
LFIOP Asynchronous Buffer Pool Control
Asynchronous buffer flush I/O pool for
Keep it small, approx. 25-40% of LBP
0=synchronous BF
1=25% of LBP
n=user defined
In 31-bit mode (EXCPVR), the work pool is automatically allocated above the 16-megabyte line
64-bit mode is also possible: "EXCPVR is being used for this run in ESA64 mode"

Important for performance!
LBP
LP
TFLUSH
FIC
8 -- high values = wait time, high channel and disk load
LFP Length of Internal Format Buffer Pool
In 31-bit mode (EXCPVR), the format pool is automatically allocated above the 16-megabyte line
64-bit mode is also possible: "EXCPVR is being used for this run in ESA64 mode"
Since ADA7, HWM are always close to 100%
Still sequential searching

Important for performance!
-- 42
45
--
--
low values = format overwrites
Parm error 13
LI Length of Tables of ISNs (TBI)
Store ISN lists (overflow ISNs or saved ISN lists), which are identified by a CID and system UID
LI=(# TBI-elements, limited by NQCID) * (size TBI element)
Max size see NSISN

Important for performance!
NSISN
NQCID
71 -- Parm error 10
LOCAL Local Nucleus
YES=Isolated
NO=Calls from Entire Net-Work nodes are available
-- -- -- Parm error 74
LOGGING Command Logging Control
Command logging for the Adabas session. UEX4 needs LOGGING=YES
CL
DUALCLD
DUALCLS
LOGCB
LOGCLEX
LOGFB
LOGIB
LOGIO
LOGRB
LOGSB
LOGUX
LOGVB
LOGSIZE
UEX4
-- -- Active logging (dual or single) can cause performance problems. I/Os are not done by a subtask
LOGSIZE Maximum Command Logging Size
The maximum blocksize for the sequential command log
Default value of QBLKSIZE
LOGGING
QBLKSIZE
-- -- Active sequential logging causes performance problems. I/Os are not done by a subtask. Tape mount or full disk will lock the nucleus.
LP Length of Data Protection Area (Work Part 1)
Specifies the number of blocks to allocate to the Work data protecxtion area (part 1 of 4).
Changes of LP will be automatically detected during autorestart

Important for performance!
LBP
TFLUSH
LFIOP
TT
LWKP2
WORK-3
WORK-4
FIC
9
95
8
15
--
--
low values = high number of buffer flushes
high values = probably not used
Parm errors 17, 18
LQ Length of Sequential Command Table
Specifies the number of bytes for the TBQ elements for read sequences:
physical = 56 bytes
logical = 86 bytes + length compr. DE value
max. length 68 + 253 = 331 bytes x possible CIDs
ADA74: TBQ element = approx. 120 bytes (?)
NQCID 70 -- Parm error 11
LWP Work Pool, contains of:
- Sort area
- Intermediate UB
- DVT (32KB)
- Temp. transl. int.
   formats (32KB)
- I/O areas, WORK2/3
- LOGIO of CLOG
In 31-bit mode (EXCPVR), the work pool is automatically allocated above the 16-megabyte line
64-bit mode is also possible: "EXCPVR is being used for this run in ESA64 mode"

Important for performance!
 
LS
LU
--
--
--
--
LOGIO
LOGGING
PREFE
164
1
152
--
--
45
--
88
--
3
--
--
--
--
--
1
low values = throw backs, WORK2 I/Os, no selection of CQ, ENQ time, ECBs
Parm errors 14, 16, 39, 67

Top Page

Back to ADABAS Tips, Tricks, Techniques -- Overview