Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Messages are NOT deleted from tables XI_AF_MSG and XI_AF_MSG_AUDIT

Hello,

I set the retention period to 7 days (1 week)

I also set the default ARCHIVE and DELETE jobs and ALL are working fine.

However, messages with OLD dates are NOT deleted from the tables XI_AF_MSG and XI_AF_MSG_AUDIT.

These tables 32GB in the DBD table space.

I tried to use the URL:

http://<host>:<port>/MessagingSystem/archiving/reorgdb.jsp

BUT to NO avail.

How do I DELETE or ARCHIVE these messages ?

============================================

Here are some more details on the content of the tables (I took into account 1 MONTH retention):

db2 "select count(*) from sapxi3db.XI_AF_MSG_AUDIT where STATUS='SUCC' and TIME_STAMP < '2007-09-10 00:00:00'"

-


28947

1 record(s) selected.

db2 "select count(*) from sapxi3db.XI_AF_MSG_AUDIT where STATUS='ERR' and TIME_STAMP < '2007-09-10 00:00:00'"

-


13243

1 record(s) selected.

db2 "select count(*) from sapxipdb.XI_AF_MSG where PERSIST_UNTIL < '2007-09-10 00:00:00' and STATUS='NDLV'"

-


1048

1 record(s) selected.

db2 "select count(*) from sapxipdb.XI_AF_MSG where PERSIST_UNTIL < '2007-09-10 00:00:00' and STATUS='DLVD'"

-


0

1 record(s) selected.

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question