How many DB2 processes running on your Solaris server?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tony - 27 Feb 2007 22:11 GMT

Hi all,

I have a DB2 8.2(fk14) running on Solaris 9 server. Once the DB2
working, I can see more than 30 DB2 processes(db2sysc) running at the
same time. Is that normal?

Thanks.

Reply to this Message

Jan M. Nelken - 27 Feb 2007 23:58 GMT

> Hi all,
>
[quoted text clipped - 3 lines]
>
> Thanks.

On UNIX systems other than AIX(R) 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 systems, you can see these side
processes with the command /usr/ucb/ps axw.

Jan M. Nelken

Reply to this Message

aj - 28 Feb 2007 13:27 GMT

>> Hi all,
>>
[quoted text clipped - 10 lines]
>
> Jan M. Nelken

I'm on RHAS 2.1 (linux). If:
> the db2sysc process is the only process shown for all
> server-side processes (for example, agents, loggers, page
> cleaners, and prefetchers)
then why do I see processes (with ps command) such as:
db2pclnr (Page Cleaner)
db2pfchr (Pre Fetcher)
db2agent (Coordinator Agent)
db2loggw (Log Writer)
???

Plus, what I think the OP is asking is: is it normal to see
30 db2syscs?

aj

Reply to this Message

Jan Nelken - 28 Feb 2007 19:26 GMT

>>> Hi all,
>>>
[quoted text clipped - 25 lines]
> Plus, what I think the OP is asking is: is it normal to see
> 30 db2syscs?

It is normal to see 30 db2sysc if there are 30 instances creeated and active for
example.

On Solars - which is what the OP is asking for - there are special commands to
show server side processes:

/usr/ucb/ps axw

or:

db2ptree

or:

db2_local_ps

Jan M. Nelken

Reply to this Message

Michael Rudolph - 28 Feb 2007 08:38 GMT

> Hi all,
>
[quoted text clipped - 3 lines]
>
> Thanks.

Perhaps this link is helpful
http://www-1.ibm.com/support/docview.wss?uid=swg21008571

Michael

Reply to this Message

Tony - 28 Feb 2007 21:05 GMT

Thanks all.I do ask " is it normal to see 30 db2syscs?".

If you are using Solaris, please let me know how many db2syscs process
running in your system using "db2_ps" command.

Reply to this Message

Tomas - 28 Feb 2007 22:11 GMT

> Thanks all.I do ask " is it normal to see 30 db2syscs?".
>
> If you are using Solaris, please let me know how many db2syscs process
> running in your system using "db2_ps" command.

Our production DB2 V8 FP7a, Solaris 8 shows the following:

db2_ps | grep db2sysc | wc -l
943

/T

Reply to this Message

Tomas - 28 Feb 2007 22:13 GMT

> > Thanks all.I do ask " is it normal to see 30 db2syscs?".
>
[quoted text clipped - 7 lines]
>
> /T

Oh, and another point - as Jan has pointed out, they're not all
actually db2sysc, as in the system controller, processes. Use
db2ptree to see what they actually are. Only one of our many
processes is an 'actual' db2sysc:

$ db2ptree | wc -l
982

$ db2ptree | grep db2sysc | wc -l
1

Reply to this Message

Tony - 01 Mar 2007 14:19 GMT

really? you can see 943 db2sysc processes using db2_ps,WOW. how many
instance you have? I believe it must have lots of users/applications
connecting to the DB2. For us, we only have 1 instance, and 1
application uses it.

BTW, I know the db2ptree shows the detail threads info, always 1
db2sysc. Our system administrator doesn't care about it, only ask me
why the DB2 take so many process resources.

Thanks Tomas for your info.

Reply to this Message

Tomas - 01 Mar 2007 21:38 GMT

One instance, one database. 16 application servers using connection
pooling - we get to see a lot of (mostly idle) connections!

/T

> really? you can see 943 db2sysc processes using db2_ps,WOW. how many
> instance you have? I believe it must have lots of users/applications
[quoted text clipped - 6 lines]
>
> Thanks Tomas for your info.

Reply to this Message