Appendix B.2 Lock mode for utilities

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):

Note
When data loading is executed on a LOB column structure base table only, the lock mode is the same as for data loading by table when loading data by table or the same as for data loading by RDAREA when loading data by RDAREA.

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 envResource
TableIndexNo-wait tableRDAREA mgmt block
Updatbl back-end serverRef-only back-end serverShared RDAREA for updatbl back-end serverShared RDAREA for ref-only back-end serverIX ID
Shared RDAREATbl IDShared RDAREATbl ID
Data loadEXEXEXEXEXEXEXEXSR
Legend:
env: environment
Exe: Execution
IX: Index
load: loading
mgmt: management
Ref: Referencing
Tbl: Table
updatbl: updatable

Table B-4 Lock modes for the database structure modification utility

Exe envResource
DB structure mod utilityData dict tableRDAREA statusRDAREATblRes mgmt tableInner replica config mgmt infoReplica group config mgmt info
RDAREA additionEXEXEX4EX4[Figure][Figure][Figure][Figure]
RDAREA expansionEXEXEX4PU(EX)4[Figure]EX4[Figure][Figure]
RDAREA reinitEXEXEX4EX4EX[Figure][Figure][Figure]
RDAREA deletionEXEXEX4EX4[Figure][Figure]EX4EX4
Modification of data dictionary table attribute definitionEXEX[Figure]EX2[Figure][Figure][Figure][Figure]
Modification of RDAREA attributeEXEXEXEX[Figure][Figure][Figure][Figure]
Changing an RDAREA from a HiRDB/Single Server structure to a HiRDB/Parallel Server structureEXEXEXEX[Figure][Figure][Figure][Figure]
Changing to a back-end server structure1EXEXEXEX[Figure][Figure][Figure][Figure]
Moving an RDAREAEXEXEX4EX4[Figure][Figure][Figure][Figure]
Registration of a generation of a HiRDB file system areaEXEX[Figure][Figure][Figure][Figure][Figure][Figure]
Deletion of a generation of a HiRDB file system areaEXEX[Figure][Figure][Figure][Figure][Figure][Figure]
Definition of an RDAREA replicaEXEXEX4EX4[Figure][Figure]EX4EX4
Copying RDAREA configuration informationEXEXEX4EX4[Figure][Figure]EX4EX4
Integration of RDAREAsEXEXEX3,4EX3,4[Figure][Figure]EX4EX4
Auditor registrationEXEX[Figure][Figure][Figure][Figure][Figure][Figure]
Creation of an audit trail tableEXEX[Figure]EX[Figure]EX[Figure][Figure]
Legend:
config: configuration
DB: Database
Data dict table: Data dictionary table
Exe: Execution
info: information
mgmt: management
mod: modification
reinit: reinitialization
Res: Resources
Tbl: Table

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 environmentResource
TableIndexNW TBLRes mgmt tableIX info fileUser LOB RDAREA1
RD AREA1TBL IDRD AREA1IX ID
Unloading by table
(-k unld))
unldenq=tblenq is specified in option statementSRPRSR2[Figure][Figure]SR[Figure]SR
unldenq=rdenq is specified in option statementPRSRPR2[Figure][Figure]SR[Figure]PR
unldenq=nowait is specified in option statementSR[Figure]SR2[Figure]SRSR[Figure]SR
Unloading by RDAREA (-k unld)unldenq=tblenq is specified in option statementSRPRSR2[Figure][Figure]SR[Figure]SR
unldenq=rdenq is specified in option statementPRSRPR2[Figure][Figure]SR[Figure]PR
unldenq=nowait is specified in option statementSR[Figure]SR2[Figure]SRSR[Figure]SR
Reloading by table
(-k reld)
SUEXSUEXEXSR[Figure]SU
Reloading by RDAREA (-k reld)EX[Figure]3SUEX4[Figure]SR[Figure]EX
Reorganization by table
(-k rorg)
SUEXSUEXEXSR[Figure]SU
Reorganization by RDAREA
(-k rorg)
EXSRSUEX4[Figure]SR[Figure]EX
Batch creation of index
(-k ixmk)
SRSRSUEX[Figure]SR[Figure][Figure]
Re-creation of index
(-k ixrc)
index statement specified5EX [Figure] SR6[Figure][Figure]SR6SUEX[Figure]SR[Figure]EX [Figure][Figure]6
SU [Figure] SR6EX [Figure] SR6EX [Figure][Figure]6SU [Figure][Figure]6
idxname statement specifiedSUEXSUEXEXSR[Figure][Figure]
Reorganization of index
(-k ixor)7
SRPRSUEX[Figure]SR[Figure][Figure]
EX[Figure]
Batch creation of plug-in index (-k ixmk)SRSRSUEX[Figure]SREX[Figure]
Re-creation of plug-in index
(-k ixrc)
index statement specified5EX [Figure] SR6[Figure][Figure]SR6SUEX[Figure]SREXEX [Figure][Figure]6
SU [Figure] SR6EX [Figure] SR6EX [Figure][Figure]6SU [Figure][Figure]6
idxname statement specifiedSUEXSUEXEXSR[Figure]SU
Reloading of LOB data only (-k reld)SRPR[Figure][Figure][Figure]SR[Figure]EX
Reorganization of LOB data only (-k rorg)SUEXSR4[Figure]EXSR[Figure]SU
Legend:
RD AREA: RDAREA
TBL ID: Table ID
IX ID: Index ID
NW TBL: No-wait table
Res mgmt table: Resource management table
IX info file: Index information file
Note
When reload or reorganization is executed on a LOB column structure base table only, the lock mode is the same as for reloading or reorganization by table when loading or reorganizing data by table or the same as for reloading or reorganization by RDAREA when reloading or reorganizing data by RDAREA.
1
An RDAREA that is not the target of processing is not locked.
2
If data is unloaded in physical order, lock is not placed.
3
Lock is placed in the SR mode during unload processing.
4
Lock is not placed on a non-partitioned index during reload processing.
5
The upper row applies to a row-partitioned index; the lower row applies to a non-partitioned index.
6
The lock mode during unload processing on the index information (from KFPL00725-I to KFPL00726-I) is changed during index creation (from KFPL00715-I to KFPL00716-I).
7
The upper row applies when the index storage RDAREA is in command shutdown status; the lower row applies when it is not in command shutdown status.

Table B-6 Lock modes for the database reorganization utility (for shared tables)

Exe envResource
TableIndexNo-wait tblRD AREA mgmt blockIX info file
Updatable backend serverRef-only backend serverShared RD AREA for updatbl backend serverShared RD AREA for ref-only backend serverIX ID
Shared RD AREATbl IDShared RD AREATbl ID
Unload by table
(-k unld)
SRPR[Figure][Figure]SR1[Figure][Figure][Figure]SR[Figure]
Reload by table (-k reld)EXEXEXEXEXEXEXEXSR[Figure]
Reorg by table (-k rorg)EXEXEXEXEXEXEXEXSR[Figure]
Batch index creation (-k ixmk)SRSR[Figure][Figure]EXEXEX[Figure]SR[Figure]
Re-crtn of index (-k ixrc, and index stmt specif)2EX [Figure] SREX [Figure] SREXEXEXEXEXEX [Figure][Figure]SR[Figure]
Re-crtn of index (-k ixrc, and idxname stmt specif)EXEXEXEXEXEXEXEXSR[Figure]
Index reorg (-k ixor)SRPR[Figure][Figure]EXEXEX[Figure]SR[Figure]
Legend:
env: environment
Exe: Execution
info: information
IX: Index
mgmt: management
RD AREA: RDAREA
Re-crtn: Re-creation
Ref: referencing
Reorg: Reorganization
specif: specified
stmt: statement
Tbl: Table
updatbl: updatable
1 If data is unloaded in physical order, lock is not placed.
2 The lock mode for index information during an unload operation (from KFPL00725-I through KFPL00726-I) is changed when the index is loaded (from KFPL00715-I to KFPL00716-I).

Table B-7 Lock modes for the rebalancing utility

Execution environmentResource
RDAREATableNo-wait tableIndexRebalance*Preprocessed table
Shared modeSUEXEXEXEXSR
Exclusive modeSUEXEXEX[Figure]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 envResource
TableNo-wait tableIndex
RD AREARD AREA mgmt blockTbl IDFree page rel utilRD AREARD AREA mgmt blockIX IDFree page rel utilWait for trxn compl
Releasing free pages from tableSUSRSUEXSR[Figure][Figure][Figure][Figure][Figure]
Releasing free segments from tableEXSR[Figure]EX[Figure][Figure][Figure][Figure][Figure][Figure]
Releasing free pages from index[Figure][Figure][Figure][Figure]SRSUSREXEXPR
Releasing free segments from index[Figure][Figure]SR[Figure][Figure]EXSR[Figure]EX[Figure]
Legend:
RD AREA: RDAREA
RD AREA mgmt block: RDAREA management block
Tbl ID: Table ID
Free page rel util: Free page release utility
IX ID: Index ID
IX info file: Index information file
Wait for trxn compl: Wait for transaction completion

Table B-9 Lock modes for the free page release utility (for shared tables)

Exe envResource
TableIndex
Updatbl backend serverRef-only backend serverRMBFree page rel utilSR for UBSSR for RBSRMBIX IDFree page rel utilWait for trxn compl
SRTbl IDSRTbl ID
Release free pages from tableEXEXEXEXSREX[Figure][Figure][Figure][Figure][Figure][Figure]
Release free segmts from tableEXEXEXEXSREX[Figure][Figure][Figure][Figure][Figure][Figure]
Release free pages from index[Figure]SR[Figure][Figure][Figure][Figure]EXEXSREXEXPR
Release free segmts from index[Figure]SR[Figure][Figure][Figure][Figure]EXEXSR[Figure]EX[Figure]
Legend:
compl: completion
env: environment
Exe: Execution
IX: Index
mgmt: management
rel: release
segmts: segments
RMB: RDAREA management block
SR: Shared RDAREA
SR for UBS: Shared RDAREA for updatable back-end server
SR for RBS: Shared RDAREA for referencing-only back-end server
Tbl: Table
Updatbl: Updatable
util: utility

Table B-10 Lock modes for the global buffer residence utility

Exe envResource
TableIndex
RDAREARDAREA management blockNo-wait tableRDAREARDAREA management blockIndex ID
Reading data page
(-k table)
SRSRSR[Figure][Figure][Figure]
Reading index page
(-k index)
[Figure][Figure]SRSRSRSR
Legend:
env: environment
Exe: Execution

Table B-11 Lock modes for the global buffer residence utility (for shared tables)

Exe envResource
TableIndex
Updatable backend serverReferencing-only backend serverUpdatable backend serverReferencing-only backend server
RRMBNo-wait tblRRMBNo-wait tblRRMBIX IDRRMBIX ID
Reading data page
(-k table)
SRSRSRSRSRSR[Figure][Figure][Figure][Figure][Figure][Figure]
Reading index page
(-k index)
[Figure][Figure]SR[Figure][Figure]SRSRSRSRSRSRSR
Legend:
env: environment
Exe: Execution
IX: Index
R: RDAREA
RMB: RDAREA management block

Table B-12 Lock modes for the database condition analysis utility

Execution environmentResource
RDAREAResources management tableTableNo-wait table1
For tableFor indexSpecified RDAREA
Analysis by RDAREA[Figure][Figure]SRSR[Figure]SR
Analysis by tableSR[Figure][Figure]SRSRSR
Analysis by index[Figure]SR[Figure]SRSRSR
Condition analysis result accumulation facilitySRSRSRSRSR[Figure]
Facility for predicting reorganization time2SRSRSRSRSRSR

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 environmentResource
RDAREAResources management tableTableNo-wait tableData dictionary table
For tableFor indexFor tableFor indexRowKey
Acquisition of optimization informationSRSRSRSRSR/SU1SRPR2/EX1PR2/EX1
Deletion of optimization information[Figure][Figure][Figure][Figure]SU1[Figure]PR2/EX1PR2/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 environmentResource
Data dictionary tableRDAREADirectory block 6Resources management table
-M optionxPRPR[Figure][Figure]
rPRPR[Figure][Figure]
s[Figure][Figure]PRSR

Table B-15 Lock modes for the database recovery utility

Execution environmentResource
Data dictionary tableRDAREA
Recovery of RDAREAEX*EX
* Lock is placed if the master directory RDAREA is to be recovered.

Table B-16 Lock modes for the registry facility initialization utility

Execution EnvironmentResource
Database structure modification utilityData dictionary tableRDAREA conditionRDAREA
Addition of registry RDAREAs, registry LOB RDAREAs, and registry management tables (-k all)EXEXEXEX

Table B-17 Lock modes for the integrity check utility

Execution environmentResource
User tableData dictionary table
RDAREATBLNW TBLRowPP TBLTBLRDAREA
For TBLFor IXFor TBLFor IX
Integrity checking (-k check)When searching data dictionary table[Figure][Figure][Figure][Figure]PRPRSRSRSR
When acquiring RDAREA check pending status*SRSRPR[Figure][Figure][Figure][Figure][Figure][Figure]
When performing integrity checking[Figure][Figure][Figure][Figure][Figure][Figure][Figure][Figure][Figure]
When setting check pending statusSUSUEXEXEXPRSUSUSU
Forced setting of check pending status (-k set) or forced release of check pending status (-k release)When searching data dictionary table[Figure][Figure][Figure][Figure]PRPRSRSRSR
When acquiring RDAREA check pending status*SRSRPR[Figure][Figure][Figure][Figure][Figure][Figure]
When setting or releasing check pending statusSU[Figure]EXEXEXPRSUSUSU
Legend:
For TBL: For table
For IX: For index
NW TBL: No-wait table
PP TBL: Preprocessing table
TBL: Table
* Lock is placed by UNTIL DISCONNECT (lock is maintained until DISCONNECT is executed after the setting of check pending status is completed).