By default, the message contents are stored in CLOB fields in Oracle database or NTEXT fields in Microsoft SQL Server database. It sometimes becomes inconvenient to reduce database table spaces after large amount of old messages are purged in the system. We provide an alternative message content storage option that every message content will split into multiple records of regular CHAR fields with the setting of @MSGSPLT install parameter to Y.
-
@MSGSPLT=N: Message Content is stored as a whole record in R5WSMESSAGES table's CLOB or NTEXT field. This is default setting.
-
@MSGSPLT=Y: Message Content is stored as split blocks in R5WSMESSAGELINES table's CHAR field.