The answer is yes.
The limit is 1140 processes PER logid.
So, by splitting the transactions among more that one logid (ie: more
than one transaction log file) you proportionately increase the total
number of active log processes - although you are still constrained
by the 1140 max. per logid.
At 08:22 AM 08-07-29, Wilker, Heidi wrote:
>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 *
>
>
>No virus found in this incoming message.
>Checked by AVG - http://www.avg.com
>Version: 8.0.138 / Virus Database: 270.5.6/1579 - Release Date:
>7/29/2008 6:43 AM
-------------------------------------------------------------------------------------------------
Gilles Schipper
GSA Inc.
HP System Administration Specialists
300 John Street, Box 87651 Thornhill, ON Canada L3T 7R4
Voice: 905.889.3000 Fax: 905.889.3001
email: [log in to unmask] web: http://www.gsainc.com
-------------------------------------------------------------------------------------------------
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
