Monitoring activity on connections from Db2

A thread is established from a dependent region when an application makes its first successful Db2 request. You can issue IMS or Db2 commands to see information about connections and the applications that currently use them.

Procedure

To monitor activity on connections, issue the following commands:

  • From Db2:
    -DISPLAY THREAD (imsid)
  • From IMS:
    /SSR -DISPLAY THREAD (imsid)

Results

Either command produces the following messages:

DSNV401I - DISPLAY THREAD REPORT FOLLOWS -
DSNV402I - ACTIVE THREADS -
NAME      ST  A  REQ     ID           AUTHID     PLAN     ASID    TOKEN
conn-name s   *  req-ct  corr-id      auth-id    pname    asid    token
conn-name s   *  req-ct  corr-id      auth-id    pname    asid    token
DISPLAY ACTIVE REPORT COMPLETE
DSN9022I - DSNVDT '-DISPLAY THREAD' NORMAL COMPLETION