394 Implementing and Administering WebSphere Business Integration Server V4.2.2
there will be three distinct tables in the database for each participant. The name
of the table will be included in the relationship definition.
Many of the other tables in the ICS database do not grow continuously but are
used for temporary storage. These database tables grow and shrink. They
include: CxWIPObjects, CxWIPBlobs, CxFailedEventKeys, CxPBusObjState,
and CxPBusObjMessage. Additionally if transactional collaborations are used,
the following tables will also grow and shrink: CxAStateBusObjs,
CxCStateBusObjs, CxTransBlobs, CxCompBusObjs, and CxReposAttributes.
11.5.3 Place logs on separate device from table spaces
A basic strategy for all database storage ...