Sun Java System Message Queue 3.7 UR1 Administration Guide

Database Manager Utility

The Database Manager utility (imqdbmgr) sets up the database schema for a JDBC-based persistent data store. You can also use it to delete Message Queue database tables that have become corrupted or to change the data store. Table 13–11 lists the available subcommands.

Table 13–11 Database Manager Subcommands

Subcommand 

Description 

create all

Create new database and persistent store schema 

Used on embedded database systems. The broker property imq.persist.jdbc.createdburl must be specified.

create tbl

Create persistent store schema for existing database 

Used on external database systems.  

delete tbl

Delete Message Queue database tables from current persistent store 

delete oldtbl

Delete Message Queue database tables from earlier-version persistent store 

Used after the persistent store has been automatically migrated to the current version of Message Queue.  

recreate tbl

Re-create persistent store schema 

Deletes all existing Message Queue database tables from the current persistent store and then re-creates the schema.  

reset lck

Reset persistent store lock 

Resets the lock so that the persistent store database can be used by other processes.  

Table 13–12 lists the options to the imqdbmgr command.

Table 13–12 Database Manager Options

Option 

Description 

-b instanceName

Instance name of broker 

-Dproperty= value

Set broker configuration property 

See Persistence Properties for information about persistence-related broker configuration properties.

Caution: Be careful to check the spelling and formatting of properties set with this option. Incorrect values will be ignored without notification or warning.

-u name

User name for authentication 

-p password

Password for authentication [This option is deprecated and will eventually be removed. Either omit the password (so that the user will be prompted for it interactively) or use the -passfile option to specify a file containing the password. ]

-passfile path

Location of password file 

See Password Files for more information.

-v

Display version information [Any other options specified on the command line are ignored. ]

-h

Display usage help