Report RSXMB_SHOW_STATUS

[Former Member]

XI Gurus,

When you run the report RSXMB_SHOW_STATUS in PI, you get

Table Container: SXMSPMAST

Overview

========

Time Stamp Not Included

Number of Messages in Database: 1,103,664

Number of Messages in Client: 1,103,664

Number of Messages for Reorganization in Client: 1,103,664

Number of Messages to Be Archived in Client: 0

Number of Logically Deleted Messages in Client: 0

Number of Archived and Logically Deleted Messages in Client: 0

Message Status

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

Message Status: 001 Number: 0

Message Status: 002 Number: 0

Message Status: 003 Number: 985,465

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: 0

Message Status: 010 Number: 117,977

Message Status: 011 Number: 0

Message Status: 012 Number: 0

Message Status: 013 Number: 0

Message Status: 014 Number: 1

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: 211

What does these message status 1,2,3....21 stands for? Should we run DELETE program to get rid of this?

Thansk

Saurabh

[Former Member · Accepted solution]

Hi Saurabh,

Here are the message status with their corresponding descriptions :

E	1	Recorded
E	2	Being Processed
E	3	Processed successfully
E	7	Archived
E	8	Deleted
E	9	Automatic Restart
E	10	Message Branched
E	11	No Receiver Found
E	12	Recorded for Outbound Processing
E	14	System Error - Manual Restart Possible
E	16	Manual Restart
E	17	Application Error - Manual Restart Possible
E	18	System Error - After Automatic Restart
E	19	Changed Manually
E	20	Canceled - Since Already Processed
E	21	Canceled Manually

You can check the table SXMSMSTATT for the message status.

Thanks,

Pooja Pandey

[Former Member · Accepted solution]

Thanks Pooja for the prompt reply