imqdbmgr(1M)

NAME

     imqdbmgr - 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 MQ per-
     sistent storage.

     The database can either  embedded  or  external.  To  use  a
     JDBC-compliant  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 ONE Message
     Queue Administrator's Guide for additional information.

     imqdbmgr supports three management subcommands.  These  sub-
     commands, and their corresponding arguments and options fol-
     low the imqdbmrg command on the command line. See USAGE  and
     OPTIONS.

     The following subcommands are supported:

     create
           Create an MQ database schema.

     delete
           Delete MQ database tables in the current data store.

     recreate
           Delete MQ database tables  and  recreate  MQ  database
           schema in the curent data store.

     The imqdbmgr subcommands support the following arguments:

     all   Indicates an embedded data store.

     tbl   Indicates an external data store.

OPTIONS

     The following options are supported:

     -b [brokerName]
           Specify the broker  instance  name  and  corresponding
           instance  configuration  properties.  If brokerName is
           not specified, the default broker instance is assumed.
           Use this option with the create,  delete  or  recreate
           subcommands.

     -D property=value
           Set system property property to value.

           Use this option with the create,  delete  or  recreate
           subcommands.

     -h | -help
           Display usage help. Execute nothing else on  the  com-
           mand line.

     -p password
           Specify the database password.

           Use this option with the create,  delete  or  recreate
           subcommands.

     -u userName
           Specify the database user name.

           Use this option with the create,  delete  or  recreate
           subcommands.

     -v | -version
           Display version information. Execute nothing  else  on
           the command line.

USAGE

     The following subcommands and associated arguments are  sup-
     ported:

     create all
           Create a new  embedded  data  store  and  MQ  database
           schema for a specified or default broker instance.

     create tbl [-u userName] [-p password]
           Create MQ database schema in an  external  data  store
           for a specified or default broker instance.

     delete tbl [-u userName] [-p password]
           Delete MQ database tables in the  current  data  store
           for a specified or default broker instance.

     recreate tbl [-u userName] [-p password]
           Delete MQ database tables  and  recreate  MQ  database
           schema  in  the  current data store for a specified or
           default broker instance.

ENVIRONMENT VARIABLES

     The following environment variables affect the execution  of
     this command:

     IMQ_JAVAHOME
           Specify the  Java  2  compatible  runtime.  When  this
           environment   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  attri-
     butes:

     ____________________________________________________________
    |       ATTRIBUTE TYPE        |       ATTRIBUTE VALUE       |
    |_____________________________|_____________________________|
    | Availability                | SUNWiqu                     |
    |_____________________________|_____________________________|

SEE ALSO

     imqadmin(1M),  imqbrokerd(1M),  imqcmd(1M),  imqusermgr(1M),
     imqkeytool(1M), imqobjmgr(1M), attributes(5)

     Sun ONE Message Queue Administrator's Guide