Canceling a thread from the enhanced 3270 user interface

You can view thread activity and cancel unwanted threads from the enhanced 3270 user interface.

About this task

From the enhanced 3270 user interface, you can view active threads for specific Db2 subsystems or for an entire data sharing group:

Navigate to the Active Threads panel (KDPTHD52 for a specific Db2 subsytem or KDPPTHRD for a data sharing group).
From the Active Threads tab, choose one of the following options to cancel an active thread:

C Cancel Thread (KDPTCANC)

Allows you to cancel a thread with a prompt to confirm thread cancellation.

X Multi-Thread Cancel No Confirmation (KDPPTKAC)

Allows you to cancel multiple threads without being prompted to confirm each individual thread cancellation.

The enhanced 3270UI based commands primarily use the Db2 authority of the logon ID, which simplifies managing the security aspects of Db2 thread canceling. The Db2 authority of the user controls whether a particular Db2 thread can be canceled or not. You can limit access to table KDP.REALCMD using a Query Profile. Using the query profile blocks an unauthorized user from issuing the Cancel Thread command from the enhanced 3270UI workspaces.