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 command	Condition	pdreclaim
		-j and -a options omitted (releases free pages)	-j option specified (releases free segments)	-a option specified (releases free pages and free segments)
pdclose	--	N	N	N
pddbfrz	--	N	N	N
pddbls	-a	Y	N	Y
	Other than -a	Y	Y	Y
pdhold	-bu	Y	Y	Y
	Other than -bu	N	N	N
pdopen	--	N	N	N
pdrels	RDAREA is in updatable backup-hold status	Y	Y	Y
	RDAREA is in a status other than updatable backup-hold status	N	N	N

Legend:

Y: Can be executed concurrently.

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

--: Not applicable

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

Utility	Condition	pdreclaim
		-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)
pdload	Data loading in units of tables	Y	N	N	N	Y	N
	Data loading in units of RDAREAs	N	N	N	N	N	N
	Data loading only in LOB columns	Y	Y	N	N	Y	W
pdmod	--	N	N	N	N	N	N
pdrorg	Unloading (unldenq=tblenq or unldenq=nowait)	Y	Y (index: W)	N	N	Y	W
	Unloading (unldenq=rdenq)	N	N	N	N	N	N
	Reloading or reorganizing in units of tables	Y	N	N	N	Y	N
	Reloading or reorganizing in units of RDAREAs	N	N	N	N	N	N
	Creating an index in batch mode	Y	N	N	N	Y	N
	Re-creating an index (index statement specified and row-partitioned index)	N	N	N	N	N	N
	Re-creating an index (index statement specified and non-row-partitioned index)	Y	N	N	N	Y	N
	Re-creating an index (idxname statement specified)	Y	N	N	N	Y	N
	Reorganizing an index (index storage RDAREA is in command shutdown status)	Y	N	N	N	Y	N
	Reorganizing an index (index storage RDAREA is not in command shutdown status)	N	N	N	N	N	N
	Reloading only LOB columns	Y	Y	N	N	Y	W
	Reorganizing only LOB columns	Y	N	N	N	Y	N
pdrbal	--	N	N	N	N	N	N
pdreclaim	Releasing free pages	Y	N	N	N	Y	N
	Releasing free segments	N	N	N	N	N	N
	Releasing free pages and free segments	Y	N	N	N	Y	N
pdpgbfon	Reading data pages	Y	Y	N	N	Y	W
	Reading index pages	Y	N	N	N	Y	N
pdconstck	--	Y	N	N	N	Y	N
pddbst	--	Y	Y (index: W)	N	N	Y	W
pdgetcst	Acquiring optimization information	Y	Y (index: W)	N	N	Y	W
	Deleting optimization information	Y	Y	Y	Y	Y	Y
pdcopy	Reference/update-impossible mode or reference-possible mode	N	N	N	N	N	N
	Updatable mode	Y	Y	Y	Y	Y	Y
pdrstr	--	N	N	N	N	N	N

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

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

SQL	LOCK statement	Local buffer	pdreclaim
			-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 statement	Not used, or IN SHARE MODE is used	Not used	Y	Y (index: W)	N	N	Y	W
	IN EXCLUSIVE MODE is used	--	Y	Y (index: W)	N	N	Y	N
	--	Used	N	N	N	N	N	N
PURGE TABLE statement	--	--	Y	N	N	N	Y	N
DROP TABLE	--	--	Y	N	N	N	Y	N
CREATE INDEX	--	--	Y	N	N	N	Y	N
DROP INDEX	--	--	Y	N	N	N	Y	N
ALTER TABLE	--	--	Y	N	N	N	Y	N

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