Performance Tuning for Content Manager

114 Performance Tuning for Content Manager

Logs and Trace

All logging will increase the load on the Library Server, so only turn on the

necessary logging or tracing to meet the business requirements (for example,

audit trails). When you turn on system administration event logging, entries are

written to the ICMSTSYSADMEVENTS table for every system change made by

the system administration client or administration APIs.

The events table grows with each logged event. To reduce the size of the events

table, you can remove the expired and unused events from the table. The

EventCode column in the events table indicates the classification of events as the

values shown in Table 5-2.

Table 5-2 Administration event codes

You can delete events from the events table by issuing the following SQL

command:

delete from ICMSTSYSADMEVENTS where eventcode <=xxx and Created <

yyyy-mm-dd-hh.mm.ss.uuuuuu

 xxx is the highest event code you wish to delete (for example. 200).

 yyyy-mm-dd-hh.mm.ss.uuuuuu is the timestamp of the oldest event you wish to

keep in the tables (for example, 2002-01-01-12.00.00.000000).

When tracing, wherever possible, set the log file and path to a different physical

disk from other system activity, such as the database logs, database table

spaces, and the Resource Manager file systems.

5.5.2 Authentication

New in Content Manager Version 8 are compiled ACLs and administrative

domains. Compiled ACLs enable Content Manager to pre-calculate a user’s

access to every defined control list when they or their components are modified.

Administrative domains enable a Content Manager system to be subdivided into

domains; this includes the users and the managed objects.

Pre-calculated access control lists speed up the control list processing during run

time. The system does the general privilege check (is this user allowed to

perform this function at all?) against the ICMSTCompiledPerm table, and then it

Value Definition

1 - 200 System administration function event codes

200 - 900 Item, document routing, and resource management function event codes

1000+ Application event codes