Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

SHOW-USER-SPACES

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

USER = <user-identification>

,STRUCTURE-OUTPUT = *NONE / *SYSINF / <structured-name 1..20>(...)


<structured-name 1..20>(...)



|

WRITE-MODE = *REPLACE / *EXTEND

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