show store

show store store-name

Show the details of a specific store. This command can be used to get details about either a file-based store or a database store.

The store-name must be the exact name of a specific store.

This command prints a table of information described in the following table.

Heading Description
Type Type of store:
  • file indicates a file-based store.
  • dbstore indicates a database store.
Message Count The number of messages in the store.
Swapped Count The number of messages that have been swapped from process memory to the store.
Average Write Time Average time in seconds a write call takes. (Not available for asynchronous file stores.)
Write Usage The ratio between time spent within write calls and the time specified by the server_rate_interval. (Not available for asynchronous file stores.)
Access Mode

asynchronous—the server stores messages in the store using asynchronous I/O calls.

synchronous—the server stores messages in the store using synchronous I/O calls.

Message Size Total size of all messages in the store.
Swapped Size The total size of swapped messages in the store.
Headings specific to file-based stores
File File name associated with this store file, as it is set by the file parameter in the stores.conf file.
Pre-allocation Minimum The amount of disk space, if any, that is preallocated to this file.
Periodic Truncation

enabled—the EMS server occasionally truncates the store file, relinquishing unused disk space.

disabled—the EMS server does not truncate the store file to relinquish unused disk space.

Destination Defrag Batch Size The size of the batch used by the destination defrag feature.
File Size The size of the store file, including unused allocated file space.
Free Space The amount of unused allocated file space.
Fragmentation The level of fragmentation in the file.
Used Space The amount of used space in the file.
Storage Write Rate The number of bytes written per second.
Headings specific to database stores
JDBC Driver Name The name of the JDBC database server.
JDBC URL The location of the JDBC database server.
Username The username that the EMS server uses to access the database.
Dialect The SQL dialect used to construct SQL commands.