You can display information about a JDBC-based data store using the Database Manager utility (imqdbmgr) as follows:
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
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.