Delete ISAM pool or link to ISAM pool
Component: | BS2000 |
Functional area: | File processing |
Domain: | FILE |
Privileges: | STD-PROCESSING |
Function
The DELETE-ISAM-POOL command enables users to delete task-specific ISAM pools which they have created or to cancel links between their jobs and shareable ISAM pools (with scopes of USER-ID, USER-GROUP and HOST-SYSTEM). If the link between a shareable ISAM pool and the last job to which it was connected is canceled, the ISAM pool is automatically deleted.
An ISAM pool is uniquely identified by the specified name, the catalog ID (see the CAT-ID operand) and the scope (see the SCOPE operand). If an ISAM pool named in the command does not exist, the command is rejected with an error message. The user can check the ISAM pools to which his or her job is linked by using the SHOW-ISAM-POOL-ATTRIBUTES command.
Before it is possible to delete an ISAM pool, or the link between a job and a pool, the command REMOVE-ISAM-POOL-LINK must be issued to delete all entries for the pool concerned from the pool table of the job. Otherwise, if a pool is still linked to the pool table by its pool link name, the DELETE-ISAM-POOL command will be rejected with an error message. Entries in the pool table can be displayed by means of the SHOW-ISAM-POOL-LINK command.
Note on ISAM pools
Cross-task ISAM pools are automatically created on a file-specific basis when a file is opened in a data space. The CREATE-ISAM-POOL command with SCOPE=*USER-ID/*USER-GROUP is only supported for reasons of compatibility and has the same effect as SCOPE=*HOST-SYSTEM (for details on ISAM pools in data spaces see the “Introductory Guide to DMS” [13]).
A detailed description of the ISAM pool can be found in the manuals “Introductory Guide to DMS” [13] and “DMS Macros” [12].
Format
DELETE-ISAM-POOL |
Operands
POOL-NAME =*ALL / <name 1..8>(...)
Specifies whether it is only particular ISAM pools, or all those which are linked to the job, which are to be released.
POOL-NAME = *ALL
All the ISAM pools which are linked to the calling job are to be deleted or – for shareable pools – all the links to the ISAM pool are to be canceled. If the pool link names still define links between pools and files for the calling job, the command will be rejected with an error message.
POOL-NAME = <name 1..8>(...)
The specified ISAM pool is to be deleted. The ISAM pool is uniquely identified by the name, the catalog ID (see the CAT-ID operand) and the scope (see the SCOPE operand). If no ISAM pool was created as specified or no link to the pool was established (see the CREATE-ISAM-POOL command), the command is rejected with an error message.
CAT-ID = *DEFAULT-PUBSET / <alphanum-name 1..4>
Catalog ID of the pubset to which the ISAM pool is assigned.
CAT-ID = *DEFAULT-PUBSET
The ISAM pool is assigned to the catalog that was set with the ISPLDEFC system parameter ISPLDEFC (ISAM-POOL-DEFAULT-CATID):
X'00': | default catalog ID from the user entry (see the SHOW-USER-ATTRIBUTES command, DEFAULT-PUBSET output field) |
X'01': | catalog ID of the home pubset |
CAT-ID = <alphanum-name 1..4>
Catalog ID of the specified ISAM pool.
SCOPE = *TASK / *HOST-SYSTEM / *USER-ID / *USER-GROUP
Scope of the specified ISAM pool.
SCOPE = *TASK
The corresponding task-local ISAM pool, which can only be used by its own task, is to be deleted.
SCOPE = *HOST-SYSTEM
The corresponding cross-task ISAM pool, which can be used by all tasks, is to be deleted.
SCOPE = *USER-ID / USER-GROUP
These scopes are only supported for reasons of compatibility (see the "Note on ISAM pools" in section "DELETE-ISAM-POOL").
Return codes
(SC2) | SC1 | Maincode | Meaning |
|---|---|---|---|
0 | CMD0001 | Command executed without errors | |
32 | DMS0A17 | Internal system error | |
64 | DMS0A0E | Syntax error in ISAM pool command | |
64 | DMS0A11 | Specified catalog ID does not exist | |
64 | DMS0A13 | Specified pool name is syntactically invalid | |
64 | DMS0A19 | Specified ISAM pool does not exist | |
64 | DMS0A1A | Pool links to ISAM pool still exist | |
64 | DMS0A21 | ISAM pool limit reached | |
64 | DMS0A22 | User group does not exist | |
130 | DMS0A12 | Specified catalog ID not available |
Examples
See the ADD-ISAM-POOL-LINK command.