This subsection explains execution of pdpgbfon concurrently with other functions.
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) |
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 |