To maintain the operating efficiency of WebSphere Business Integration Connect, the following procedures can be used to archive or purge the file system and database log files.
Application log files are located in three areas: $INSTALLATION_DIRECTORY/<receiver, console, and router>/was/logs/server1.
Non-repudiation files and directories are located in: $COMMON_DIRECTORY/non_rep/. Start with archiving the oldest files located in directories starting at 0, and increasing in number for newer files.
Certain database tables may be purged when necessary, but other tables must not be modified in order to maintain proper system functionality. Tables starting with BP_ and LG_ may be purged with two exceptions: BP_ tables ending with _QUE and _HIST are continuously maintained by the RosettaNet engine and must not be changed. The BP_ tables ending with _QUE are queue tables, and the BP_ tables ending with _HIST are history tables which are used for archiving. For example, the BP_RNSTATEHDR_QUE table is archived in the BP_RNSTATEHDR_HIST table.
Tables starting with CG_ and PR_ contain configuration or profile data and must also remain unchanged in order to maintain proper system functionality.
The criterion for purging table data is based upon the number of days that data must be kept online. Data in tables that end with _HIST are archived and purged on a daily basis. Also, any log information is truncated daily.
The purge criterion contains only one input parameter, p_days, which is the
number of days that data should be kept online. Once the DBA sets the
input parameter, the procedure works as follows:
Table | History table | Action |
---|---|---|
RosettaNet
|
|
|
BP_rnStateHdr
|
BP_rnStateHdr_Hist
|
Purge
|
BP_rnStateDtl
|
BP_rnStateDtl_Hist
|
Purge
|
BP_Sponsor_State
|
BP_Sponsor_State_Hist
|
Purge
|
BP_rnStateHdrAuditLog
|
none
|
Truncate
|
AS1/AS2
|
|
|
BP_State_Hdr
|
BP_State_Hdr_Hist
|
Purge
|
BP_AS_State_Hdr
|
BP_AS_State_Hdr_Hist
|
Purge
|
BP_AS_State_Dtl
|
BP_AS_State_Dtl_Hist
|
Purge
|
The procedure purges data based upon the combination of the record creation date in the header and the p_days input parameter. The Time to perform TPA stored in the header is not considered. It is the responsibility of the DBA to make sure that p_days is larger than the maximum value of (Time to perform/1440). Time to perform is stored in minutes.
It is recommended that data in the BP_ tables be retained online for p_days or ((TimeToPerform/1440) +1 day), whichever is greater. Data in tables BP_DupCheck and BP_RnMsgDigest should be retained for seven days. Data in BP_Process_Log should be retained for two days.
Tables with names starting with DB are metadata tables except DB_ProcAuditLog. If DB_ProcAuditLog is on, it should be purged or truncated daily, or done based on the needs of the user. This log is normally turned off for production since it is primarily used in development and QA environments.
Tables with names starting with LG_ are log and summary tables with the exception of: LG_EventCd, LG_Media, and LG_media_Cfg. These are metadata tables and must remain unchanged in order to maintain proper system functionality. Tables starting with LG_Access_ are not used in 4.2.1 and 4.2.2.
The following log tables can be archived and purged based upon Activity ID, and the driving table should be LG_Activity. The createdate or RcvDocTS can be used to determine the number of days that data should be retained online. RcvDocTS may be a better option because it is an indexed column. Data can remain online for seven days or ((TimeToPerform/1440) +1 day), whichever is greater.
The following log tables can be purged based on creation date.
The following summary tables must remain unchanged in order to maintain proper system functionality.