Tables B-2 through B-17 show the lock modes for each of the utilities.
The utilities listed as follows are not described here, because they do not provide the automatic lock function (the database definition utility is the same as for a definition SQL; see the HiRDB Version 8 UAP Development Guide):
Table B-2 Lock modes for the database load utility
Execution environment | Resource | ||||||
---|---|---|---|---|---|---|---|
Table | Index | No-wait table | Resources management table | User LOB RDAREA | |||
RDAREA | Table ID | RDAREA | Index ID | ||||
Data load by table | SU | EX | SU | EX | EX2 | SR | SU |
PU2 | |||||||
Data load by RDAREA | EX | ![]() | SU | EX1 | ![]() | SR | EX |
Data load of LOB data only | SR | PR | ![]() | ![]() | ![]() | SR | EX |
1 In the case of index loading by RDAREA, lock is not placed on a non-partitioning key index.
2 During data deletion processing, the EX lock mode takes place. For other operations, if the option statement specifies nowait=no, the EX lock mode takes place; if it specifies nowait=yes, the PU lock mode takes place.
Table B-3 Lock modes for the database load utility (for shared tables)
Exe env | Resource | ||||||||
---|---|---|---|---|---|---|---|---|---|
Table | Index | No-wait table | RDAREA mgmt block | ||||||
Updatbl back-end server | Ref-only back-end server | Shared RDAREA for updatbl back-end server | Shared RDAREA for ref-only back-end server | IX ID | |||||
Shared RDAREA | Tbl ID | Shared RDAREA | Tbl ID | ||||||
Data load | EX | EX | EX | EX | EX | EX | EX | EX | SR |
Table B-4 Lock modes for the database structure modification utility
Exe env | Resource | |||||||
---|---|---|---|---|---|---|---|---|
DB structure mod utility | Data dict table | RDAREA status | RDAREA | Tbl | Res mgmt table | Inner replica config mgmt info | Replica group config mgmt info | |
RDAREA addition | EX | EX | EX4 | EX4 | ![]() | ![]() | ![]() | ![]() |
RDAREA expansion | EX | EX | EX4 | PU(EX)4 | ![]() | EX4 | ![]() | ![]() |
RDAREA reinit | EX | EX | EX4 | EX4 | EX | ![]() | ![]() | ![]() |
RDAREA deletion | EX | EX | EX4 | EX4 | ![]() | ![]() | EX4 | EX4 |
Modification of data dictionary table attribute definition | EX | EX | ![]() | EX2 | ![]() | ![]() | ![]() | ![]() |
Modification of RDAREA attribute | EX | EX | EX | EX | ![]() | ![]() | ![]() | ![]() |
Changing an RDAREA from a HiRDB/Single Server structure to a HiRDB/Parallel Server structure | EX | EX | EX | EX | ![]() | ![]() | ![]() | ![]() |
Changing to a back-end server structure1 | EX | EX | EX | EX | ![]() | ![]() | ![]() | ![]() |
Moving an RDAREA | EX | EX | EX4 | EX4 | ![]() | ![]() | ![]() | ![]() |
Registration of a generation of a HiRDB file system area | EX | EX | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
Deletion of a generation of a HiRDB file system area | EX | EX | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
Definition of an RDAREA replica | EX | EX | EX4 | EX4 | ![]() | ![]() | EX4 | EX4 |
Copying RDAREA configuration information | EX | EX | EX4 | EX4 | ![]() | ![]() | EX4 | EX4 |
Integration of RDAREAs | EX | EX | EX3,4 | EX3,4 | ![]() | ![]() | EX4 | EX4 |
Auditor registration | EX | EX | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
Creation of an audit trail table | EX | EX | ![]() | EX | ![]() | EX | ![]() | ![]() |
1 This applies only to a HiRDB/Parallel Server; it is not applicable to a HiRDB/Single Server.
2 Applies only to the data dictionary RDAREA.
3 Applicable to both original and replica RDAREAs.
4 Applicable to both updatable back-end servers and referencing-only back-end servers in the case of shared RDAREAs.
Table B-5 Lock modes for the database reorganization utility
Execution environment | Resource | ||||||||
---|---|---|---|---|---|---|---|---|---|
Table | Index | NW TBL | Res mgmt table | IX info file | User LOB RDAREA1 | ||||
RD AREA1 | TBL ID | RD AREA1 | IX ID | ||||||
Unloading by table (-k unld)) | unldenq=tblenq is specified in option statement | SR | PR | SR2 | ![]() | ![]() | SR | ![]() | SR |
unldenq=rdenq is specified in option statement | PR | SR | PR2 | ![]() | ![]() | SR | ![]() | PR | |
unldenq=nowait is specified in option statement | SR | ![]() | SR2 | ![]() | SR | SR | ![]() | SR | |
Unloading by RDAREA (-k unld) | unldenq=tblenq is specified in option statement | SR | PR | SR2 | ![]() | ![]() | SR | ![]() | SR |
unldenq=rdenq is specified in option statement | PR | SR | PR2 | ![]() | ![]() | SR | ![]() | PR | |
unldenq=nowait is specified in option statement | SR | ![]() | SR2 | ![]() | SR | SR | ![]() | SR | |
Reloading by table (-k reld) | SU | EX | SU | EX | EX | SR | ![]() | SU | |
Reloading by RDAREA (-k reld) | EX | ![]() | SU | EX4 | ![]() | SR | ![]() | EX | |
Reorganization by table (-k rorg) | SU | EX | SU | EX | EX | SR | ![]() | SU | |
Reorganization by RDAREA (-k rorg) | EX | SR | SU | EX4 | ![]() | SR | ![]() | EX | |
Batch creation of index (-k ixmk) | SR | SR | SU | EX | ![]() | SR | ![]() | ![]() | |
Re-creation of index (-k ixrc) | index statement specified5 | EX ![]() | ![]() ![]() | SU | EX | ![]() | SR | ![]() | EX ![]() ![]() |
SU ![]() | EX ![]() | EX ![]() ![]() | SU ![]() ![]() | ||||||
idxname statement specified | SU | EX | SU | EX | EX | SR | ![]() | ![]() | |
Reorganization of index (-k ixor)7 | SR | PR | SU | EX | ![]() | SR | ![]() | ![]() | |
EX | ![]() | ||||||||
Batch creation of plug-in index (-k ixmk) | SR | SR | SU | EX | ![]() | SR | EX | ![]() | |
Re-creation of plug-in index (-k ixrc) | index statement specified5 | EX ![]() | ![]() ![]() | SU | EX | ![]() | SR | EX | EX ![]() ![]() |
SU ![]() | EX ![]() | EX ![]() ![]() | SU ![]() ![]() | ||||||
idxname statement specified | SU | EX | SU | EX | EX | SR | ![]() | SU | |
Reloading of LOB data only (-k reld) | SR | PR | ![]() | ![]() | ![]() | SR | ![]() | EX | |
Reorganization of LOB data only (-k rorg) | SU | EX | SR4 | ![]() | EX | SR | ![]() | SU |
Table B-6 Lock modes for the database reorganization utility (for shared tables)
Exe env | Resource | |||||||||
---|---|---|---|---|---|---|---|---|---|---|
Table | Index | No-wait tbl | RD AREA mgmt block | IX info file | ||||||
Updatable backend server | Ref-only backend server | Shared RD AREA for updatbl backend server | Shared RD AREA for ref-only backend server | IX ID | ||||||
Shared RD AREA | Tbl ID | Shared RD AREA | Tbl ID | |||||||
Unload by table (-k unld) | SR | PR | ![]() | ![]() | SR1 | ![]() | ![]() | ![]() | SR | ![]() |
Reload by table (-k reld) | EX | EX | EX | EX | EX | EX | EX | EX | SR | ![]() |
Reorg by table (-k rorg) | EX | EX | EX | EX | EX | EX | EX | EX | SR | ![]() |
Batch index creation (-k ixmk) | SR | SR | ![]() | ![]() | EX | EX | EX | ![]() | SR | ![]() |
Re-crtn of index (-k ixrc, and index stmt specif)2 | EX ![]() | EX ![]() | EX | EX | EX | EX | EX | EX ![]() ![]() | SR | ![]() |
Re-crtn of index (-k ixrc, and idxname stmt specif) | EX | EX | EX | EX | EX | EX | EX | EX | SR | ![]() |
Index reorg (-k ixor) | SR | PR | ![]() | ![]() | EX | EX | EX | ![]() | SR | ![]() |
Table B-7 Lock modes for the rebalancing utility
Execution environment | Resource | |||||
---|---|---|---|---|---|---|
RDAREA | Table | No-wait table | Index | Rebalance* | Preprocessed table | |
Shared mode | SU | EX | EX | EX | EX | SR |
Exclusive mode | SU | EX | EX | EX | ![]() | SR |
* For the rebalancing resources, lock is placed at the single server or front-end server.
Table B-8 Lock modes for free page release utility
Exe env | Resource | |||||||||
---|---|---|---|---|---|---|---|---|---|---|
Table | No-wait table | Index | ||||||||
RD AREA | RD AREA mgmt block | Tbl ID | Free page rel util | RD AREA | RD AREA mgmt block | IX ID | Free page rel util | Wait for trxn compl | ||
Releasing free pages from table | SU | SR | SU | EX | SR | ![]() | ![]() | ![]() | ![]() | ![]() |
Releasing free segments from table | EX | SR | ![]() | EX | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
Releasing free pages from index | ![]() | ![]() | ![]() | ![]() | SR | SU | SR | EX | EX | PR |
Releasing free segments from index | ![]() | ![]() | SR | ![]() | ![]() | EX | SR | ![]() | EX | ![]() |
Table B-9 Lock modes for the free page release utility (for shared tables)
Exe env | Resource | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Table | Index | |||||||||||
Updatbl backend server | Ref-only backend server | RMB | Free page rel util | SR for UBS | SR for RBS | RMB | IX ID | Free page rel util | Wait for trxn compl | |||
SR | Tbl ID | SR | Tbl ID | |||||||||
Release free pages from table | EX | EX | EX | EX | SR | EX | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
Release free segmts from table | EX | EX | EX | EX | SR | EX | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
Release free pages from index | ![]() | SR | ![]() | ![]() | ![]() | ![]() | EX | EX | SR | EX | EX | PR |
Release free segmts from index | ![]() | SR | ![]() | ![]() | ![]() | ![]() | EX | EX | SR | ![]() | EX | ![]() |
Table B-10 Lock modes for the global buffer residence utility
Exe env | Resource | |||||
---|---|---|---|---|---|---|
Table | Index | |||||
RDAREA | RDAREA management block | No-wait table | RDAREA | RDAREA management block | Index ID | |
Reading data page (-k table) | SR | SR | SR | ![]() | ![]() | ![]() |
Reading index page (-k index) | ![]() | ![]() | SR | SR | SR | SR |
Table B-11 Lock modes for the global buffer residence utility (for shared tables)
Exe env | Resource | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Table | Index | |||||||||||
Updatable backend server | Referencing-only backend server | Updatable backend server | Referencing-only backend server | |||||||||
R | RMB | No-wait tbl | R | RMB | No-wait tbl | R | RMB | IX ID | R | RMB | IX ID | |
Reading data page (-k table) | SR | SR | SR | SR | SR | SR | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
Reading index page (-k index) | ![]() | ![]() | SR | ![]() | ![]() | SR | SR | SR | SR | SR | SR | SR |
Table B-12 Lock modes for the database condition analysis utility
Execution environment | Resource | |||||
---|---|---|---|---|---|---|
RDAREA | Resources management table | Table | No-wait table1 | |||
For table | For index | Specified RDAREA | ||||
Analysis by RDAREA | ![]() | ![]() | SR | SR | ![]() | SR |
Analysis by table | SR | ![]() | ![]() | SR | SR | SR |
Analysis by index | ![]() | SR | ![]() | SR | SR | SR |
Condition analysis result accumulation facility | SR | SR | SR | SR | SR | ![]() |
Facility for predicting reorganization time2 | SR | SR | SR | SR | SR | SR |
1 A no-wait table is locked only when the -d option is specified.
2 This lock is applicable when the -m option is specified.
Table B-13 Lock modes for the optimizing information collection utility
Execution environment | Resource | |||||||
---|---|---|---|---|---|---|---|---|
RDAREA | Resources management table | Table | No-wait table | Data dictionary table | ||||
For table | For index | For table | For index | Row | Key | |||
Acquisition of optimization information | SR | SR | SR | SR | SR/SU1 | SR | PR2/EX1 | PR2/EX1 |
Deletion of optimization information | ![]() | ![]() | ![]() | ![]() | SU1 | ![]() | PR2/EX1 | PR2/EX1 |
1 Lock is placed temporarily during data dictionary table retrieval.
2 Lock is placed during data dictionary table update processing.
Table B-14 Lock modes for the database copy utility
Execution environment | Resource | ||||
---|---|---|---|---|---|
Data dictionary table | RDAREA | Directory block 6 | Resources management table | ||
-M option | x | PR | PR | ![]() | ![]() |
r | PR | PR | ![]() | ![]() | |
s | ![]() | ![]() | PR | SR |
Table B-15 Lock modes for the database recovery utility
Execution environment | Resource | |
---|---|---|
Data dictionary table | RDAREA | |
Recovery of RDAREA | EX* | EX |
Table B-16 Lock modes for the registry facility initialization utility
Execution Environment | Resource | |||
---|---|---|---|---|
Database structure modification utility | Data dictionary table | RDAREA condition | RDAREA | |
Addition of registry RDAREAs, registry LOB RDAREAs, and registry management tables (-k all) | EX | EX | EX | EX |
Table B-17 Lock modes for the integrity check utility
Execution environment | Resource | |||||||||
---|---|---|---|---|---|---|---|---|---|---|
User table | Data dictionary table | |||||||||
RDAREA | TBL | NW TBL | Row | PP TBL | TBL | RDAREA | ||||
For TBL | For IX | For TBL | For IX | |||||||
Integrity checking (-k check) | When searching data dictionary table | ![]() | ![]() | ![]() | ![]() | PR | PR | SR | SR | SR |
When acquiring RDAREA check pending status* | SR | SR | PR | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | |
When performing integrity checking | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | |
When setting check pending status | SU | SU | EX | EX | EX | PR | SU | SU | SU | |
Forced setting of check pending status (-k set) or forced release of check pending status (-k release) | When searching data dictionary table | ![]() | ![]() | ![]() | ![]() | PR | PR | SR | SR | SR |
When acquiring RDAREA check pending status* | SR | SR | PR | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | |
When setting or releasing check pending status | SU | ![]() | EX | EX | EX | PR | SU | SU | SU |