Work table processing classification | Variable name | Value | Processing method of HiRDB |
---|
Lock acquisition method when AND multiple indexes are used#1 | a | 0 | When the use of AND multiple indexes is selected as the access path, the following occurs: If any of the predicates (data) containing the columns for which the indexes to be used for search are defined satisfies the search condition, that data is locked in the shared mode (PR). Consequently, even if WITH EXCLUSIVE LOCK is specified as the lock option#2, a lock is applied in the shared mode (PR), and not in the exclusive mode (EX). |
1 | When the use of AND multiple indexes is selected as the access path, the following occurs: If any of the predicates (data) containing the columns for which the indexes to be used for search are defined satisfies the search condition, that data is locked in the specified mode. However, until the search for the first piece of data is completed, a predicate is logically computed for the column for which the index used for the search is defined, and the lock is released from any data that does not satisfy the search condition. |
Suppression of message output during automatic extension of the work table buffer#3 | b | 0 | During automatic extension of the work table buffer, the KFPH29008-I message is output. This message is output during the first automatic extension of the work table buffer of each server process. |
8 | During automatic extension of the work table buffer, the KFPH29008-I message is not output. |