Subject: | |
From: | |
Reply To: | Wilker, Heidi |
Date: | Tue, 29 Jul 2008 08:22:13 -0400 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
Hello, we have a HP-3000, using minisoft's ODBC for our Web Portal applications.
Yesterday, we received a turbo-image error, indicating our database transaction log file had reached its maximum number of user processes.
Doing some research via DBAUDIT, I discovered one of our web applications did indeed have a large number of transactions.
I found the following article on the FAQ section of the HP3000-L list:
Concurrent accessors when using database logging on the HP3000
Due to limits in MPE's internal tables, the maximum number of processes that can share a log process -- which in this case means the maximum number of processes that can open a database with modify-access -- is 1140. Beware of this on limit on large systems.
-- ChrisBartram <http://www.3k.com/twiki/bin/view/Main/ChrisBartram> - 18 May 2006
My question: If I break-out the transactions from our heaviest web application (the heaviest one is from a separate database) into a separate db transaction log file (currently one log file shares a number of different database transactions), will this help reduce the number of problems with the above mentioned limitation?
Heidi D. Wilker
Systems Analyst
Baltimore City Community College
600 East Lombard Street Bard 301-G
Baltimore, MD 21202
Office: 410-986-3257
Fax: 410-986-3277
E-mail: [log in to unmask]<mailto:[log in to unmask]>
http://www.bccc.edu
"It is in our moments of decision, that shape our destiny"
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
|
|