PURPOSE: The equated command LEVEL approximates the optimum of key entries per node based on the number of records and number of levels. Use this value in the ENTRIES PER NODE clause when defining a DI. The default number of levels is set by internal logic.
Tuning tools are used to speed up data processing when using a DI with DB-MACH2 RDBMS. DI's are made up of nodes (section of the tree structure) and links (pointer to next node). The nodes contain an ID (bookkeeping information) and the Key information (value - address - delete indicator) for each record. When there are many records, the nodes are broken down into a number of levels.
Some optimization may need to be done with larger DS's. A balance is needed between the number of entries per node and the number of node levels. The more entries per node means fewer (but longer) reads. More levels with fewer entries per node means faster (but more) reads.
LEVEL
*LEVEL
Total number of records: n
Maximum number of levels: n
The number of key entries per node is approximately n.
NOTES: The range of levels that can be entered is 1-5. The number of levels is limited by the number of records specified. LEVEL will not allow more levels if the entries per node is 10 (as specified in the status message).
The "n" stands for an integer value that is either entered by the user or returned by the Equated Command.
SEE ALSO: RAM