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

(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
pddbfrz--NNN
pddbls-aYNY
Other than -aYYY
pdhold-buYYY
Other than -buNNN
pdopen--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 statementLocal bufferpdreclaim
-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 usedNot usedYY (index: W)NNYW
IN EXCLUSIVE MODE is used--YY (index: W)NNYN
--UsedNNNNNN
PURGE TABLE statement----YNNNYN
DROP TABLE----YNNNYN
CREATE INDEX----YNNNYN
DROP INDEX----YNNNYN
ALTER TABLE----YNNNYN
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