By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,778 Members | 1,074 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,778 IT Pros & Developers. It's quick & easy.

How many DB2 processes running on your Solaris server?

P: n/a
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.

Feb 27 '07 #1
Share this Question
Share on Google+
9 Replies


P: n/a
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
Feb 28 '07 #2

P: n/a
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
Feb 28 '07 #3

P: n/a
aj
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
Feb 28 '07 #4

P: n/a
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

Feb 28 '07 #5

P: n/a
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.

Feb 28 '07 #6

P: n/a
On Feb 28, 1:05 pm, "Tony" <tonyedr...@gmail.comwrote:
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

Feb 28 '07 #7

P: n/a
On Feb 28, 2:11 pm, "Tomas" <thal...@gmail.comwrote:
On Feb 28, 1:05 pm, "Tony" <tonyedr...@gmail.comwrote:
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

Feb 28 '07 #8

P: n/a
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.

Mar 1 '07 #9

P: n/a
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.comwrote:
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.

Mar 1 '07 #10

This discussion thread is closed

Replies have been disabled for this discussion.