Performance Tuning for Content Manager

410 Performance Tuning for Content Manager

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

values shown in Table 14-1.

Table 14-1 Library Server events table definitions

You can delete events from the events table by performing either of these tasks:

 To delete an event for a system administration function from a Library Server,

connect to your database and use the following SQL command:

delete from ICMSTSYSADMEVENTS where eventcode <=200 and Created

< 2002-01-01-12.00.00.000000

 To delete an event for an item function from a Library Server, connect to your

database and use the following SQL command:

delete from ICMSTITEMEVENTS where eventcode <=600 and Created

< 2002-05-01-12.00.00.000000

To reclaim the file system space after you delete the events, run the database

reorganization utility on the Library Server database.

14.6 Removing log files

It is important to remember to remove log files on a regular basis when they are

no longer needed for troubleshooting or audit purposes. This prevents the log

files from become overly large, taking up unnecessarily large areas of disk, and

becoming unwieldy due to their sheer size. When the log files are removed, they

will be re-created by the particular application that created them.

Some log files cannot be deleted while the system is in use because they are

being written to. You must stop the component that is writing to the log file in order

to delete it. For a list of log files that you should regularly check the size of and if

necessary delete, see Appendix F, “Configuration and log files” on page 687.

It is especially important to remember to check on log files and remove them

when any form of tracing is enabled, because the log files will grow much more

quickly than usual. See Chapter 21, “Troubleshooting” on page 561 for more

about enabling tracing.

Value Definition

1 - 200 System administration function event codes

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

1000 + Application event codes