This statement restores the logical availability of partitions in a partitioned table.
Scope of validity
DBH administration
See also
The administration statement SHOW-PARTITIONS on "SHOW-PARTITIONS"
Function
A number of accesses to partitioned tables (e.g. DML statements) require the logical availability of the partitions concerned. This means that SESAM/SQL checks the internally registered availability status, but not whether the partition is actually physically available.
You use the REUSE-PARTITIONS statement to check the physical availability of partitions in a partitioned table which are logically not available. If a partition proves to be physically available, it is marked internally as logically available and thus released for the abovementioned accesses.
REUSE-PARTITIONS performs the check on the specified partitioned table in a transaction-free status. The call can therefore take some time if transactions are running.
REUSE-PARTITIONS is used for a partitioned table only if the specified table is already physically open. A base table is opened the first time this table is accessed in a DBH session.
REUSE-PARTITIONS |
CATALOG-NAME = <filename 1..18 without-cat-user-gen-vers> ,SCHEMA-NAME = <c-string 1..31 with-lower-case> ,TABLE-NAME = <c-string 1..31 with-lower-case> |
Operands
CATALOG-NAME = <filename 1..18 without-cat-user-gen-vers>
Logical name of the database.
SCHEMA-NAME = <c-string 1..31 with-lower-case>
Name of the schema in the base table.
TABLE-NAME = <c-string 1..31 with-lower-case>
Name of the base table.
Administration command in ISP format and at the CALL DML interface
The PARTITION,REUSE administration command corresponds to the REUSE-PARTITIONS administration statement here.
PARTITION,REUSE,C[ATALOG]=name,S[CHEMA]=name,T[ABLE]=name
The values defined beforehand for the relevant operands may be entered for name.