skip to main content
OpenEdge Data Management: DataServer for ODBC
Configuring the DataServer : Configuring the remote DataServer : Configuring from the command line : Editing the ubroker.properties file
 
Editing the ubroker.properties file
The simplest way to make configuration changes to the ubroker.properties file is to copy an existing broker or NameServer definition and then modify the copied values as required for your configuration. To generate a new universally unique identifier (uuid), use the genuuid script found in the bin directory of your installation. For more information, see the ubroker.properties.README file. You must ensure that all related properties and sections of the file are properly specified for each broker or NameServer instance.
Note: Be sure to preserve the original %DLC%\properties\ubroker.properties file. Rename the original file and work with a copy of the file. You must name the copy of the file ubroker.properties.
The following table describes the sections in the ubroker.properties file that apply to the DataServer for ODBC. The file configures a default NameServer named NameServer.NS1 and a default broker named odbbroker1, which you can use either as they are or as templates for your own configuration specifications.
Table 15. DataServer for ODBC sections of ubroker.properties file
Product
Section
Description
All products
ParentGroup
Defines the name of each NameServer and product broker parent entity.
Environment
Default environment variable settings for all NameServers and product brokers.
UBroker
Defines default property settings for all product brokers.
NameServer
NameServer
The parent entity of NameServers. It defines default property settings for all NameServer instances.
NameServer.NS1
A sample property entity of a NameServer instance. It defines property settings for this NameServer instance.
Environment.NS1
A sample environment entity of a NameServer instance. It defines environment variable settings for this NameServer instance.
DataServer
UBroker.OD
The parent entity of DataServer for ODBC brokers. It defines default property settings for all of these broker instances.
UBroker.OD.odbbroker1
A sample property entity of a DataServer for ODBC broker instance. It defines default property settings for the broker instance named odbbroker1.
Note that although many of the settings in this section can work in your environment, some of them are for demonstration purposes only. Property settings may be changed dynamically for brokers started after the DataServer is started. This is not the case for brokers that are running.
You must specify the appropriate settings for the following:
*srvrExecFile: Specify the pathname of the DataServer executable that the broker runs. The default is @{DLC}/bin/_odbsrv.exe, which runs the default DataServer from your OpenEdge install path.
*srvrMinPort/srvrMaxPort: Specify the minimum and maximum port numbers available to the DataServer.
*srvrStartupParam: Specify the OpenEdge startup parameters for the DataServer. Do not modify the default parameters, although you can add parameters if necessary. The -svub switch is required for a broker connection in the Progress Explorer administration framework.
*srvrStartupTimeout: Specify the number of seconds the broker waits for aserver/agent to become available before starting a new agent.
Environment.odbbroker1
A sample environment entity of a DataServer for ODBC broker instance. It defines environment variable settings that apply to the broker instance named odbbroker1.
Be sure to set the variables to the appropriate values; the values in the file are for demonstration purposes only. Add to this section any environment variables that you want to apply to the DataServer's environment. For more information about the environment variable settings required to configure the DataServer for ODBC, see Configuring the remote DataServer.
The following example illustrates the DataServer sections of the ubroker.properties file:
#
# Default properties for broker instances serving ODBC DataServers
#
[UBroker.OD]
srvrExecFile="@{Startup\DLC}\bin\_odbsrv.exe"
srvrStartupParam=-svub -S X -N TCP -U X -P X -hs 0 -s 40
operatingMode=State-aware
classMain=com.progress.ubroker.broker.ubroker
portNumber=4444
defaultService=0
initialSrvrInstance=0
minSrvrInstance=0
maxSrvrInstance=256
brkrLoggingLevel=3
description=ODBC DataServer Broker
#
# Sample ODBC DataServer Broker definition
#
[UBroker.OD.odbbroker1]
srvrExecFile="@{Startup\DLC}\bin\_odbsrv.exe"
srvrStartupParam=-svub -S X -N TCP -U X -P X -hs 0 -s 40
srvrLogFile=@{WorkPath}\odbbroker1.server.log
brokerLogFile=@{WorkPath}\odbbroker1.broker.log
portNumber=4444
defaultService=1
appserviceNameList=odbbroker1
controllingNameServer=NS1
environment=odbbroker1
uuid=172.18.103.53:1f415c:d6330e5d24:-7f1e
description=A sample ODBC DataServer Broker

#
# Environment for ODBC Dataserver Broker: odbbroker1
#
[Environment.odbbroker1]
DSLOGDIR=@{WorkPath}
For a complete description of the parameters included in each of these sections, see the comments in the %DLC%\properties\ubroker.properties file.
The ubroker.properties file is read on startup of the AdminServer process. For changes in any used environment variables to take effect, the AdminServer must be restarted.