MEMPROPERTIES System Table Description

The MEMPROPERTIES pseudo table provides information about the current values of system properties available on the Transaction Engine (TE) executing the query. The current valid values of system properties are provided in the PROPERTIES system table. If system properties are changed on one TE, the used values of system properties on other TEs can differ until the values are synchronized during the periodic or explicit garbage collection.

For more information, see Request Garbage Collection.