DB2 10.5 for Linux, UNIX, and Windows

db2stat - DB2 process status for Windows command

On Windows systems, all DB2® processes running under all instances can be displayed using the db2stat command.

Authorization

None

Required connection

None

Command syntax

Read syntax diagramSkip visual syntax diagram
>>-db2stat-----------------------------------------------------><

Command parameters

db2stat
Outputs all active DB2 processes.

Examples

C:\Program Files\IBM\SQLLIB\BIN>db2stat

Environment Strings
 --> DB2CLP=DB20FADE
 --> DB2INSTANCE=DB2
 --> DB2PATH=C:\Program Files\IBM\SQLLIB

DB2 Processes
        DB2DASRRM        1960   x7A8
        DB2MGMTSVC       2012   x7DC
        DB2RCMD          1212   x4BC
        DB2DASSTM        2044   x7FC
        DB2SYSTRAY       724    x2D4
        DB2              3100   xC1C
        DB2BP            3180   xC6C
        DB2SYSCS         1592   x638
        DB2FMP           3468   xD8C
        DB2STAT          1748   x6D4

Usage notes

One thing to note in the Windows case is that because DB2 is thread-based, not process-based, you will only see one process (DB2SYSCS) for all of an instance's EDUs. It is obvious that the same degree of information is not returned in Windows as is returned in Linux/UNIX systems, but it is still useful, at times, to know the process IDs for all running instances. For example, you can use the Windows Task Manager utility to determine the CPU and memory usage for a given process ID.