The following table shows whether pdpgbfon can be executed concurrently with SQL statements.

Table 12-1 Whether pdpgbfon can be executed concurrently with SQL statements

SQL statement		Target of operation in the same RDAREA
		Different table (or index)	Same table (or index)
Retrieval	NOWAIT specified	Y	Y
	WITH SHARE specified	Y	Y
	WITH EXCLUSIVE specified	Y	Y
	FOR UPDATE clause specified	Y	Y
	Other	Y	Y
Updating	NEXT VALUE clause specified	Y	Y
	Other	Y	Y
Addition	NEXT VALUE clause specified	Y	Y
	Other	Y	Y
Deletion		Y	Y
LOCK statement	SHARE specified	Y	Y
	EXCLUSIVE specified (non-shared table)	Y	Y
	EXCLUSIVE specified (shared table)	N	N
Table deletion		Y	N#
Indexes	Definition	Y	Y
	Deletion	Y	N#
Deletion of all rows		Y	N
Table definition modification		Y	N#
Sequence generator definition		Y (there is no need to identify the same table because the sequence generator definition is not an SQL statement that is executed on tables)
Sequence generator deletion		Y (there is no need to identify the same table because the sequence generator definition is not an SQL statement that is executed on tables)

Legend:

Y: Can be executed concurrently.

N: Cannot be executed concurrently (if attempted, lock-release wait status is applied).

#

While this utility is running, table deletion, index deletion, and modifying table definitions cannot be performed on a table or an index that is being processed by this utility. However, in some cases these operations might be possible depending on the timing, as described below.

A table that has been added by modifying table definitions cannot be processed by pdpgbfon. However, if table definitions are modified, resulting in deletion of a table, index, or RDAREA subject to processing by pdpgbfon, KFPA11815-E is output.

The following table shows whether pdpgbfon can be executed concurrently with a UAP with a local buffer specified.

Table 12-2 Whether pdpgbfon can be executed concurrently with a UAP with a local buffer specified

Local buffer specification method		Target of operation in the same RDAREA
pd_uap_wait operand	pdlbuffer operand	Different table	Different index	Same table	Same index
Y specified	-r specified	N#1	N#1	N#1	N#1
	-i specified	Y	Y	Y	N#1
N specified	-r specified	N#2	N#2	N#2	N#2
	-i specified	Y	Y	Y	N#2

Legend:

Y: Can be executed concurrently.

N: Cannot be executed concurrently.

#1

If attempted, lock-release wait status is applied.

#2

The UAP terminates with an error.