Reason:
This message only occurs during the backup phase when multiple subtasks are requested. One set (one or more) of occurrences of this message occurs for each different native sequence key ID within the area being reorganized or backed up in parallel. Each set provides information about each level of index searched in order to select the key ranges for the parallel backups. The lowest level of index is 1 and the highest varies, as required, by the amount of data. If the highest level provides enough entries to select the range values, it is the only one searched. If it does not, the next lower level is searched until level 1 is reached.
For example, assume you have an index with 3 levels. If level three contains 20 entries for this native sequence key ID, and if the number of tasks is 5, and if the cycle number is defaulted to 5, then this level does not provide the required 5 entries per task or 25 entries. Therefore level 2 of the index is searched for entries for this key ID. If it were to have, for example, 50 entries, it would be sufficient and be used to select the range values.
After dividing equally the number of index entries to the number of tasks, the remainder is assigned one by one to the first tasks. If not enough entries exist for all tasks, the first tasks each receive one entry and the ending tasks get none. In this case they must still execute and build an empty output data set.
The number of ENTRIES in the message may range from 0 to 99,999. If larger than 99,999, the number is reported as 99,999+.
Index level 1 blocks point to low level index blocks (DXX) and may have zero entries for a key ID. Level 2 or higher blocks may or may not have an entry but are always considered to have one entry that points to the next lower level block that may have an entry. Therefore, a 4-level index for a large table might have no records for a small table, but at level 4 one entry exists for the small table, the same for levels 3 and 2. At level 1 it is shown as zero entries.
Action:
None. This message is for information only.
|
Copyright © 2014 CA.
All rights reserved.
|
|