Archiving Query in PI

[Former Member]

Hello Team,

We are planning to archive messages from our PI System. We would like to know, what data will be deleted from the Archive object BC_XMB, Is the data from this object important? If not, we can simply delete the data from system to reduce the DB growth, if not we will implement the archiving plan.

Thanks & Regards,

C V Jayachandra

[former_member185954]

Hello,

I found the note: 872388 particularly useful while trying to setup archiving / deletion for our PI systems.

The note contains links to help documentation which helps in understanding concepts.

You can find out what tables that are impacted by object BC_XMB object including the size of each table / index using transaction SARA->(Enter BC_XMB)->Click on Database Tables->Space Statistics button at the bottom

But I guess you already knew all that.

Regards,

Siddhesh

[former_member185326]

Hi Jayachandra,

If you would like to retain PI message data for a particular retention period, then you will have to select those interfaces for archiving. Archiving will be done to server file system. Those interfaces you choose for archiving & deletion (through sxmb_adm), will be archived first (based on the retention period you configure) and then those messages that are archived successfully, will be flagged for deletion & deleted from DB.

If you do not select any interface for archiving and just configure deletion, then those messages that fulfill the criteria, will be deleted from DB.

We would like to know, what data will be deleted from the Archive object BC_XMB, Is the data from this object important?

-- Message payload data is what is archived/ deleted. This is important data if you would like to re-process any 'failed' messages. If not, then you can safely re-cycle this data following the SAP recommended procedures. If you would like to search for message payload in future, you may archive it and maintain the same for longer retention periods.

You must configure archiving & deletion for PI systems, else you will have rapidly growing DB size, based on the amount of messages.

Note that, only messages of "success" and "cancelled" status will be eligible for archiving / deletion. So, that you avoid archiving/ deleting any message which could be re-processed in future.

For more info & better explanation, read: PI Archiving Conceptual Overview - Process Integration - SCN Wiki

Hope it helps.

Regards,

Shahid Ahmed