Question Re: How to query XMII_DB_MEMORY table? in Product Lifecycle Management Q&A

How to query XMII_DB_MEMORY table?

Former Member — Mon, 17 Dec 2012 14:04:41 GMT

Hi All,

I have a requirement to read the shared memory properties stored in the table 'XMII_DB_MEMORY' of the MII data source.

Can anybody tell me how to query this table?

I tried to write a SQL query but I couldnt find the XMII_DB_MEMORY table in the available tables.

Thanks in advance!

Regards,

Sowjanya

Re: How to query XMII_DB_MEMORY table?

agentry_src — Mon, 17 Dec 2012 14:31:04 GMT

Hi Sowjanya,

Why do you need to read them directly from the table or put another way, why aren't you using them as a defined property from within standard MII transaction functionality?

It seems like you are making this much harder than necessary.

Regards, Mike

Re: How to query XMII_DB_MEMORY table?

Former Member — Tue, 18 Dec 2012 06:19:26 GMT

Hi Michael,

We have to take a back up of the shared memory properties which we want to do by querying the table and storing its results.

Regards,

Sowjanya

Re: How to query XMII_DB_MEMORY table?

agentry_src — Tue, 18 Dec 2012 12:48:42 GMT

Hi Sowjanya,

The shared memory properties are stored in the underlying NW database, so making backups should be part of the maintenance of the NW installation. If you are looking for a local copy of the shared memory properties, there are easier ways to accomplish this.

It sounds like you need to question the requirement rather than try some odd way to achieve it.

Regards, Mike