HP3000-L Archives

July 2008, Week 5

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Maximum user processes for logging
From:
"Johnson, Tracy" <[log in to unmask]>
Reply To:
Johnson, Tracy
Date:
Tue, 29 Jul 2008 09:20:42 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (89 lines) 
Sounds like a subtle hint to buy more HP3000s (so you can have less
users per DB.  :O )

Some places have turned on DB logging to meet SOX requirements.  With
growth, they are pushing the limits of this utility.

Tracy Johnson
Measurement Specialties Inc.
BT






NNNN  

> -----Original Message-----
> From: HP-3000 Systems Discussion 
> [mailto:[log in to unmask]] On Behalf Of Wilker, Heidi
> Sent: Tuesday, July 29, 2008 8:22 AM
> To: [log in to unmask]
> Subject: [HP3000-L] Maximum user processes for logging
> 
> 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 *
> 

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2