![[Contents]](FIGURE/CONTENT.GIF)
Nonstop Database, HiRDB Version 9 Command Reference
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
Table B-2 Lock modes for the database load utility through Table B-17 Lock modes for the integrity check utility 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 9 UAP Development Guide):
Table B-2 Lock modes for the database load utility
| Execution env | Resource | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Table | Index | NW tbl | Rsrc mgmt tbl | User LOB RD-A | Sequence generator | |||||
| RD-A | Tbl ID | RD-A | IX ID | Seq generator ID | RD-A | |||||
| Number batch acqst'n method | Other acqst'n methods | |||||||||
| Data load by table | SU | EX | SU | EX | EX#2 | SR | SU | EX | SU | SU |
| PU#2 | ||||||||||
| Data load by RDAREA#3 | EX | SR | SU | EX#1 | -- | SR | EX | EX | SU | SU |
| Data load of LOB data only | SR | PR | -- | -- | -- | SR | EX | -- | -- | -- |
#1: For index loading by RDAREA, lock is not placed on a non-partitioning key index. Because lock is placed on a row-partitioned index in units of RDAREAs, data loading by RDAREA can be executed concurrently.
#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 | NW tbl | Rsrc mgmt tbl | Sequence generator | ||||||||
| Updatable BES | Ref-only BES | SR for upd BES | SR for ref BES | IX ID | Seq generator ID | RD-A | ||||||
| SR | Tbl ID | SR | Tbl ID | Nbr btch acq mthd | Othr acq mthd | |||||||
| Data load | EX | EX | EX | EX | EX | EX | EX | EX | SR | EX | SU | SU |
Table B-4 Lock modes for the database structure modification utility
| Exe env | Resource | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| DB struct mod utility | Data dict table | RD AREA status | RD AREA | Table | Res mgmt table | Inner replica config mgmt info | Rep group config mgmt info | Temp table entity mgmt | Temp table RD AREA mgmt info | Temp table RD AREA info | |
| RDAREA addition | EX | EX | EX#4 | EX#4 | -- | -- | -- | -- | EX#5 | EX#5 | EX#5 |
| RDAREA expansion | EX | EX | EX#4 | PU(EX)#4 | -- | EX#4 | -- | -- | -- | -- | -- |
| RDAREA reinit | EX | EX | EX#4 | EX#4 | EX | -- | -- | -- | EX#5 | EX#5 | EX#5 |
| RDAREA deletion | EX | EX | EX#4 | EX#4 | -- | -- | EX#4 | EX#4 | EX#5 | EX#5 | EX#5 |
| Modification of data dictionary table attribute definition | EX | EX | -- | EX#2 | -- | -- | -- | -- | -- | -- | -- |
| Modification of RDAREA attribute | EX | EX | EX | EX | -- | -- | -- | -- | -- | -- | -- |
| Changing an RDAREA from a HiRDB single server configuration to a HiRDB parallel server configuration | EX | EX | EX | EX | -- | -- | -- | -- | -- | -- | -- |
| Changing to a back-end server structure#1 | EX | EX | EX | EX | -- | -- | -- | -- | -- | -- | -- |
| Moving an RDAREA | EX | EX | EX#4 | EX#4 | -- | -- | -- | -- | -- | -- | -- |
| 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 | EX#4 | EX#4 | -- | -- | EX#4 | EX#4 | -- | -- | -- |
| Copying RDAREA configuration information | EX | EX | EX#4 | EX#4 | -- | -- | EX#4 | EX#4 | -- | -- | -- |
| Integration of RDAREAs | EX | EX | EX#3, #4 | EX#3, #4 | -- | -- | EX#4 | EX#4 | -- | -- | -- |
| Auditor registration | EX | EX | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Creation of an audit trail table | EX | EX | -- | EX | -- | EX | -- | -- | -- | -- | -- |
#1: This applies only to a HiRDB parallel server configuration, and is not applicable to a HiRDB single server configuration.
#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.
#5: Applicable to temporary table RDAREAs only.
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 RDAREA#1 | ||||
| RD AREA#1 | TBL ID | RD AREA#1 | IX ID | ||||||
| Unloading by table (-k unld)) |
unldenq=tblenq is specified in option statement | SR | PR | SR#2 | -- | -- | SR | -- | SR |
| unldenq=rdenq is specified in option statement | PR | SR | PR#2 | -- | -- | SR | -- | PR | |
| unldenq=nowait is specified in option statement | SR | -- | SR#2 | -- | SR | SR | -- | SR | |
| Unloading by RDAREA (-k unld) | unldenq=tblenq is specified in option statement | SR | PR | SR#2 | -- | -- | SR | -- | SR |
| unldenq=rdenq is specified in option statement | PR | SR | PR#2 | -- | -- | SR | -- | PR | |
| unldenq=nowait is specified in option statement | SR | -- | SR#2 | -- | SR | SR | -- | SR | |
| Reloading by table (-k reld) |
SU | EX | SU | EX | EX | SR | -- | SU | |
| Reloading by RDAREA (-k reld) | EX | SR | SU | EX#3 | -- | SR | -- | EX | |
| Reorganization by table (-k rorg) |
SU | EX | SU | EX | EX | SR | -- | SU | |
| Reorganization by RDAREA (-k rorg) |
EX | SR#7 | SU | EX#3 | -- | SR | -- | EX | |
| Batch creation of index (-k ixmk) |
SR | SR | SU | EX | -- | SR | -- | -- | |
| Re-creation of index (-k ixrc) |
index statement specified#4 | EX ![[Figure]](FIGURE/ZUENG213.GIF) SR#5 |
-- SR#5 |
SU | EX | -- | SR | -- | EX --#5 |
| SU SR#5 |
EX SR#5 |
EX --#5 |
SU --#5 |
||||||
| idxname statement specified | SU | EX | SU | EX | EX | SR | -- | -- | |
| Reorganization of index (-k ixor)#6 |
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 specified#4 | EX SR#5 |
-- SR#5 |
SU | EX | -- | SR | EX | EX --#5 |
| SU SR#5 |
EX SR#5 |
EX --#5 |
SU --#5 |
||||||
| 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 | SR#2 | -- | EX | SR | -- | SU | |
Table B-6 Lock modes for the database reorganization utility (for shared tables)
| Exe env | Resource | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Table | Index | NW tbl | Res mgmt table | IX info file | ||||||
| Updatable back-end server | Ref-only back-end server | Shared RD AREA for updatbl back-end server | Shared RD AREA for ref-only back-end server | IX ID | ||||||
| Shared RD AREA | Tbl ID | Shared RD AREA | Tbl ID | |||||||
| Unload by table (-k unld) |
SR | PR | -- | -- | SR#1 | -- | -- | -- | 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 SR |
EX SR |
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 | NW tbl | 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
| Execution environment | Resource | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Table | NW tbl | Index | |||||||||
| RD-A | Rsrc mgmt tbl | Tbl ID | rclm | trxn cmpl | RD-A | Rsrc mgmt tbl | IX ID | rclm | trxn cmpl | ||
| Releasing free pages from table | SU | SR | -- | EX | -- | SR | -- | -- | -- | -- | -- |
| Releasing free segments from table (-j) | EX | SR | -- | EX | -- | -- | -- | -- | -- | -- | -- |
| Releasing free pages and free segments from table (-a) | SU | SR | SR | EX | PR | SR | -- | -- | -- | -- | -- |
| Releasing free pages from index | -- | -- | -- | -- | -- | SR | SU | SR | EX | EX | PR |
| Releasing free segments from index (-j) | -- | -- | SR | -- | -- | -- | EX | SR | -- | EX | -- |
| Releasing free pages and free segments from index (-a) | -- | -- | SR | -- | -- | SR | SU | SR | EX | EX | PR |
Table B-9 Lock modes for the free page release utility (for shared tables)
| Exe env | Resource | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Table | Index | ||||||||||||
| Upd BES | Ref-only BES | Res mgm tbl | rcl | trxn cmp | SR for upd BES | SR for ref BES | Res mgm tbl | IX ID | rcl | trxn cmp | |||
| SR | Tbl ID | SR | Tbl ID | ||||||||||
| Releasing free pages from table | EX | EX | EX | EX | SR | EX | -- | -- | -- | -- | -- | -- | -- |
| Releasing free segments from table (-j) | EX | EX | EX | EX | SR | EX | -- | -- | -- | -- | -- | -- | -- |
| Releasing free pages and free segments from table (-a) | EX | EX | EX | EX | SR | EX | PR | -- | -- | -- | -- | -- | -- |
| Releasing free pages from index | -- | SR | -- | -- | -- | -- | -- | EX | EX | SR | EX | EX | PR |
| Releasing free segments from index (-j) | -- | SR | -- | -- | -- | -- | -- | EX | EX | SR | -- | EX | -- |
| Releasing free pages and free segments from index (-a) | -- | SR | -- | -- | -- | -- | -- | EX | EX | SR | EX | EX | PR |
Table B-10 Lock modes for the global buffer residence utility
| Exe env | Resource | |||||
|---|---|---|---|---|---|---|
| Table | Index | |||||
| RDAREA | Res mgm tbl | NW tbl | RDAREA | Res mgm tbl | 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 back-end server | Referencing-only back-end server | Updatable back-end server | Referencing-only back-end server | |||||||||
| R | Res mgm tbl | NW tbl | R | Res mgm tbl | NW tbl | R | Res mgm tbl | IX ID | R | Res mgm tbl | 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 | Res mgmt table | Table | Table (during NOWAIT search)#1 | HiRDB file | ||||
| For table | For index | Specified RDAREA | ||||||
| Analysis by RDAREA | Logical analysis | -- | -- | SR | SR | -- | SR | -- |
| Physical analysis | -- | -- | SR | SR | -- | -- | SR | |
| Analysis by table | SR | -- | -- | SR | SR | SR | -- | |
| Analysis by index | -- | SR | -- | SR | SR | SR | -- | |
| Facility for accumulating condition analysis results | SR | SR | SR | SR | SR | -- | -- | |
| Facility for predicting reorganization time#2 | SR | SR | SR | SR | SR | SR | -- | |
#1: Lock is placed on the table (during NOWAIT search) 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 | Table (during NOWAIT search) | Data dictionary table | ||||
| For table | For index | For table | For index | Row | Key | |||
| Acquisition of optimization information | SR | SR | SR | SR | SR/SU#1 | SR | PR#1/EX#2 | PR#1/EX#2 |
| Deletion of optimization information | -- | -- | -- | -- | SU#1 | -- | PR#1/EX#2 | PR#1/EX#2 |
| Registering optimization information | -- | -- | -- | -- | SU#1 | -- | PR#1/EX#2 | PR#1/EX#2 |
| Saving optimization information | -- | -- | -- | -- | SU#1 | -- | PR#1 | PR#1 |
#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#1 | Resources management table | In-memory synchronization | |||
| -M option | x | PR | PR | -- | -- | -- | |
| r | Other than in-memory RDAREA | PR | PR | -- | -- | -- | |
| In-memory RDAREA | PR | -- | -- | -- | PR | ||
| s | -- | -- | PR | SR#2 | -- | ||
#1: This is dictionary segment information or user directory segment information.
#2: Lock is obtained when RDAREA automatic extension is specified.
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 | ![[Figure]](FIGURE/ZUENG011.GIF) |
|
|
-- | -- | -- | -- | -- | -- | |
| 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 | |
Table B-18 Audit log output utility for JP1/NETM/Audit
| Execution environment | Resource | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Audit trail table (user table) | Data dictionary table | Inner replica configuration management information | ||||||||||
| RDAREA | TBL | Row | Row | PP TBL | TBL | RDAREA | ||||||
| For TBL | For IX | BLOB | For TBL | For IX | ||||||||
| -k i | When searching a data dictionary table | -- | -- | -- | -- | -- | PR#1 | PR#1 | SR#1 | SR#1 | SR#1 | -- |
| -k m | When searching a data dictionary table | -- | -- | -- | -- | -- | PR#1 | PR#1 | SR#1 | SR#1 | SR#1 | -- |
| -k r | When searching a data dictionary table | -- | -- | -- | -- | -- | PR#1 | PR#1 | SR#1 | SR#1 | SR#1 | -- |
| When searching an audit trail table | SR | SR#2 | -- | SR | PR | -- | -- | -- | -- | -- | -- | |
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.