When converting to high-availability operation using an HADB dababse, you can use the Message Queue Database Manager utility (imqdbmgr) subcommand
imqdbmgr upgrade hastore
to convert an existing standalone HADB database to a shared HADB database. You can use this command in the following cases:
Migrating from a Message Queue 4.0 or 4.1 standalone HADB database to a Message Queue 4.2 shared HADB database. In this case, the broker, upon startup, will automatically upgrade the database schema to Message Queue 4.2. You can then run the imqdbmgr upgrade hastore command to convert the data store to shared use.
Moving from a standalone Message Queue 4.21 HADB database to a shared HADB database. In this case, you just need to run the imqdbmgr upgrade hastore command to convert the data store to shared use.
Because this command only supports conversion of HADB stores, it cannot be used to convert file-based stores or other JDBC-based stores to a shared HADB store. If you were previously running a 3.x version of Message Queue, you must create an HADB store and then manually migrate your data to that store in order to use the high availability feature.