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

• Database initialization utility (pdinit)
• Dictionary export/import utility (pdexp)
• Statistics analysis utility (pdstedit)
• Access path display utility (pdvwopt)
  

  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

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.

¹ In the case of index loading by RDAREA, lock is not placed on a non-partitioning key index.

² 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

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

Execution environment	Resource
	DB structure mod utility	Data dict table	RDAREA status	RDAREA	Tbl	Res mgmt table
RDAREA addition	EX	EX	EX3	EX3
RDAREA expansion	EX	EX	EX3	PU(EX)3		EX3
RDAREA reinitialization	EX	EX	EX3	EX3	EX
RDAREA deletion	EX	EX	EX3	EX3
Modification of data dictionary table attribute definition	EX	EX		EX2
Modification of RDAREA attributes	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 structure1	EX	EX	EX	EX
Moving an RDAREA	EX	EX	EX3	EX3
Auditor registration	EX	EX
Creation of an audit trail table	EX	EX		EX		EX

Legend:

config: configuration

DB: Database

Data dict table: Data dictionary table

info: information

mgmt: management

mod: modification

reinit: reinitialization

Tbl: Table

Res mgmt table: Resource management table

¹ This applies only to a HiRDB/Parallel Server; it is not applicable to a HiRDB/Single Server.

² Applies only to the data dictionary RDAREA.

³ Applicable to both original and replica 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	3	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 SR6	SR6	SU	EX		SR		EX 6
		SU SR6	EX SR6			EX 6			SU 6
	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 SR6	SR6	SU	EX		SR	EX	EX 6
		SU SR6	EX SR6			EX 6			SU 6
	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

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.

¹

An RDAREA that is not the target of processing is not locked.

²

If data is unloaded in physical order, lock is not placed.

³

Lock is placed in the SR mode during unload processing.

⁴

Lock is not placed on a non-partitioned index during reload processing.

⁵

The upper row applies to a row-partitioned index; the lower row applies to a non-partitioned index.

⁶

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

⁷

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

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

¹ If data is unloaded in physical order, lock is not placed.

² 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 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

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

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

Legend:

env: environment

Exe: Execution

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

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

¹ A no-wait table is locked only when the -d option is specified.

² 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

¹ Lock is placed temporarily during data dictionary table retrieval.

² 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

^* Lock is placed if the master directory RDAREA is to be recovered.

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

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