11.1.7 Concurrent execution of pdreclaim and other functions

This subsection discusses concurrent execution of pdreclaim and other functions.

Organization of this subsection
(1) Whether pdreclaim can be executed concurrently with operation commands
(2) Whether pdreclaim can be executed concurrently with other utilities
(3) Whether pdreclaim can be executed concurrently with SQL statements
(4) Whether pdreclaim can be executed concurrently with a UAP with a local buffer specified

(1) Whether pdreclaim can be executed concurrently with operation commands

The table below shows whether pdreclaim can be executed concurrently with operation commands.

Table 11-2 Whether pdreclaim can be executed concurrently with operation commands

Operation commandConditionpdreclaim
-j and -a options omitted (releases free pages)-j option specified (releases free segments)-a option specified (releases free pages and free segments)
pdclose--NNN
pddbchg--NNN
pddbfrz--NNN
pddbls-aYNY
Other than -aYYY
pdhold-buYYY
Other than -buNNN
pdopen--NNN
pdorbegin--NNN
pdorchg--NNN
pdorend--NNN
pdrelsRDAREA is in updatable backup-hold statusYYY
RDAREA is in a status other than updatable backup-hold statusNNN
Legend:
Y: Can be executed concurrently.
N: Cannot be executed concurrently (if attempted, lock-release wait status is applied).
--: Not applicable

(2) Whether pdreclaim can be executed concurrently with other utilities

The table below shows whether pdreclaim can be executed concurrently with other utilities.

Table 11-3 Whether pdreclaim can be executed concurrently with other utilities

UtilityConditionpdreclaim
-j and -a options omitted (releases free pages)-j option specified (releases free segments)-a option specified (releases free pages and free segments)
Different table (index)Same table (index)Different table (index)Same table (index)Different table (index)Same table (index)
pdloadData loading in units of tablesYNNNYN
Data loading in units of RDAREAsNNNNNN
Data loading only in LOB columnsYYNNYW
pdmod--NNNNNN
pdrorgUnloading (unldenq=tblenq or unldenq=nowait)YY (index: W)NNYW
Unloading (unldenq=rdenq)NNNNNN
Reloading or reorganizing in units of tablesYNNNYN
Reloading or reorganizing in units of RDAREAsNNNNNN
Creating an index in batch modeYNNNYN
Re-creating an index (index statement specified and row-partitioned index)NNNNNN
Re-creating an index (index statement specified and non-row-partitioned index)YNNNYN
Re-creating an index (idxname statement specified)YNNNYN
Reorganizing an index (index storage RDAREA is in command shutdown status)YNNNYN
Reorganizing an index (index storage RDAREA is not in command shutdown status)NNNNNN
Reloading only LOB columnsYYNNYW
Reorganizing only LOB columnsYNNNYN
pdrbal--NNNNNN
pdreclaimReleasing free pagesYNNNYN
Releasing free segmentsNNNNNN
Releasing free pages and free segmentsYNNNYN
pdpgbfonReading data pagesYYNNYW
Reading index pagesYNNNYN
pdconstck--YNNNYN
pddbst--YY (index: W)NNYW
pdgetcstAcquiring optimization informationYY (index: W)NNYW
Deleting optimization informationYYYYYY
pdcopyReference/update-impossible mode or reference-possible modeNNNNNN
Updatable modeYYYYYY
pdrstr--NNNNNN
Legend:
Y: Can be executed concurrently.
N: Cannot be executed concurrently (if attempted, lock-release wait status is applied).
W: pdreclaim waits for completion of the utility's transaction that would be executed concurrently.
--: Not applicable

(3) Whether pdreclaim can be executed concurrently with SQL statements

The table below shows whether pdreclaim can be executed concurrently with SQL statements.

Table 11-4 Whether pdreclaim can be executed concurrently with SQL statements

SQLLOCK statementpdreclaim
-j and -a options omitted (releases free pages)-j option specified (releases free segments)-a option specified (releases free pages and free segments)
Different table (index)Same table (index)Different table (index)Same table (index)Different table (index)Same table (index)
SELECT, UPDATE, INSERT, or DELETE statementNot used, or IN SHARE MODE is usedYY (index: W)NNYW
IN EXCLUSIVE MODE is usedYY (index: W)NNYN
PURGE TABLE statement--YNNNYN
DROP TABLE--YN#NN#YN#
CREATE INDEX--YNNNYN
DROP INDEX--YN#NN#YN#
ALTER TABLE--YN#NN#YN#
Legend:
Y: Can be executed concurrently.
N: Cannot be executed concurrently (if attempted, lock-release wait status is applied).
W: pdreclaim waits for completion of the SQL statement's transaction that would be executed concurrently.
--: Not applicable
#
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 pdreclaim. However, if table definitions are modified, resulting in deletion of a table, index, or RDAREA subject to processing by pdreclaim, KFPA11815-E is output.

(4) Whether pdreclaim can be executed concurrently with a UAP with a local buffer specified

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

Table 11-5 Whether pdreclaim can be executed concurrently with a UAP with a local buffer specified

Local buffer specification methodTarget of operation in the same RDAREA
-j and -a options omitted (releases free pages)-j option specified (releases free segments)-a option specified (releases free pages and free segments)
pd_uap_wait operandpdlbuffer operandDifferent tableDifferent indexSame tableSame indexDifferent tableDifferent indexSame tableSame indexDifferent tableDifferent indexSame tableSame index
Y specified-r specifiedN#1N#1N#1N#1N#1N#1N#1N#1N#1N#1N#1N#1
-i specifiedYYYN#1N#1N#1N#1N#1YYN#1N#1
N specified-r specifiedN#2N#2N#2N#2N#2N#2N#2N#2N#2N#2N#2N#2
-i specifiedYYYN#2N#2N#2N#2N#2YYN#2N#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.