Displays the spaces used by the user and thus locked
Scope of validity
DBH administration
Function
The SHOW-USER-SPACES statement specifies all the spaces that are used by a specified user and are thus locked.
For every space identified in this way, the logical database name and the name of the space are displayed. In addition, it is indicated whether the space is accessed exclusively.
SHOW-USER-SPACES | ||||||||||||||||
|
Operands
USER = <user-identification>
Identifies the user. The identification must be fully qualified (see the section “Syntax for the identification of users”).
STRUCTURE-OUTPUT = *NONE / *SYSINF / <structured-name 1..20>
(WRITE-MODE = *REPLACE / *EXTEND)
In S procedures, specifies whether the information is to be output in S variables (see section “Syntax for output in S variables”).
Output in S variables
Output information | Name of the S variable | T | Contents |
Numbering | var(*LIST).NUMBER | S | <integer> |
Logical database name | var(*LIST).CATALOG | S | <filename 1..18> |
Space name | var(*LIST).SPACE | S | <filename 1..18> |
Access mode | var(*LIST).LOCK-MODE | S | EXCLUSIV / '' (void) |
Example
Screen output after entry of the SHOW-USER-SPACES administration statement in DBH administration:
USER: TSN=12LD ------------------------------------------------------------------------ NR. ! CATALOG-NAME ! SPACE-NAME ! LOCK-MODE ------------------------------------------------------------------------ 1 ! AUFTRAGKUNDEN ! CATALOG ! 2 ! AUFTRAGKUNDEN ! TABLESPACE ! % <date> <time> SES7215 END OF OUTPUT %//
Administration command in ISP format and at the CALL DML interface
The SPACE administration command corresponds to the SHOW-USER-SPACES administration statement here.
SPACE,user-identification