At 08:54 AM 2004-09-17, Simpkins, Terry wrote:
>As part of our Sarbanes-Oxley compliance effort, I will be turning on
>IMAGE logging for a number of databases (over 60 of them).
>As you might guess, this means I have to increase the parameters for
>logging in SYSGEN.
>
>My question is:
>Are there any things I should "worry about" when upping the number of
>logging processes and the number of users per logging process?
>My understanding is:
>- I need to define one "user logging process" for each Image Database
>that is enabled for logging
Not necessarily. The same log process can be used to handle multiple
databases.
>- I need to set the "# of users per logging process" equal to (or
>grater than) the maximum number of concurrent DBOPENs for a database.
>
>For example, if I turn on logging for 65 Image databases, I need to set
>"# of user logging processes" greater than 65.
>If 64 of those databases have 5-10 concurrent DBOPENs, and one of them
>has 850 concurrent DBOPENs (a very busy DB indeed), then I
>must set the "# of users per logging process" equal to at least 850.
>
>Do I have this right?
Not exactly.
The number of users per logging process must be greater than the maximum
number of concurrent dbopen modes 1 thru 4 that are associated with a given
logging process.
So, if a log process is associated with, say, 5 data bases, at a given
point in time this log process can have no more than that number of total
concurrent active dbpoens (modes 1 thru 4).
Keep in mind that a single user running a single program can open one or
more databases each than once in open modes 1 thru 4.
In your example above, you would need the max. number of users per logging
process to be at least 1490 ((64x10) + 850).
> Is there a significant resource penalty for
>setting these variables overly large?
No. You should set them large.
>I will NOT be using the Image Logfiles for recovery, they are only going
>to be used to provide an audit trail for changes made to certain fields
>in
>the databases. But I am aware that I must keep an eye of discspace,
>because it can be consumed very quickly.
>
>*****************************
>Terry W. Simpkins
>Director ISIT
>Measurement Specialties
>757-766-4278
>[log in to unmask]
>*****************************
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
-------------------------------------------------------------------------------------------------
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 *
|