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.
Search our new 2013 Buyer's Guide.
Administrator | Real-world samples provide valuable lessons.
Cover Story | The latest DB2 for z/OS releases provide additional table space and index design options.