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
pddbchg	--	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
pdorbegin	--	N	N	N
pdorchg	--	N	N	N
pdorend	--	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	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	Y	Y (index: W)	N	N	Y	W
	IN EXCLUSIVE MODE is used	Y	Y (index: W)	N	N	Y	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

#

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.

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 method		Target 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 operand	pdlbuffer operand	Different table	Different index	Same table	Same index	Different table	Different index	Same table	Same index	Different table	Different index	Same table	Same index
Y specified	-r specified	N#1	N#1	N#1	N#1	N#1	N#1	N#1	N#1	N#1	N#1	N#1	N#1
	-i specified	Y	Y	Y	N#1	N#1	N#1	N#1	N#1	Y	Y	N#1	N#1
N specified	-r specified	N#2	N#2	N#2	N#2	N#2	N#2	N#2	N#2	N#2	N#2	N#2	N#2
	-i specified	Y	Y	Y	N#2	N#2	N#2	N#2	N#2	Y	Y	N#2	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.