DB2 10.5 for Linux, UNIX, and Windows

db2_local_ps - DB2 process status for Linux/UNIX command

On Linux and UNIX systems, all of the DB2® processes running under an instance can be displayed using the db2_local_ps command.

Authorization

None

Required connection

None

Command syntax

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

Command parameters

db2_local_ps
Outputs all of the DB2 processes running under an instance.

Examples

[db2inst1@bower1 ~]$ db2_local_ps
Node 0
     UID        PID       PPID    C     STIME     TTY     TIME CMD
db2inst1       3254       3253    0     14:04   pts/1 00:00:00 db2sysc 0
    root       3255       3254    0     14:04   pts/1 00:00:00 db2ckpwd 0
    root       3256       3254    0     14:04   pts/1 00:00:00 db2ckpwd 0
    root       3257       3254    0     14:04   pts/1 00:00:00 db2ckpwd 0
    root       3266       3254    0     14:04   pts/1 00:00:00 db2gds 0
db2inst1       3267       3254    0     14:04   pts/1 00:00:00 db2licc 0
db2inst1       3268       3254    0     14:04   pts/1 00:00:00 db2ipccm 0
db2inst1       3269       3254    0     14:04   pts/1 00:00:00 db2tcpcm 0
db2inst1       3271       3254    0     14:04   pts/1 00:00:00 db2resync 0
db2inst1       3273       3254    0     14:04   pts/1 00:00:00 db2acd ,0,0,0,1,0,0,897b50,...
db2inst1       3297       3266    0     14:04   pts/1 00:00:00 db2loggr (SAMPLE) 0
db2inst1       3299       3266    0     14:04   pts/1 00:00:00 db2loggw (SAMPLE) 0
db2inst1       3300       3266    0     14:04   pts/1 00:00:00 db2lfr (SAMPLE) 0
db2inst1       3301       3266    0     14:04   pts/1 00:00:00 db2dlock (SAMPLE) 0
db2inst1       3303       3266    0     14:04   pts/1 00:00:00 db2pclnr 0
db2inst1       3313       3266    0     14:05   pts/1 00:00:00 db2pfchr 0
db2inst1       3314       3266    0     14:05   pts/1 00:00:00 db2pfchr 0
db2inst1       3315       3266    0     14:05   pts/1 00:00:00 db2pfchr 0
db2inst1       3316       3266    0     14:05   pts/1 00:00:00 db2stmm (SAMPLE) 0
db2inst1       3317       3266    0     14:05   pts/1 00:00:00 db2taskd (TOOLSDB) 0
db2inst1       3318       3266    0     14:05   pts/1 00:00:00 db2taskd (SAMPLE) 0
db2inst1       3319       3266    0     14:05   pts/1 00:00:00 db2stmm (TOOLSDB) 0
db2inst1       3320       3266    0     14:05   pts/1 00:00:00 db2evmgi (DB2DETAILDEADLOCK) 0
db2inst1       3321       3266    0     14:05   pts/1 00:00:00 db2evmgi (DB2DETAILDEADLOCK) 0
db2inst1       3341       3266    0     14:05   pts/1 00:00:00 db2loggr (TOOLSDB) 0
db2inst1       3343       3266    0     14:05   pts/1 00:00:00 db2loggw (TOOLSDB) 0
db2inst1       3344       3266    0     14:05   pts/1 00:00:00 db2lfr (TOOLSDB) 0
db2inst1       3345       3266    0     14:05   pts/1 00:00:00 db2dlock (TOOLSDB) 0
db2inst1       3346       3266    0     14:05   pts/1 00:00:00 db2pclnr 0
db2inst1       3347       3266    0     14:05   pts/1 00:00:00 db2pfchr 0
db2inst1       3348       3266    0     14:05   pts/1 00:00:00 db2pfchr 0
db2inst1       3349       3266    0     14:05   pts/1 00:00:00 db2pfchr 0
db2inst1       3270       3268    2     14:04   pts/1 00:00:01 db2agent (TOOLSDB) 0
db2inst1       3285       3268    0     14:04   pts/1 00:00:00 db2agent (SAMPLE) 0

Node 1 ...

Usage notes

Note that processes will not be shown if the instance is stopped. Run the db2start command if processes are not listed.