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 begin
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.
About this task
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
- Start the ij tool. On
non-Windows® platforms,
complete the following sub-steps:
- Open a command window
- Change directory to profile_root/derby/bin/embedded
- Type ./ij.sh
- Open the data store for the messaging engine. Use the
ij tool to complete the following sub-steps:
- 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
- Use the ij tool to issue SQL
commands and view data.
- Change directory to install_root/derby/bin/embedded
- Type ./ij.sh
- Type protocol 'jdbc:derby:' ;
- Type connect 'profile_root/profiles/profile_name/databases/com.ibm.ws.sib/database_name' ;
- Optional: To display more help about using ij,
type help ; at the ij> prompt.