IBM Content Manager, Version 8.5.0.3

ICM library server event table log

Table 1 explains the information you see for event codes 1-208. These event codes are the system administration and logon event codes. You can disable the logging of events 1-88 and 500-522 by setting the SysAdminEventFlag value in ICMSTSYSCONTROL table to 0. To enable the logging, set the value to 1.

Table 1. System administration and logon event codes
Column name	Data type	Attribute
Event Code	Integer	NOT null
Created	Timestamp	NOT null
User ID	Char(32)	NOT null
EventData1	Varchar(254)	nullable
EventData2	Varchar(254)	nullable
EventData3	Varchar(254)	nullable
EventData4	Varchar(254)	nullable
EventData5	Varchar(254)	nullable

Table 2 explains the data provided for item events. You can set the type of logging for this table by opening the ICMSTITEMTYPEDEFS table and defining the ItemEventFlag value. ItemEventFlag is used to tell the server to log an item's history, such as when it is created, updated, and so on. The following value definitions perform the corresponding logging functions:

0 (Default): Do not log any events. Any value other than 0: Log document routing events.

The system uses bit-wise checking when determining logging for the following actions on an item:

Bit 0: Log create and reindex actions on an item.
Bit 1: Log retrieve actions on an item.
Bit 2: Log update actions on an item.
Bit 3: Log delete actions on an item.
Bit 4: Log items that are added to or removed from this hold container.; Log user attempts to delete, update, or move this item which is still in some hold container.

Table 2. Item events table
Column name	Data type	Attribute
Event Code	Integer	NOT null
Created	Timestamp	NOT null
Item ID	Char(26)	NOT null
User ID	Char(32)	NOT null
EventData1	Varchar(254)	nullable
EventData2	Varchar(254)	nullable
EventData3	Varchar(254)	nullable
EventData4	Varchar(254)	nullable
EventData5	Varchar(254)	nullable

Table 3 describes the data you might see in the event log. Event codes 1 through 999 are reserved for library server functions. Event code 1000 and greater are for user-defined functions. Event codes fall into the following categories:

System administration functions: 1 through 88
Logon functions: 201 through 209
Resource manager object events: 210, 211, 531, 539, 607, 608, 609
Item functions: 301 through 404
Document routing events: 600 through 606, 616 through 618, 622 through 630
Hold events: 631 through 635

Table 3. Library server event logging table
EventCode	EventData1	EventData2	EventData3	EventData4	EventData5
1 ADD USER	User ID	User Name	User Privilege Set	Grant Privilege Set	Default Item ACL
2 UPDATE USER	User ID	User Name	User Privilege Set	Grant Privilege Set	Default Item ACL
3 DELETE USER	User ID	N/A	N/A	N/A	N/A
4 ADD USER GROUP	Group User ID	Group Name	N/A	N/A	N/A
5 UPDATE USER GROUP	Group User ID	Group Name	N/A	N/A	N/A
6 DELETE USER GROUP	Group User ID	N/A	N/A	N/A	N/A
7 ADD ACL	ACL Code	ACL Name	Language Code	N/A	N/A
8 UPDATE ACL	ACL Code	ACL Name	Language Code	N/A	N/A
9 DELETE ACL	ACL Code	Language Code	N/A	N/A	N/A
11 INCREMENTAL UPDATE ACL	SP Name	Action	Privilege Set Code	Privilege Definition Code	N/A
12 ADD LANGUAGE	Language Code	Language Name	N/A	N/A	N/A
13 UPDATE LANGUAGE	Language Code	Language Name	N/A	N/A	N/A
14 DELETE LANGUAGE	Language Code	N/A	N/A	N/A	N/A
15 ADD PRIVILEGE	SP Name	Action	Privilege Definition Code	Privilege Definition Name	Privilege Description
16 UPDATE PRIVILEGE	SP Name	Action	Privilege Definition Code	Privilege Definition Name	Privilege Description
17 DELETE PRIVILEGE	SP Name	Action	Privilege Definition Code	N/A	N/A
19 UPDATE SYS CONTROL PARM	ACL Binding Level	Library ACL Code	Public Access Enable	Default ACL Choice	SMS Choice
21 ADD ATTRIBUTE	Language Code	Attribute ID	Attribute Name	Attribute SQL Type	Attribute Length
22 UPDATE ATTRIBUTE	Language Code	Attribute ID	Attribute Name	Attribute SQL Type	Attribute Length
23 DELETE ATTRIBUTE	Language Code	Attribute ID	N/A	N/A	N/A
24 ADD ATTRIBUTE GROUP	Language Code	Attribute Group	Attribute Group Name	N/A	N/A
25 UPDATE ATTRIBUTE GROUP	Language Code	Attribute Group	Attribute Group Name	N/A	N/A
26 DELETE ATTRIBUTE GROUP	Language Code	Attribute Group	N/A	N/A	N/A
27 ADD COLLECTION NAME	RM Code	SMS Collection Code	User ID	Prefetch Indicator	SMS Collection Name
29 DELETE COLLECTION NAME	RM Code	SMS Collection Code	N/A	N/A	N/A
33 ADD COMPONENT	Component Type ID	Component Type Name	Component Type Description	Item Type ID	Parent Component Type ID
34 UPDATE COMPONENT	Component Type ID	Component Type Name	Component Type Description	User ID	N/A
35 DELETE COMPONENT	Component Type ID	Component Type Name	Component Type Description	N/A	N/A
36 BUILD COMPONENT TYPE	Schema Name	Component Type Name	Table Name	Item Type Name	Parent Component Type Name
37 ADD ITEM TYPE	Item Type ID	Item Type Name	Item Type Description	N/A	N/A
38 UPDATE ITEM TYPE	Item Type ID	Item Type Name	Item Type Description	N/A	N/A
39 DELETE ITEM TYPE	Item Type ID	Item Type Name	Item Type Description	N/A	N/A
40 GET ITEM TYPE	Number of Item Type ID	Detail	Number of Privilege Code	N/A	N/A
41 ADD KEYWORD CLASS	Keyword Class	Keyword Code	Language Code	Keyword Name	Keyword Description
42 ADD KEYWORD CODE	Keyword Class	Keyword Code	Language Code	Keyword Name	Keyword Description
43 UPDATE KEYWORD CODE	Keyword Class	Keyword Code	Language Code	Keyword Name	Keyword Description
44 DELETE KEYWORD CODE	Keyword Class	Keyword Code	N/A	N/A	N/A
45 ADD LINK TYPE	Keyword Class	Keyword Code	Language Code	Keyword Name	Keyword Description
46 UPDATE LINK TYPE	Keyword Class	Keyword Code	Language Code	Keyword Name	Keyword Description
47 DELETE LINK TYPE	Keyword Class	Keyword Code	N/A	N/A	N/A
48 ADD PRIVILEGE SET	SP Name	Action	Privilege Set Code	Privilege Definition Code	N/A
49 UPDATE PRIVILEGE SET	SP Name	Action	Privilege Set Code	Privilege Set Name	Privilege Set Description
50 DELETE PRIVILEGE SET	SP Name	Action	Privilege Set Code	N/A	N/A
51 ADD COMPONENT VIEW	Component View ID	Component Type ID	Item Type ID	View Display Name	User ID
52 UPDATE COMPONENT VIEW	Component View ID	Component View Name	User ID	N/A	N/A
53 DELETE COMPONENT VIEW	Component View ID	Component View Name	Language Code	N/A	N/A
54 ADD ITEMTYPE VIEW	Item View ID	Item Type ID	ACL Code	Language Code	User ID
55 UPDATE ITEMTYPE VIEW	Item View ID	Item Type View Name	Language Code	N/A	N/A
56 DELETE ITEMTYPE VIEW	Item View ID	Language Code	N/A	N/A	N/A
57 ADD EVENT TYPE	Keyword Class	Keyword Code	Language Code	Keyword Name	Keyword Description
58 UPDATE EVENT TYPE	Keyword Class	Keyword Code	Language Code	Keyword Name	Keyword Description
59 DELETE EVENT TYPE	Keyword Class	Keyword Code	N/A	N/A	N/A
60 ADD SEMANTIC TYPE	Keyword Class	Keyword Code	Language Code	Keyword Name	Keyword Description
61 UPDATE SEMANTIC TYPE	Keyword Class	Keyword Code	Language Code	Keyword Name	Keyword Description
62 DELETE SEMANTIC TYPE	Keyword Class	Keyword Code	N/A	N/A	N/A
63 ADD XDO TYPE	XDO Class ID	Attribute Group ID	XDO Class Name	N/A	N/A
64 UPDATE XDO TYPE	XDO Class ID	Attribute Group ID	XDO Class Name	N/A	N/A
65 DELETE XDO TYPE	XDO Class ID	N/A	N/A	N/A	N/A
66 ADD PRIVILEGE GROUP	Language Code	Privilege Group Code	Privilege Group Name	Privilege Group Description	Number of Privileges
67 UPDATE PRIVILEGE GROUP	Language Code	Privilege Group Code	Privilege Group Name	Privilege Group Description	N/A
68 DELETE PRIVILEGE GROUP	Language Code	Privilege Group Code	N/A	N/A	N/A
69 ADD SET ACL	ACL Code	User ID	User Kind	Privilege Set Code	N/A
70 UPDATE SET ACL	ACL Code	User ID	User Kind	Privilege Set Code	N/A
71 DELETE SET ACL	ACL Code	User ID	N/A	N/A	N/A
72 ADD COMPONENT ATTR	SP Name	Language Code	Component Type ID	Number of Attributes	N/A
73 ADD INDEX ON COMPONENT	SP Name	Action	Index Name	Component Type ID	Number of Attributes
74 DELETE INDEX ON COMP0NENT	SP Name	Action	Index Name	N/A	N/A
75 ADD ITEM RELATION	Source Item Type ID	Target Item Type ID	N/A	N/A	N/A
76 UPDATE ITEM RELATION	Source Item Type ID	Target Item Type ID	N/A	N/A	N/A
77 DELETE ITEM RELATION	Source Item Type ID	Target Item Type ID	N/A	N/A	N/A
78 ADD ADMIN DOMAIN	Domain ID	Domain Name	Language Code	N/A	N/A
79 UPDATE ADMIN DOMAIN	Domain ID	Domain Name	Language Code	N/A	N/A
80 DELETE ADMIN DOMAIN	Domain ID	Language Code	N/A	N/A	N/A
81 ADD DOMAIN ACL	Domain ID	Number of ACL	N/A	N/A	N/A
82 DELETE DOMAIN ACL	Domain ID	Number of ACL	N/A	N/A	N/A
83 ADD DOMAIN PRIVILEGE SET	Domain ID	Number of Privilege Set	N/A	N/A	N/A
84 DELETE DOMAIN PRIVILEGE SET	Domain ID	Number of Privilege Set	N/A	N/A	N/A
85 CHANGE USER PASSWORD	User ID	Expiration Date	User Name	N/A	N/A
86 ADD AUTO LINK	Target Item Type Name	Source Item Type Name	N/A	N/A	N/A
87 UPDATE AUTO LINK	Target Item Type Name	Source Item Type Name	N/A	N/A	N/A
88 DELETE AUTO LINK	Target Item Type Name	Source Item Type Name	N/A	N/A	N/A
201 LOGON	User ID	Event Time ddhhmmssmsms	Application	Password Flag	N/A
202 LOGOFF	User ID	N/A	N/A	N/A	N/A
203 LOGON INVALID USERID	User ID	Event Time	Application	N/A	N/A
204 LOGON INVALID PASSWORD	User ID	Event Time	Application	N/A	N/A
205 LOGON MAX USERS REACHED	User ID	Event Time	Application	N/A	N/A
206 LOG MAX USER ERROR REACHED	User ID	Event Time	Application	N/A	N/A
207 LOGON PASSWORD CHANGED	User ID	Event Time	Application	N/A	N/A
208 LOGON USER EXIT ERROR	User ID	Event Time	Application	N/A	N/A
209 USERCOUNT	User count	N/A	N/A	N/A	N/A
210 RMNOTAVAILABLE	"RM `RMCODE` `ADDRESS` port `PORT NUMBER` -- Changed to NOT AVAILABLE"	N/A	N/A	N/A	N/A
211 RMAVAILABLE	"RM `RMCODE` `ADDRESS` port `PORT NUMBER` -- Changed to AVAILABLE"	N/A	N/A	N/A	N/A
216 ADD RETENTION POLICY	Policy ID	Policy Name	Policy Description	N/A	N/A
217 UPDATE RETENTION POLICY	Policy ID	Action type	Action success or failure	Old and new value for a change action	IDs of the impacted item types
218 DELETE RETENTION POLICY	Policy ID	Action success or failure	Reason for failure	N/A	N/A
219 UPDATE ITEM TYPE RETENTION	Item type name	Action name	Action success or failure	Policy ID for the action	N/A
301 CREATE ITEM	Item Type ID	N/A	N/A	N/A	N/A
302 UPDATE ITEM	Old Version ID	New Version ID	Item Type Name	N/A	N/A
303 DELETE ITEM (regular)	Delete Version ID	Document deleted	N/A	N/A	N/A
303 DELETE ITEM (reindex)	Delete Version ID	Item Type ID	reindex	N/A	N/A
305 UPDATE OBJECT DATA	Version ID	Ext Object Name	Resource Length	N/A	N/A
306 REINDEX ITEM	Item Type Name	N/A	N/A	N/A	N/A
401 GET ITEM	Component ID	Component View Name	Item Type View Name	N/A	N/A
531 RETRIEVE OBJECT	Part version ID	Document item ID	Document version ID	resource manager name	N/A
539 SETUP RM FLAG	RM Name	N/A	N/A	N/A	N/A
600 DR START PROCESS	Process Name	Work Node Name	N/A	Work Package Component ID	N/A
601 DR ROUTE ITEM	Process Name	Work Node Name	Next Work Node Name	Work Package Component ID	N/A
602 DR END PROCESS	Process Name	Work Node Name	N/A	Work Package Component ID	Normal process completion or Abnormal process completion
605 DR OVERLOAD	Process Name	Work Node Name	Number of Work Packages Currently in Work Node	Work Package Component ID	N/A
606 DR WORKNODE PASSTHROUGH	Process Name	Work Node Name	N/A	N/A	N/A
607 ADD REPLICA RULES	Source RM Name	Target SMS Collection Code	Number of Replica Rules	N/A	N/A
608 DELETE REPLICA RULES	Source RM Name	Target SMS Collection Code	Number of Replica Rules	N/A	N/A
609 UPDATE REPLICA RULES	Source RM Name	Target SMS Collection Code	Number of Replica Rules	N/A	N/A
610 DR ADD ACTION	Action Code	Action Name	Language Code	Predefine Action	N/A
611 DR UPDATE ACTION	Action Code	Action Name	Language Code	Predefine Action	N/A
612 DR DELETE ACTION	Action Code	Language Code	N/A	N/A	N/A
613 DR ADD ACTIONLIST	SP Name	Action	Action List	N/A	N/A
614 DR UPDATE ACTIONLIST	SP Name	Action	Action List	Action List Name	Action List Description
615 DR DELETE ACTIONLIST	SP Name	Action	Action List	N/A	N/A
616 DR SUSPEND WORKPACKAGE	Process name	Work node name	Expiration time set for this work package, if applicable	Work Package Component ID	N/A
617 DR RESUME WORKPACKAGE	Process name	Work node name	N/A	Work Package Component ID	N/A
618 DR AUTOMATIC RESUME WORKPACKAGE	Process name	Work node name	N/A	Work Package Component ID	N/A
622 DR ADD WORKNODE	Item type ID	N/A	N/A	N/A	N/A
623 DR UPDATE WORKNODE	Old version ID	New version ID	Item type ID	N/A	N/A
624 DR DELETE WORKNODE	Version ID	Item deleted	N/A	N/A	N/A
625 DR ADD WORKLIST	Item Type ID	N/A	N/A	N/A	N/A
626 DR UPDATE WORKLIST	Old version ID	New version ID	Item type ID	N/A	N/A
627 DR DELETE WORKLIST	Version ID	Item deleted	N/A	N/A	N/A
628 DR ADD WORKPROCESS	Item type ID	N/A	N/A	N/A	N/A
629 DR UPDATE WORKPROCESS	Old version ID	New version ID	Item type ID	N/A	N/A
630 DR DELETE WORKPROCESS	Version ID	Item deleted	N/A	N/A	N/A
631 ADD HOLD	Hold Container Item ID	Version (0 all-versions)	N/A	N/A	N/A
632 REMOVE HOLD	Hold Container Item ID	Version (0 all-versions)	N/A	N/A	N/A
633 DELETE HOLD ITEM	Version ID	N/A	N/A	N/A	N/A
634 UPDATE HOLD ITEM	Version ID	N/A	N/A	N/A	N/A
635 MOVE HOLD ITEM	Version ID	N/A	N/A	N/A	N/A
636 OVERRIDE RETENTION DATE	Version ID (-1 if override all applicable versions)	Type of overridden date	Type of successful or failed action	Original and overridden values	N/A
637 ATTEMPT TO DELETE RETAINED ITEM	Version ID (-1 if user attempt to delete all versions)	N/A	N/A	N/A	N/A
638 ATTEMPT TO UPDATE RETAINED ITEM	Version ID	N/A	N/A	N/A	N/A
639 ATTEMPT TO MOVE RETAINED ITEM	Version ID (always -1 since all versions would be moved)	N/A	N/A	N/A	N/A