Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | [preprocessing]1 + number of RDAREAs for table to be retrieved + number of tables + number of rows with retrieval hit3 + number of RDAREAs storing the indexes used2 + number of index keys used in retrieval5 Add the following if an index-type plug-in is used for retrieval or if a data-type plug-in is defined in the columns to be referenced: + number of logical files used by the plug-in4 The following should be noted if table data is retrieved via a list:
Add the following if routines are used for retrieval: + number of routines used | |
HiRDB/Parallel Server | Front-end server and Dictionary server | [preprocessing]1 If table data is retrieved via a list, the number of lock requests in preprocessing in the formula should be determined by applying it to the base table of the list. Add the following if routines are used for retrieval: + number of routines used |
Back-end server | Number of RDAREAs for table to be retrieved + number of tables + number of rows with retrieval hit3 + number of RDAREAs storing the indexes used2 + number of indexes used in retrieval5 Add the following if an index-type plug-in is used for retrieval or if a data-type plug-in is defined in the columns to be referenced: + number of logical files used by the plug-in4 The following should be noted if table data is retrieved via a list:
Add the following if routines are used for retrieval: + number of routines used |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | [preprocessing]1 + number of RDAREAs to be retrieved + number of tables + 1 + number of RDAREAs for index used2 + number of index keys used in retrieval4 Add the following if an index-type plug-in is used for retrieval or if a data-type plug-in is defined in the columns to be referenced: + number of logical files used by the plug-in3 The following should be noted if table data is retrieved via a list:
Add the following if routines are used for retrieval: + number of routines used | |
HiRDB/Parallel Server | Front-end server and Dictionary server | [preprocessing]1 If table data is retrieved via a list, the number of lock requests in preprocessing in the formula should be determined by applying it to the base table of the list. Add the following if routines are used for retrieval: + number of routines used |
Back-end server | Number of RDAREAs to be retrieved + number of tables + 2 + number of RDAREAs for index used2 + number of index keys used in retrieval4 Add the following if an index-type plug-in is used for retrieval or if a data-type plug-in is defined in the columns to be referenced: + number of logical files used by the plug-in3 The following should be noted if table data is retrieved via a list:
Add the following if routines are used for retrieval: + number of routines used |
1 For the number of lock requests in preprocessing, see (25).
2 If indexes are defined for columns specified with AND or OR in a retrieval condition expression, those indexes will be used as a rule.
3 For the number of logical files used by plug-ins, refer to the manuals included with the plug-ins.
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | [preprocessing]1 + number of RDAREAs to be retrieved + number of tables + number of RDAREAs storing indexes used2 Add the following if an index-type plug-in is used for retrieval or if a data-type plug-in is defined in the columns to be referenced: + number of logical files used by the plug-in3 The following should be noted if table data is retrieved via a list:
Add the following if LOCK is specified for the pd_nowait_scan_option operand (add only for a non-FIX table): + 1 Add the following if routines are used for retrieval: + number of routines used | |
HiRDB/Parallel Server | Front-end server and Dictionary server | [preprocessing]1 If table data is retrieved via a list, the number of lock requests in preprocessing in the formula should be determined by applying it to the base table of the list. Add the following if routines are used for retrieval: + number of routines used |
Back-end server | Number of RDAREAs to be retrieved + number of tables + number of RDAREAs storing indexes used2 Add the following if an index-type plug-in is used for retrieval or if a data-type plug-in is defined in the columns to be referenced: + number of logical files used by the plug-in3 The following should be noted if table data is retrieved via a list:
Add the following if LOCK is specified for the pd_nowait_scan_option operand (add only for a non-FIX table): + 1 Add the following if routines are used for retrieval: + number of routines used |
1 For the number of lock requests in preprocessing, see (25).
2 If indexes are defined for columns specified with AND or OR in a retrieval condition expression, those indexes will be used as a rule.
3 For the number of logical files used by plug-ins, refer to the manuals included with the plug-ins.
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | [preprocessing]2 + number of RDAREAs to be retrieved + number of RDAREAs storing indexes used Add the following if an index-type plug-in is used for retrieval or if a data-type plug-in is defined in the columns to be referenced: + number of logical files used by the plug-in3 The following should be noted if table data is retrieved via a list:
Add the following if routines are used for retrieval: + number of routines used | |
HiRDB/Parallel Server | Front-end server and Dictionary server | [preprocessing]2 If table data is retrieved via a list, the number of lock requests in preprocessing in the formula should be determined by applying it to the base table of the list. Add the following if routines are used for retrieval: + number of routines used |
Back-end server | Number of RDAREAs to be retrieved + number of RDAREAs storing indexes used Add the following if an index-type plug-in is used for retrieval or if a data-type plug-in is defined in the columns to be referenced: + number of logical files used by the plug-in3 The following should be noted if table data is retrieved via a list:
Add the following if routines are used for retrieval: + number of routines used |
1 If LOCK TABLE IN SHARE MODE is specified for SELECT with FOR UPDATE specified, the same formula should be used as when LOCK TABLE in not specified.
2 For the number of lock requests in preprocessing, see (25).
3 For the number of logical files used by plug-ins, refer to the manuals included with the plug-ins.
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | [preprocessing]1 + 5 + number of RDAREAs to be inserted3 + number of inserted VARCHAR, NVARCHAR, or MVARCHAR columns that are 256 bytes or larger![]() ![]() Add the following if a data-type plug-in or index-type plug-in is defined: + number of logical files used by plug-ins2 Add the following if routines are used for insertion: + number of routines used | |
HiRDB/Parallel Server | Front-end server and Dictionary server | [preprocessing]1 Add the following if routines are used for insertion: + number of routines used |
Back-end server | 5 + number of RDAREAs to be inserted3 + number of inserted VARCHAR, NVARCHAR, or MVARCHAR columns that are 256 bytes or larger![]() ![]() Add the following if a data-type plug-in or index-type plug-in is defined: + number of logical files used by plug-ins2 Add the following if routines are used for insertion: + number of routines used |
1 For the number of lock requests in preprocessing, see (25).
2 For the number of logical files used by plug-ins, refer to the manuals included with the plug-ins.
3 Total number of RDAREAs for the target tables, indexes, LOB columns, and LOB attributes.
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | [preprocessing]2 + 1 + number of RDAREAs to be inserted4 Add the following if a data-type plug-in or index-type plug-in is defined: + number of logical files used by plug-in*3 Add the following if routines are used for insertion: + number of routines used | |
HiRDB/Parallel Server | Front-end server and Dictionary server | [preprocessing]2 Add the following if routines are used for insertion: + number of routines used |
Back-end server | 1 + number of RDAREAs to be inserted*4 Add the following if a data-type plug-in or index-type plug-in is defined: + number of logical files used by plug-ins*3 Add the following if routines are used for insertion: + number of routines used |
1 If LOCK TABLE IN SHARE MODE is specified, the same formula should be used as when LOCK TABLE in not specified.
2 For the number of lock requests in preprocessing, see (25).
3 For the number of logical files used by plug-ins, refer to the manuals included with the plug-ins.
4 Total number of RDAREAs for the target indexes, LOB columns, and LOB attributes.
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | [preprocessing]1 + 5 + number of RDAREAs to be inserted5 + 4 + number of inserted rows2 + number of inserted VARCHAR, NVARCHAR, or MVARCHAR columns that are 256 bytes or larger![]() ![]() ![]() ![]() ![]() Add the following if a data-type plug-in or index-type plug-in is defined: + number of logical files used by the plug-ins to be inserted4 + number of logical files used by the plug-ins used for retrieval4 Add the following if routines are used for insertion: + number of routines used | |
HiRDB/Parallel Server | Front-end server and Dictionary server | [preprocessing]1 Add the following if routines are used for insertion: + number of routines used |
Back-end server | 4 + number of RDAREAs to be inserted5 + number of inserted rows2 + number of inserted VARCHAR, NVARCHAR, or MVARCHAR columns that are 256 bytes or larger![]() ![]() ![]() ![]() ![]() Add the following if a data-type plug-in or index-type plug-in is defined: + number of logical files used by the plug-ins to be inserted4 + number of logical files used by the plug-ins used for retrieval4 Add the following if routines are used for insertion: + number of routines used |
Condition | Number of lock requests |
---|---|
HiRDB/Single Server | [preprocessing]1 + 5 + number of RDAREAs to be inserted2 + number of inserted VARCHAR, NVARCHAR, or MVARCHAR columns that are 256 bytes or larger![]() ![]() Add the following if a data-type plug-in or index-type plug-in is defined: + number of logical files used by plug-ins3 Add the following if routines are used for insertion: + number of routines used |
HiRDB/Parallel Server |
1 For the number of lock requests in preprocessing, see (25).
2 Total number of RDAREAs for the target tables, indexes, LOB columns, and LOB attributes.
3 For the number of logical files used by each plug-in, refer to the manual provided with the plug-in.
Condition | Number of lock requests |
---|---|
HiRDB/Single Server | [preprocessing]1 + 1 + number of RDAREAs to be inserted2 Add the following if a data-type plug-in or index-type plug-in is defined: + number of logical files used by plug-ins3 Add the following if routines are used for insertion: + number of routines used |
HiRDB/Parallel Server |
1 For the number of lock requests in preprocessing, see (25).
2 Total number of RDAREAs for the target indexes, LOB columns, and LOB attributes.
3 For the number of logical files used by each plug-in, refer to the manual provided with the plug-in.
Condition | Number of lock requests |
---|---|
HiRDB/Single Server | [preprocessing]1 + number of RDAREAs to be inserted2 + 4 + number of inserted rows3 + number of inserted VARCHAR, NVARCHAR, or MVARCHAR columns that are 256 bytes or larger![]() ![]() ![]() ![]() Add the following if a data-type plug-in or index-type plug-in is defined: + number of logical files used by the plug-ins to be inserted5 + number of logical files used by the plug-ins used for retrieval5 Add the following if routines are used for insertion: + number of routines used |
HiRDB/Parallel Server |
5 For the number of logical files used by each plug-in, refer to the manual provided with the plug-in.
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | [preprocessing]1 + number of RDAREAs to be updated5 + 4 + number of updated rows2 + number of pre-update VARCHAR, NVARCHAR, or MVARCHAR columns that are 256 bytes or larger![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Add the following if a data-type plug-in or index-type plug-in is defined for the columns to be updated: + number of logical files used by the plug-ins3 Add the following if LOCK is specified for the pd_nowait_scan_option operand (add only for a non-FIX table): + 1 Add the following if routines are used for updating: + number of routines used | |
HiRDB/Parallel Server | Front-end server and Dictionary server | [preprocessing]1 Add the following if routines are used for updating: + number of routines used |
Back-end server | number of RDAREAs to be updated5 + 4 + number of updated rows2 + number of pre-update VARCHAR, NVARCHAR, or MVARCHAR columns that are 256 bytes or larger![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Add the following if a data-type plug-in or index-type plug-in is defined for the columns to be updated: + number of logical files used by the plug-ins3 Add the following if LOCK is specified for the pd_nowait_scan_option operand (add only for a non-FIX table): + 1 Add the following if routines are used for updating: + number of routines used |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | [preprocessing]2 + number of RDAREAs to be updated5 + 1 + ![]() Add the following if a data-type plug-in or index-type plug-in is defined for the columns to be updated: + number of logical files used by the plug-ins3 Add the following if LOCK is specified for the pd_nowait_scan_option operand (add only for a non-FIX table): + 1 Add the following if routines are used for updating: + number of routines used | |
HiRDB/Parallel Server | Front-end server and Dictionary server | [preprocessing]2 Add the following if routines are used for updating: + number of routines used |
Back-end server | number of RDAREAs to be updated5 + 1 + ![]() Add the following if a data-type plug-in or index-type plug-in is defined for the columns to be updated: + number of logical files used by the plug-ins3 Add the following if LOCK is specified for the pd_nowait_scan_option operand (add only for a non-FIX table): + 1 Add the following if routines are used for updating: + number of routines used |
1 If LOCK TABLE IN SHARE MODE is used, use the same formula as that used when there is no LOCK TABLE.
2 For the number of lock requests in preprocessing, see (25).
3 For the number of logical files used by plug-ins, refer to the manuals included with the plug-ins.
4 Repeat and add this for the number of LOB columns and LOB attributes.
5 Total number of RDAREAs for the target indexes, LOB columns, and LOB attributes.
Condition | Number of lock requests |
---|---|
HiRDB/Single Server | [preprocessing]1 + number of RDAREAs to be updated2 + 4 + number of updated rows3 + number of pre-update VARCHAR, NVARCHAR, or MVARCHAR columns that are 256 bytes or larger![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Add the following if a data-type plug-in or index-type plug-in is defined for the columns to be updated: + number of logical files used by plug-ins5 Add the following if LOCK is specified for the pd_nowait_scan_option operand (add only for a non-FIX table): + 1 Add the following if routines are used for updating: + number of routines used |
HiRDB/Parallel Server |
5 For the number of logical files used by each plug-in, refer to the manual provided with the plug-in.
Condition | Number of lock requests |
---|---|
HiRDB/Single Server | [preprocessing]1 + number of RDAREAs to be updated2 + 1 + ![]() Add the following if a data-type plug-in or index-type plug-in is defined for the columns to be updated: + number of logical files used by plug-ins4 Add the following if LOCK is specified for the pd_nowait_scan_option operand (add only for a non-FIX table): + 1 Add the following if routines are used for updating: + number of routines used |
HiRDB/Parallel Server |
1 For the number of lock requests in preprocessing, see (25).
2 Total number of RDAREAs for the indexes, LOB columns, and LOB attributes.
3 Repeat and add this for the number of LOB columns and LOB attributes.
4 For the number of logical files used by each plug-in, refer to the manual provided with the plug-in.
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | [preprocessing]1 + number of RDAREAs to be deleted5 + 1 + number of deleted rows2 + number of VARCHAR, NVARCHAR, or MVARCHAR columns that are 256 bytes or larger![]() ![]() ![]() ![]() Add the following if a data-type plug-in or index-type plug-in is defined: + number of logical files used by the plug-ins3 Add the following if routines are used for deletion: + number of routines used | |
HiRDB/Parallel Server | Front-end server and Dictionary server | [preprocessing]1 Add the following if routines are used for deletion: + number of routines used |
Back-end server | number of RDAREAs to be deleted5 + 1 + number of deleted rows2 + number of VARCHAR, NVARCHAR, or MVARCHAR columns that are 256 bytes or larger![]() ![]() ![]() ![]() Add the following if a data-type plug-in or index-type plug-in is defined: + number of logical files used by the plug-ins3 Add the following if routines are used for deletion: + number of routines used |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | [preprocessing]2 + number of RDAREAs to be deleted5 + ![]() Add the following if a data-type plug-in or index-type plug-in is defined: + number of logical files used by the plug-ins3 Add the following if routines are used for deletion: + number of routines used | |
HiRDB/Parallel Server | Front-end server and Dictionary server | [preprocessing]2 Add the following if routines are used for deletion: + number of routines used |
Back-end server | number of RDAREAs to be deleted5 + ![]() Add the following if a data-type plug-in or index-type plug-in is defined: + number of logical files used by the plug-ins3 Add the following if routines are used for deletion: + number of routines used |
1 If LOCK TABLE IN SHARE MODE is specified, the same formula should be used as when LOCK TABLE in not specified.
2 For the number of lock requests in preprocessing, see (25).
3 For the number of logical files used by plug-ins, refer to the manuals included with the plug-ins.
4 Repeat and add this for the number of LOB columns and LOB attributes.
5 Total number of RDAREAs for the target indexes, LOB columns, and LOB attributes.
6 Number of pages from which all data is deleted.
Condition | Number of lock requests |
---|---|
HiRDB/Single Server | [preprocessing]1 + number of RDAREAs to be deleted2 + 1 + number of deleted rows3 + number of VARCHAR, NVARCHAR, or MVARCHAR columns that are 256 bytes or larger![]() ![]() ![]() Add the following if a data-type plug-in or index-type plug-in is defined: + number of logical files used by plug-ins5 Add the following if routines are used for deletion: + number of routines used |
HiRDB/Parallel Server |
5 For the number of logical files used by each plug-in, refer to the manual provided with the plug-in.
Condition | Number of lock requests |
---|---|
HiRDB/Single Server | [preprocessing]1 + number of RDAREAs to be deleted2 + ![]() Add the following if a data-type plug-in or index-type plug-in is defined: + number of logical files used by plug-ins5 Add the following if routines are used for deletion: + number of routines used |
HiRDB/Parallel Server |
1 For the number of lock requests in preprocessing, see (25).
2 Total number of RDAREAs for the target indexes, LOB columns, and LOB attributes.
3 Repeat and add this for the number of LOB columns and LOB attributes.
4 Number of pages from which all data is deleted.
5 For the number of logical files used by each plug-in, refer to the manual provided with the plug-in.
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | [preprocessing]1 + number of target RDAREAs3 + 3 + number of table segments being used + ![]() ![]() ![]() ![]() ![]() | |
HiRDB/Parallel Server | Front-end server and Dictionary server | [preprocessing]1 |
Back-end server | number of target RDAREAs3 + 3 + number of table segments + ![]() ![]() ![]() ![]() ![]() |
1 For the number of lock requests in preprocessing, see (25).
2 Repeat and add this for the number of indexes.
3 Total number of RDAREAs for the target tables, indexes, LOB columns, and LOB attributes.
4 Repeat and add this for the number of HiRDB files for LOB RDAREAs of LOB columns and LOB attributes.
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | number of base table SELECT lock requests1 + 7 + 2 Add the following value if an existing list is specified as the name of the list to be created: + number of RDAREAs for the base table of the list before re-creation + 3 + number of data segments of the list before re-creation | |
HiRDB/Parallel Server | Front-end server | [preprocessing]2 |
Dictionary server | preprocessing2 + 7 Add the following value if an existing list is specified as the name of the list to be created: + number of RDAREAs for the base table of the list before re-creation | |
Back-end server | number of base table SELECT lock requests1 + 2 Add the following value if an existing list is specified as the name of the list to be created: + 3 + number of data segments of the list before re-creation |
1 For the number of base table SELECT lock requests, choose from the SELECT statements in (1) through (4) the statement that satisfies the condition of the base table and refer to it.
2 For the number of lock requests in preprocessing, see (25).
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | [preprocessing]* + 7 + number of RDAREAs storing the base table of the list + 4 If an existing name is specified for the list to be created, add the following value: + number of RDAREAs storing the base table of the list before re-creation + 3 + number of segments using the list data before re-creation | |
HiRDB/Parallel Server | Front-end server | [preprocessing]* |
Dictionary server | [preprocessing]* + 7 If an existing name is specified for the list to be created, add the following value: + number of RDAREAs storing the base table of the list before re-creation | |
Back-end server | number of RDAREAs storing the base table of the list + 4 If an existing name is specified for the list to be created, add the following value: + 3 + number of segments using the list data before re-creation |
Condition | Number of lock requests |
---|---|
HiRDB/Single Server | 7 If an existing name is specified for the list to be created, add the following value: + number of RDAREAs storing the base table of the list before re-creation |
HiRDB/Parallel Server (Dictionary server) |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | 7 + number of RDAREAs storing the base table of the list + 3 + number of segments using the list data | |
HiRDB/Parallel Server | Dictionary server | 7 + number of RDAREAs storing the base table of the list |
Back-end server | 3 + number of segments using the list data |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | 1 + number of RDAREAs for lists + number of deleted lists ![]() | |
HiRDB/Parallel Server | Dictionary server | 1 |
Back-end server | Number of RDAREAs for lists + number of deleted lists ![]() |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | 1 + number of tables used + number of view tables used + ![]() ![]() ![]() ![]() ![]() ![]() Add the following if a user-defined type or function is used: + 1 Add the following (for each table) if optimization information is collected: + 1 + number of columns for which optimization information is created ![]() Add the following (for each view table) if view tables are used: + ![]() ![]() Add the following if LOB columns are defined: + number of LOB columns ![]() Add the following if user-defined type columns are defined: number of user-defined type columns + ![]() ![]() Add the following if LOB attributes are used: + number of LOB attributes ![]() Add the following if a higher-order type is used: + 2 Add the following for each function used if functions are used: + ![]() ![]() ![]() Add the following for each plug-in used if plug-ins are used: + ![]() ![]() ![]() Add the following if routines are used: + number of routines used | |
HiRDB/Parallel Server | Front-end server | 1 + number of tables used + number of view tables used Add the following if a user-defined type or function is used: + 1 Add the following if routines are used: + number of routines used |
Dictionary server | ![]() ![]() ![]() ![]() ![]() ![]() Add the following (for each table) if optimization information is collected: + 1 + number of columns for which optimization information is created ![]() Add the following (for each view table) if view tables are used: + ![]() ![]() Add the following if LOB columns are defined: + number of LOB columns ![]() Add the following for each user-defined type column if user-defined type columns are defined: + ![]() ![]() Add the following if LOB attributes are used: + number of LOB attributes ![]() Add the following if a higher-order type is used: + 2 Add the following for each function used if functions are used: + ![]() ![]() ![]() Add the following for each plug-in used if plug-ins are used: + ![]() ![]() ![]() Add the following if routines are used: + number of routines used |
1 Summarize this for each table.
2 Summarize this for each partitioning index inside the table.