Identifying who and what are using an object

You can obtain information about users and applications that are using an object, and about the units of work that are accessing data.

About this task

You can obtain the following information:

The names of the application programs currently using the database or space
The authorization IDs of the users of these application programs
The logical unit of work IDs of the database access threads that access data on behalf of the specified remote locations

Procedure

Begin general-use programming interface information. To obtain information about objects:

Issue the DISPLAY DATABASE command with the SPACENAM option.

Example

For example, you can issue a command that names partitions 2, 3, and 4 in table space TPAUGF01 in database DBAUGF01:

-DISPLAY DATABASE (DBAUGF01) SPACENAM (TPAUGF01) PART (2:4) USE

Db2 returns a list similar to this one:

DSNT360I : ***********************************
DSNT361I : *  DISPLAY DATABASE SUMMARY
           *    GLOBAL USE
DSNT360I : ***********************************
DSNT362I :     DATABASE = DBAUGF01  STATUS = RW
               DBD LENGTH = 8066
DSNT397I :
NAME     TYPE PART  STATUS            CONNID   CORRID       USERID
-------- ---- ----- ----------------- -------- ------------ --------

TPAUGF01 TS    0002 RW                BATCH    S3341209     ADMF001
    -                  MEMBER NAME V61A
TPAUGF01 TS    0003 RW                BATCH    S3341209     ADMF001
    -                  MEMBER NAME V61A
TPAUGF01 TS    0004 RW                BATCH    S3341209     ADMF001
    -                  MEMBER NAME V61A
******* DISPLAY OF DATABASE DBAUGF01 ENDED      **********************
DSN9022I : DSNTDDIS 'DISPLAY DATABASE' NORMAL COMPLETION

End general-use programming interface information.