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.

Tony wrote:
> 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.
>

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

Tony wrote:
> 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.
>

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

Michael

Jan M. Nelken wrote:
> Tony wrote:
>> 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.
>>
>
> 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

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

aj wrote:
> Jan M. Nelken wrote:
>> Tony wrote:
>>> 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.
>>>
>>
>> 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
>
> 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?

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

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.

On Feb 28, 1:05 pm, "Tony" <tonyedr...@gmail.com> wrote:
> 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

On Feb 28, 2:11 pm, "Tomas" <thal...@gmail.com> wrote:
> On Feb 28, 1:05 pm, "Tony" <tonyedr...@gmail.com> wrote:
>
> > 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

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

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.

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

/T

On Mar 1, 6:19 am, "Tony" <tonyedr...@gmail.com> wrote:
> 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.