Kbase 20863: SonicMQ Broker.ini properties and db table re-initialization
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/16/2001 |
|
SUMMARY:
This solution applies to SonicMQ Versions 2000.x and 3.0. It lists
the properties which when changed require reinitialization of some or
all of the SonicMQ broker's database, and the tables which must be
reinitialized in each case.
SOLUTION:
When you change the value of certain properties in the broker.ini
file, you must also re-initialize one or more of the database tables
using dbtool. Since re-initializing a table causes you to lose all
data in the table, you should try to plan ahead to reduce the chance
that you will need to change these properties. The following is a
list of Broker.ini properties that require database table
reinitialization:
Property Tables to Re-initialize
---------------------------------------------------------------------
BROKER_NAME All
MAX_LOG_FILE_SIZE All
You need to re-create the tables if you are decreasing the value of
MAX_LOG_FILE_SIZE and the size of the log file has already exceeded
the new value of MAX_LOG_FILE_SIZE.
Re-creating the basic tables creates a new log. The Broker cannot
directly reduce the size of a log file by releasing unused space.
Increasing the size of the log does not require that tables be
reinitialized.
ENABLE_INTERBROKER Interbroker
You only need to re-create the interbroker tables for a configuration
server, and only if you have changed ENABLE_INTERBROKER to TRUE.
ENABLE_SECURITY Basic, Security
You must always re-create the basic tables.
You must also re-create the security tables if you change the value of
this property from FALSE to TRUE and the server is a standalone
message server or a configuration server.
You must delete the security tables when you change the value of this
property from TRUE to FALSE if the server is a standalone message
server or a configuration server.
You do not need to re-create or delete the security tables if the
message server is a member of a cluster and not a configuration
server.
Please refer to the SonicMQ Installation and Administration Guide for
full instructions for using dbtool.
References to Written Documentation:
SonicMQ Installation and Administration Guide Chapter 1, Installation,
"Scripts and Configuration Files"