Archiving vs Deleting messages in PI/XI

[Former Member]

Hi, I have successfully set up archiving on the PI system. No separate delete jobs are running, only the delete job in the connection with the archive process.

The questions is, will archiving delete and keep the DB from growing as good as the delete jobs would? Yes, the archive files need some space on the filesystem, but it seems that only archiving is enough to keep PI in a healthy state concerning the DB size. Am I correct?

[Former Member]

Anyone?

[aashish_sinha]

Hi,

In XI All the data are transferred in form of messages and it may necessary to Archive data for future references .When we do the Archiving all the processed messages will be out of system and also it improves the performance. In General Rule the messages are multiplied into 10 times when compared to data which is sent,(Ex. If the data is 1 MB, the size of the message will be 10 MB.

Messages that have been processed correctly are deleted by default. You must archive all messages that are not to be deleted. Since correctly processed messages are flagged as either To Be Archived or To Be Deleted (and because this indicator cannot be changed), you must decide which messages you want to archive before the first message is processed.

History entries are spots for observing XML message processing. They are generated by persisting at the end of a processing step for an XML message and contain the current status and the execution date.

History entries remain in the database for an unspecified length of time and must be deleted at some stage so that the database table does not overflow. The deletion process only deletes history entries for XML messages that have already been archived or deleted. The history entry is kept in the database for at least seven days after an XML message has been deleted. This is necessary since history entries are also required for the quality of service Exactly Once.

The default retention period is 30 days.

Regards

Aashish Sinha

PS : reward points if helpful