Troubleshooting Guide

Viewing Process Status Using the ps Command

The ps command is a UNIX-based system command that returns process status information about active processes (to standard output). Use it to look for discrepancies between DB2 processes that are running and DB2 processes that you expect to be there. (For a description of DB2 processes, see Chapter 14, The DB2 Process Model.)

Flags control the types of information displayed for each active process, and may be applied simultaneously to yield a cumulative effect. For information, use the man ps command from a system command prompt.

Example: To show all processes of the instance ID "svtdbm" use: ps -fu svtdbm

The following sample shows typical output from this command. (Note that there would be additional processes shown for DB2 Enterprise - Extended Edition.)

svtdbm (1) 5112 (2) 27894 (3) 0 10:48:17 (4) - 0:00 db2ipccm (5) svtdbm 6135 27894 0 10:48:17 - 0:00 db2gds svtdbm 14329 27894 0 10:48:17 - 0:00 db2resyn svtdbm 15356 27894 0 10:48:17 - 0:00 db2snacm (6) svtdbm 18682 27894 0 10:48:17 - 0:00 db2tcpcm (6) svtdbm 27894 31989 0 10:48:17 - 0:00 db2sysc (7) svtdbm 33275 27894 0 10:48:17 - 0:00 db2tcpim (6) svtdbm 39939 18682 7 10:48:19 - 0:00 db2agent svtdbm 56074 34761 2 10:48:37 pts/10 0:00 db2

Legend:

(1)

The instance ID

(2)

The process identifier (pid)

(3)

The parent process identifier

(4)

The timestamp

(5)

The name of the process. See Chapter 14, The DB2 Process Model for a description of the names.

(6)

The communication listeners (in this sample, APPC and TCP/IP listeners and the TCP/IP interrupt manager) are up

(7)

The system controller process

For UNIX-based systems other than AIX and SCO OpenServer, the db2sysc process is the only process shown for all server-side processes (for example, agents, loggers, page cleaners, and prefetchers). On Solaris, you can see these side processes with the command /usr/ucb/ps axw.