RZ0 MTE for monitoring table has reached partitions

[Former Member]

Hi,

In ST04 -> under alert, I can see one red error error - table has reached 881 partitions and the allowed max partitions is 1000. There is a note 1688108, I have implement to resolve this issue.

I want to find-out is there any MTE in RZ20 to monitor and trigger notification for these kind of alerts?

[Former Member]

Hi,

Try this if it helps.

CCMS_ORA_space_seg_exts_pfcl

SID\Oracle\Space management\Segments\Most allocated extents in any segment

Thanks

Rishi abrol

[Former Member]

Thanks Rishi, but I am looking for the SQL server not the oracle. I thread is under SQL Server as well.

[Former Member]

Hi,

I dont have MSSQL server with me.but i can help you find the MTE.

If the database is SQL you can go to database thread that you see.

Or

Go in Rz21 try to select Properties assigned to MTE classes and Display overview and find "exts"

That Should be the MTE.

Let me know the value of it.

If still you don't get it please let me know.

Thanks

Rishi Abrol

[Sriram2009]

Hi Sunil

Could you check this SAP Notes

705569  - BPMon: Important Msg's in Activation and Generation Protocol

110368  - FAQ - CCMS MONITORING INFRASTRUCTURE

Regards

Sriram