DISPLAY command

Edit online

Use the DISPLAY command to display information about all connected users.

Displaying basic information

Use the following syntax to display basic information about all connected users:
"DISPLAY REMOTE USERS(*)"
This command displays the following information about each connected user:

  • ACTUAL BLOCK ADDRESS

  • APPLICATION NAME

  • CONNECTION ID

  • DB2® SUBSYSTEM

  • HOST NAME

  • ICUV PATH ID

  • IP ADDRESS

  • LINK TYPE

  • LOCAL IP PORT NUMBER

  • REMOTE IP PORT NUMBER

  • SOCKET NUMBER

  • TRUSTED HOST

  • USER ID

  • TASK TCB ADDRESS

  • TRUSTED HOST

  • USER ID

Displaying additional information

Use the following syntax to display additional information about all connected users:
"DISPLAY REMOTE USERS(*) VERBOSE"
This command provides the following additional information about each connected user:

  • ACEE SOURCE

  • BUFFER FUNCTION CODE

  • COMPRESSED SEND AMOUNT

  • COMPRESSED TOTAL BYTES RECEIVED

  • CPU TIME

  • CUMULATIVE COMPRESSION

  • CUMULATIVE RECEIVED COMPRESSION

  • CURRENT COMPRESSED RECEIVED AMOUNT

  • CURRENT RAW RECEIVED AMOUNT

  • CURRENT STATE

  • DB2 PLAN NAME

  • DB2 REQUESTING SITE

  • DB2 THREAD TOKEN

  • DOMAIN NAME

  • ELAPSED TASK TIME

  • EXTENDED USER ID

  • GENERIC USER ID

  • HOST TIME

  • INTERNAL NAME

  • LAN USER ID

  • LOCKS HELD

  • MODULE NAME

  • ODBC DRIVER DATE

  • ODBC DRIVER VERSON

  • PROGRAM NAME

  • RAW BYTES RECEIVED

  • RAW BYTES SENT

  • RAW RECEIVED COMPRESSION

  • RAW SEND AMOUNT

  • RAW SEND COMPRESSION FACTOR

  • SQL CODE

  • SQL COUNT

  • SQL CURSOR NUMBER

  • SQL REASON CODE

  • SQL RETURN CODE

  • SQL STATEMENT NUMBER

  • SQL STATEMENT TYPE

  • STATE DURATION

  • TELEPROCESSING TIME

  • TELEPROCESSING TIME PERCENTAGE

  • TOTAL RAW BYTES SENT

  • USER PARAMETER

  • WLM ENCLAVE COUNT

  • WLM ENCLAVE CPU TIME