DB is growing - RSXMB_SHOW_STATUS

[Former Member]

Dear All

My PI PRD system DB is getting grow significntly and i feel a performanse issue in the system .. based on the RSXMB_SHOW_STATUS report i got follwing results..

please let me know recomendations based on the report out comes , specially how to delte Status 03 messages from DB (Message Status: 003 Number: 7,392,572 )

Regards

Buddhike

-

---

Time Stamp Not Included

Number of Messages in Database:

8,195,322

Number of Messages in Client:

8,195,326

Number of Messages for Reorganization in Client:

8,195,367

Number of Messages to Be Archived in Client:

182,898

Number of Logically Deleted Messages in Client:

0

Number of Archived and Logically Deleted Messages in Client:

0

Message Status

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

Message Status: 001 Number: 34,756

Message Status: 002 Number: 0

Message Status: 003 Number: 7,392,572

Message Status: 004 Number: 0

Message Status: 005 Number: 0

Message Status: 006 Number: 0

Message Status: 007 Number: 0

Message Status: 008 Number: 0

Message Status: 009 Number: 2

Message Status: 010 Number: 0

Message Status: 011 Number: 0

Message Status: 012 Number: 28

Message Status: 013 Number: 0

Message Status: 014 Number: 11,546

Message Status: 015 Number: 0

Message Status: 016 Number: 0

Message Status: 017 Number: 0

Message Status: 018 Number: 0

Message Status: 019 Number: 0

Message Status: 020 Number: 0

Message Status: 021 Number: 0

Message Status: 022 Number: 715,865

Message Status: 023 Number: 37,176

Message Status: 024 Number: 0

Message Status: 025 Number: 0

Message Status: 026 Number: 0

Message Status: 027 Number: 0

Message Status: 028 Number: 0

Message Status: 029 Number: 4,059

Message Status: 030 Number: 0

Message Status: 030 Number: 0

Adapter Status

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

Adapter Status of Messages with Message Status: 003

Adapter Status: 001 Number: 1,158

Adapter Status: 002 Number: 0

Adapter Status: 003 Number: 0

03.11.2011 Program RSXMB_SHOW_STATUS 2

Adapter Status: 004 Number: 0

Adapter Status: 005 Number: 0

Adapter Status: 006 Number: 688,716

Adapter Status: 007 Number: 1,144

Adapter Status: 008 Number: 14

Adapter Status: 009 Number: 0

Adapter Status: 010 Number: 0

Adapter Status > 010 Number: 0

-

---

Edited by: Buddhike Perera on Nov 4, 2011 5:39 AM

[Former Member]

HI All

Found the answer to my own query..

Resolution Steps:-

Redusing the Retention Period of XML messages and archiving and deleting them

Running periodical Deletion job , this deltes all the completed XML messages from the DB ( you can see the message statistics from RSXB_SHOW_REORG job)

by reorgnazing my data i am in the process of redusing the DB size..

if any body wants help on this , do let me know buddhikep at gmail dot com

Regards

Buddhike

[Eoin_Kierans]

You can check the note #872388 'Troubleshooting Archiving and Deletion in PI'. Ensure that the necessary deletion jobs are running. Also check the retention periods you have set using the report RSXMB_ARCH_INTERFACES.

[Former Member]

Hi Buddhike

What are retention times for archival and deletion of processed messages?

Check this thread:

Regards,

Giuseppe