Viewing data in a data store

A messaging engine maintains both volatile and durable data in its data store, including messages, transaction states, and communication channel states. You can use the database tools to view data in the data store for a messaging engine.

Before you can use the ij tool to view data in an embedded Derby data store for a messaging engine, you must have stopped the messaging engine.

Volatile data is lost when a messaging engine stops, in either a controlled or an uncontrolled manner. Durable data is available after the server restarts.

In some cases, you might want to view the data in a data store; for example, to examine the messages being processed by the messaging engine.

You can use the database tools for the data store to view data in the data store for a messaging engine.

For example, if the messaging engine uses the embedded Derby database, you can use the ij tool to view request messages.

Procedure

1. Start the ij tool. On Windows complete the following sub-steps:
   1. Open a command window
   2. Change directory to profile_root\derby\bin\embedded
   3. Type ij.bat
   On non-Windows platforms, complete the following sub-steps:
   1. Open a command window
   2. Change directory to profile_root/derby/bin/embedded
   3. Type ./ij.sh
2. Open the data store for the messaging engine. Use the ij tool to complete the following sub-steps:
   1. Connect to the required database file.

      For a messaging engine, the database is stored in the directory profile_root/profiles/ profile_name/databases/com.ibm.ws.sib and has the name of the messaging engine; for example, for the default standalone profile on Windows, the database file for the messaging engine localhostNode01.server1-SCA.SYSTEM.localhostNode01Cell.Bus (for server1 on the SCA.SYSTEM bus) is:

       profile_root\profiles\default\databases\com.ibm.ws.sib\localhostNode01.server1-SCA.SYSTEM.localhostNode01Cell.Bus

   2. Use the ij tool to issue SQL commands and view data.
      1. Change directory to INSTALL_ROOT/derby/bin/embedded
      2. Type ./ij.sh
      3. Type protocol 'jdbc:derby:' ;
      4. Type connect ' profile_root/profiles/ profile_name/databases/com.ibm.ws.sib/ database_name' ;

   3. To display more help about using ij, type help ; at the ij> prompt.