Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: Number of db2 processes on Linux computer

    Hi,
    system administrator told me to check out why is there so many db2 processes on DB2 Enterprice v8.2 FP11 Linux box.

    Most of them are like this:
    USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
    db2inst1 26345 0.0 1.2 151076 25712 ? S Sep16 0:31 db2agent (idle) 0

    I have executed the following commands.
    1. To check out number of all processes on Linux box:
    Code:
    ps aux |  wc -l
    Result:471

    2. To check out number of processes started by user db2inst1 (db2 instance owner):
    Code:
    ps aux | awk '$1=="db2inst1"' | wc -l
    Result:396

    3. To check out db2agent commands:
    Code:
    ps aux | awk '$1=="db2inst1" && $11=="db2agent"' | wc -l
    Result:369

    4. To check out idle db2agent commands:
    Code:
    ps aux | awk '$1=="db2inst1" && $11=="db2agent" && $12=="(idle)"' | wc -l
    Result:314

    I would like to know what is your number of processes on Linux/Unix box? To get an info if "my" number of processes are really so big as system admin told me.

    Thanks,
    Grofaty

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    For V8 of DB2, IBM was using a process model. This means that everything that DB2 does is a separate process. Every connection will have at least one process. Plus all the other processes of DB2. The numbers you are showing look about right to me.

    Note, This will change under V9, where the process model goes to a threaded model.

    Andy

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Tell your system administrator that DBA's don't work for system administrators, system administrators work for DBA's, and he should mind his own business.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •