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(db2sy sc) running at the
same time. Is that normal?
Thanks. 9 5179
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(db2sy sc) 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(db2sy sc) 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(db2sy sc) 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(db2sy sc) 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...@gma il.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
On Feb 28, 2:11 pm, "Tomas" <thal...@gmail. comwrote:
On Feb 28, 1:05 pm, "Tony" <tonyedr...@gma il.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
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...@gma il.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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Michael Williams |
last post by:
Hi,
I am trying to understand the performance implications of running a
number of separate ActiveXexe processes as opposed to a single
ActiveXexe with multiple threads on a Windows 2000 server.
I have been told that Windows does not allocate a fixed memory space
to its processes, so they are always paged off to disk when inactive.
However, all the threads in a single process operate within the same
memory space, so are relatively...
|
by: Behrang Dadsetan |
last post by:
Hi all,
please note that once I finished writing the script someone explained me
that there is a command pwait under Solaris... anyway it was fun to
write and it did not take long (while I am not a python guru..). And my
version is MUUUCH better :)
Is there no standard interfaces to the process table? I only found
examples of how to do it on the win32 platform. So I parse with re the
|
by: Bob Swerdlow |
last post by:
My application starts up a number of processes for various purposes using:
self.popen = popen2.Popen3("/usr/local/bin/python -O "myscript.py")
and then shuts them down when appropriate with
os.kill(self.popen.pid, signal.SIGTERM)
Everything works fine on MacOSX. However, I'm doing a port to Solaris (so I
can run it on my web site) and find that the child processes are not
stopping! Solaris is creating TWO new processes: one for the SHELL...
|
by: murray_shane56 |
last post by:
We currently have a routine that "forks" out (to use the unix term)TSQL
commands to run asynchronously via SQL Agent jobs. Each TSQL command
gets its own Job, and the job starts immediately after creation.
Sometimes we can have too many of these jobs running at the same, and
the box crawls to a slow speed until the jobs finish up.
Is there a way we can limit the number of active jobs running under the
SQL Agent at one time? Or is...
|
by: _link98 |
last post by:
Which of the UDB 8.2.2 ESE unix executables really need to
gain root privilege while they are running?
In my installation, the db2sysc file is owned by the instance-owner
(and relevant admin group ownership), but when the db2-instance starts
running (manually started via "su" as the instance-owner),
the db2sysc process requests root access.
I think that db2fmcd also requests root privilege.
| |
by: AN |
last post by:
Greetings,
We make an ASP.NET web application and we host it for our customers. We
have provisioned hardware and hope to be able to service around 200
customers on this hardware. The web servers are in a stateless farm and
have 2 GB of RAM. We are using ASP.NET 1.1 when using a dedicated
application pool for each virtual directory. Each customer gets their own
virtual directory and copy of the ASP.NET dll in their bin folder, which...
|
by: Simon Hart |
last post by:
Does anyone know the standard code access permission to be able to
manipulate a process using the Process class?
Thanks
Simon.
|
by: paul.herger |
last post by:
We are running DB2 V8 on Solaris 9. Last week we upgraded from FP7 to
FP13. Everything seemed to be fine, but yesterday we were confronted
with a strange behavior of the DB2 governor.
An application server process was forced by the governor with this log
message:
2006-10-23-12.51.43 0 FORCE applname `panh030` authid `ARNRUN`
applid C0A80401.O256.03A012212902` coord 0 (line 56) ET 4294967295
|
by: walterbyrd |
last post by:
I understand that Python has them, but PHP doesn't.
I think that is because mod_php is built into apache, but mod_python
is not usually in apache. If mod_python was built into apache, would
python still have long running processes (LRP)?
Do LRPs have to do with a Python interpreter running all the time? Or
is it something else?
I also understand that LRPs are the reason that shared hosting is less
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |