imqdbmgr(1M) System Administration Commands imqdbmgr(1M)NAMEimqdbmgr - manage a plugged-in JDBC-compliant Message Queue data store
SYNOPSIS
/usr/bin/imqdbmgr subcommand argument [ [option...]]
/usr/bin/imqdbmgr -h | -help
/usr/bin/imqdbmgr -v | -version
DESCRIPTION
The imqdbmgr utility creates and manages a Java DataBase Connectivity
(JDBC) compliant database used for Message Queue persistent storage.
The database can be either embedded or external. To use a JDBC-compli‐
ant database (and the imdbmgr utility), you need to first set a number
of JDBC-related properties in the broker instance configuration file.
See the Sun Java System Message Queue Administrator's Guide for addi‐
tional information.
imqdbmgr supports four management subcommands. These subcommands, and
their corresponding arguments and options follow the imqdbmgr command
on the command line. See USAGE and OPTIONS.
The following subcommands are supported:
create Create a Message Queue database schema.
delete Delete Message Queue database tables in the current data
store.
recreate Delete Message Queue database tables and recreate Message
Queue database schema in the curent data store.
reset Reset the database table lock to allow other processes to
access database tables.
The imqdbmgr subcommands support the following arguments:
all Indicates the subcommand applies to the data store, as well
as the database tables.
lck Indicates the subcommand applies to the database table lock.
oldtbl Indicates the subcommand applies to an older version of the
database tables.
tbl Indicates the subcommand applies to the database tables only.
OPTIONS
The following options are supported:
-b brokerName Specify the broker instance name and corresponding
instance configuration properties. If this option
is not specified, the default broker instance is
assumed.
Use this option with the create, delete, recreate,
or reset subcommands.
-D property=value Set system property property to value.
Use this option with the create, delete, recreate,
or reset subcommands.
-h | -help Display usage help. Execute nothing else on the
command line.
-p password Specify the database password.
Use this option with the create, delete, recreate,
or reset subcommands.
-u userName Specify the database user name.
Use this option with the create, delete, recreate,
or reset subcommands.
-v | -version Display version information. Execute nothing else
on the command line.
USAGE
The following subcommands and associated arguments are supported:
create all
Create a new embedded data store and Message Queue database schema
for a specified or default broker instance.
create tbl [-u userName] [-p password]
Create Message Queue database schema in an existing data store for
a specified or default broker instance.
delete tbl [-u userName] [-p password]
Delete Message Queue database tables in the current data store for
a specified or default broker instance.
delete oldtbl [-u userName] [-p password]
Delete the earlier version of Message Queue database tables. Used
after the data store has been automatically migrated to the current
version of Message Queue.
recreate tbl [-u userName] [-p password]
Delete Message Queue database tables and recreate Message Queue
database schema in the current data store for a specified or
default broker instance.
reset lck
Reset the database table lock to allow other processes to access
database tables.
ENVIRONMENT VARIABLES
The following environment variables affect the execution of this com‐
mand:
IMQ_JAVAHOME Specify the Java 2 compatible runtime. When this envi‐
ronment variable is not set it defaults to /usr/j2se.
EXIT STATUS
The following exit values are returned:
0 Successful completion.
>0 An error occurred.
FILES
/var/imq/instances/brokerName/dbstore
Recommended directory in which to create an embedded database.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
┌─────────────────────────────┬─────────────────────────────┐
│ ATTRIBUTE TYPE │ ATTRIBUTE VALUE │
├─────────────────────────────┼─────────────────────────────┤
│Availability │SUNWiq │
└─────────────────────────────┴─────────────────────────────┘
SEE ALSOimqadmin(1M), imqbrokerd(1M), imqcmd(1M), imqusermgr(1M), imqkey‐
tool(1M), imqobjmgr(1M), attributes(5)
Sun Java System Message Queue Administrator's Guide
SunOS 5.11 29 Mar 2004 imqdbmgr(1M)
