MAINFRAME > Administrator > Db2

Display Thread Command

Better understand output and DB2 application status

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.

Troy L. Coleman is an IBM-certified Certified database administrator, specializing in DB2 9 for z/OS and Linux, UNIX and Windows. Troy can be reached at

comments powered by Disqus



2019 Solutions Edition

A Comprehensive Online Buyer's Guide to Solutions, Services and Education.

An Intuitive Approach to DB2 for z/OS SQL Query Tuning

Real-world samples provide valuable lessons.


A Db2 Utilities Migration Project

IBM Systems Magazine Subscribe Box Read Now Link Subscribe Now Link iPad App Google Play Store
Mainframe News Sign Up Today! Past News Letters