Thanks Scott,
That's next on our list.
Hugo
-----Original Message-----
From: Scott Saunders [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 10:30 AM
To: [EMAIL PROTECTED]
Subject: RE: DB2EUG: Help!
Hugo;
Did you try shutting down all DB2 processes then checking the IPCS
processes? There may be orphan processes that are using the resources that
you need. If you do something like, after the shutdowns, ps -ef | grep db2
to see what, if anything is still running. If there are old processes, you
can try IPCLEAN to see if that clears it up. I usually re-boot the server
to ensure that there are no orphan processed.
Good luck!
Regards,
Scott Saunders, Siebel Systems, Inc.
Opinions expressed are my own and not those of my employer.
-----Original Message-----
From: Solares, Hugo [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 3:30 PM
To: [EMAIL PROTECTED]
Subject: DB2EUG: Help!
Help!
We are running a server with DB2 7.1 on AIX.
The problem is as follows:
On one server we have two instances, db2inst1 and db2inst2. We are
constantly having problems with db2inst2, but never with db2inst1. The
problems are, the inability to do table space backups, they are failing all
the time; very slow connection times off the command line (as much as 3-4
minutes to connect to a database), when we can actually connect; Capture and
Apply crashing every 3 minutes. The only error message we always get is
related to the same problem:
SQL10003C There are not enough system resources to process the request. The
request cannot be processed. SQLSTATE=57011
We've adjusted every configuration parameter we can think of at the database
and instance level. We're baffled that one instance runs perfect and the
other has so many problems. We have 50% of our disk space still available,
and 3GB of RAM. This should be enough. We are having trouble even when,
like today, there are no applications connected to the database to justify
resource drainage. We moved one of the databases that we could not connect
to, and it works perfectly on another server.
Has anyone ever seen this kind of problem? Does anyone have a
recommendation, or a particular configuration we could try?
Thanks,
Hugo Erick Solares, Ph.D.
Senior Database Architect/Analyst
[EMAIL PROTECTED]
[EMAIL PROTECTED]
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
