When a temporary table is instantiated, HiRDB acquires the locks shown in the following table.

Table 12-29 Locks acquired when a temporary table is instantiated

Resource type name	Description	Unlock timing
		Transaction-specific temporary table	SQL session-specific temporary table
RDAR	RDAREA (table and index#1 storage RDAREA)	When the transaction is completed	When the DISCONNECT statement is completed
TABL	Table
RATM	User directory table information
RAIM	User directory index information#1
SBMB	User directory segment information
TEMP	Temporary table instantiation control information		After the temporary table has been instantiated#2
TPID	User-specific ID management (temporary table)		When the DISCONNECT statement is completed
RDAS	RDAREA status management		After the temporary table has been instantiated#2
RRAM, TRAL, TRAI	RDAREA management information
PTBL	Table for preprocessing		When the DISCONNECT statement is completed

#1

Applicable only if there is a temporary table index.

#2

A lock for this resource is acquired temporarily during instantiation.

When the following SQL statements are executed, a lock is acquired only for the preprocessing table (PTBL):

• LOCK statement
• CREATE INDEX statement
• DROP INDEX statement
• DROP TABLE statement

Note that executing the following SQL statements on a temporary table will not lock pages, rows, or key values:

• SELECT statement
• INSERT statement
• UPDATE statement
• DELETE statement
• PURGE TABLE statement

If you are performing an operation on a temporary table and, at the same time, you execute any of the following operations, a lock-release wait status or an execution error might result:

• pdclose (close a temporary table RDAREA)
• pdhold (shut down a temporary table RDAREA)
• pdopen (open a temporary table RDAREA)
• pdrels (release a temporary table RDAREA from shutdown status)
• create rdarea statement in the pdmod command (add a temporary table RDAREA)
• initialize rdarea statement in the pdmod command (re-initialize a temporary table RDAREA)
• remove rdarea statement in the pdmod command (delete a temporary table RDAREA)
• CREATE INDEX statement (define a temporary table index)
• DROP INDEX statement (delete a temporary table index)
• DROP SCHEMA statement (delete a schema)
• DROP TABLE statement (delete a temporary table)