Mainframe > Administrator > DB2

Display Thread Command

Better understand output and DB2 application status

The display thread command provides a list of applications connected to DB2, along with their current status. Database administrators (DBAs), of course, spend considerable time working with threads, but for the uninitiated, here's a definition from IBM:

“A thread is the database manager structure that describes an application's connection, traces its progress, processes resource functions and delimits its accessibility to the database manager resources and services. Most DB2 for z/OS functions execute under a thread structure.”

There are several different types of threads (active, inactive indoubt, postponed, proc, system). For a complete description of these types, along with all the other parameters available with the Display Thread command, see the DB2 Version 9.1 for z/OS Command Reference.

Tweet