imqdbmgr(1m)

1imqdbmgr(1M)            System Administration Commands            imqdbmgr(1M)
2
3
4

NAME

6       imqdbmgr - manage a plugged-in JDBC-compliant Message Queue data store
7

SYNOPSIS

9       /usr/bin/imqdbmgr subcommand argument [ [option...]]
10
11
12       /usr/bin/imqdbmgr -h | -help
13
14
15       /usr/bin/imqdbmgr -v | -version
16
17

DESCRIPTION

19       The  imqdbmgr  utility creates and manages a Java DataBase Connectivity
20       (JDBC) compliant database used for Message Queue persistent storage.
21
22
23       The database can be either embedded or external. To use a  JDBC-compli‐
24       ant  database (and the imdbmgr utility), you need to first set a number
25       of JDBC-related properties in the broker instance  configuration  file.
26       See  the  Sun Java System Message Queue Administrator's Guide for addi‐
27       tional information.
28
29
30       imqdbmgr supports four management subcommands. These  subcommands,  and
31       their  corresponding  arguments and options follow the imqdbmgr command
32       on the command line. See USAGE and OPTIONS.
33
34
35       The following subcommands are supported:
36
37       create      Create a Message Queue database schema.
38
39
40       delete      Delete Message Queue database tables in  the  current  data
41                   store.
42
43
44       recreate    Delete  Message  Queue database tables and recreate Message
45                   Queue database schema in the curent data store.
46
47
48       reset       Reset the database table lock to allow other  processes  to
49                   access database tables.
50
51
52
53       The imqdbmgr subcommands support the following arguments:
54
55       all       Indicates  the  subcommand applies to the data store, as well
56                 as the database tables.
57
58
59       lck       Indicates the subcommand applies to the database table lock.
60
61
62       oldtbl    Indicates the subcommand applies to an older version  of  the
63                 database tables.
64
65
66       tbl       Indicates the subcommand applies to the database tables only.
67
68

OPTIONS

70       The following options are supported:
71
72       -b brokerName        Specify the broker instance name and corresponding
73                            instance configuration properties. If this  option
74                            is  not  specified, the default broker instance is
75                            assumed.
76
77                            Use this option with the create, delete, recreate,
78                            or reset subcommands.
79
80
81       -D property=value    Set system property property to value.
82
83                            Use this option with the create, delete, recreate,
84                            or reset subcommands.
85
86
87       -h | -help           Display usage help. Execute nothing  else  on  the
88                            command line.
89
90
91       -p password          Specify the database password.
92
93                            Use this option with the create, delete, recreate,
94                            or reset subcommands.
95
96
97       -u userName          Specify the database user name.
98
99                            Use this option with the create, delete, recreate,
100                            or reset subcommands.
101
102
103       -v | -version        Display  version information. Execute nothing else
104                            on the command line.
105
106

USAGE

108       The following subcommands and associated arguments are supported:
109
110       create all
111
112           Create a new embedded data store and Message Queue database  schema
113           for a specified or default broker instance.
114
115
116       create tbl [-u userName] [-p password]
117
118           Create  Message Queue database schema in an existing data store for
119           a specified or default broker instance.
120
121
122       delete tbl [-u userName] [-p password]
123
124           Delete Message Queue database tables in the current data store  for
125           a specified or default broker instance.
126
127
128       delete oldtbl [-u userName] [-p password]
129
130           Delete  the  earlier version of Message Queue database tables. Used
131           after the data store has been automatically migrated to the current
132           version of Message Queue.
133
134
135       recreate tbl [-u userName] [-p password]
136
137           Delete  Message  Queue  database  tables and recreate Message Queue
138           database schema in the  current  data  store  for  a  specified  or
139           default broker instance.
140
141
142       reset lck
143
144           Reset  the  database  table lock to allow other processes to access
145           database tables.
146
147

ENVIRONMENT VARIABLES

149       The following environment variables affect the execution of  this  com‐
150       mand:
151
152       IMQ_JAVAHOME    Specify  the Java 2 compatible runtime. When this envi‐
153                       ronment variable is not set it defaults to /usr/j2se.
154
155

EXIT STATUS

157       The following exit values are returned:
158
159       0     Successful completion.
160
161
162       >0    An error occurred.
163
164

FILES

166       /var/imq/instances/brokerName/dbstore
167
168           Recommended directory in which to create an embedded database.
169
170

ATTRIBUTES

172       See attributes(5) for descriptions of the following attributes:
173
174
175
176
177       ┌─────────────────────────────┬─────────────────────────────┐
178       │      ATTRIBUTE TYPE         │      ATTRIBUTE VALUE        │
179       ├─────────────────────────────┼─────────────────────────────┤
180       │Availability                 │SUNWiqu                      │
181       └─────────────────────────────┴─────────────────────────────┘
182