To Display Information About a JDBC-Based Data Store

You can display information about a JDBC-based data store using the Database Manager utility (imqdbmgr) as follows:

1. Change to the directory where the Database Manager utility resides, depending on how Message Queue was installed:

   IPS packages: cd IMQ_HOME/bin

   
   

   Solaris SVR4 packages: cd /usr/bin

   
   

   Linux RPM packages: cd /opt/sun/mq/bin

   
   

2. Enter the imqdbmgr command:

      
   imqdbmgr query
   

   The output should resemble the following

   dbmgr query
   
   [04/Oct/2005:15:30:20 PDT] Using plugged-in persistent store:
           version=400
           brokerid=Mozart1756
           database connection url=jdbc:oracle:thin:@Xhome:1521:mqdb
           database user=scott
   Running in standalone mode.
   Database tables have already been created.