Tools and options > Tools in bin directory > Database configuration tool

Database configuration tool

About the database configuration tool

After you install Activator, it is good practice to verify your database connectivity. To do this, you can use the database configuration tool, dbConfig.

Use the database configuration tool only when the server is not running. When running, the database port is in use and the tool cannot connect to the database.

Caution   Activator users must not use this tool to change database settings. Only use the tool if you want to review or test database settings. Also, do not manually change any database settings in the datastoreconfig.xml file.

Tool guidelines

Here are some guidelines for using the database configuration tool.

  1. Before using the tool, stop the server. Make a backup copy of the datastoreconfig.xml file in the application's conf directory.
  2. To use the test connection feature in the GUI, change the fields as needed and click Test Connection. If the database has been created, the information in the fields is correct and the tool can connect to the database, the test should succeed. If not, make changes and test again. When you are satisfied with the results, click Save.
  3. When using the GUI, click Save before exiting or your changes are not saved. Changes are saved to datastoreconfig.xml in the application's conf directory.
  4. Restart the server when you are done.

Run dbConfig

Windows

To run dbConfig on Windows machines:

From the Start menu

  1. Stop the server. Make a backup copy of the datastoreconfig.xml file in the application's conf directory.
  2. Start the tool: Select Start > Programs > Axway Software > Axway Activator > Activator Server> DB Configuration.
  3. The software opens the Datastore Configurator page.
  4. From the Datastore Configurator page, click Test Connection.
  5. If the connection is correct, a confirmation field is displayed.

From the installation folder

  1. Stop the server. Make a backup copy of the datastoreconfig.xml file in the application's conf directory.
  2. Locate the tool: Go to <install directory>\bin and click dbConfig.cmd.
  3. The software opens the Datastore Configurator page.
  4. From the Datastore Configurator page, click Test Connection.
  5. If the connection is correct, a confirmation field is displayed.

From the command line

  1. Stop the server. Make a backup copy of the datastoreconfig.xml file in the application's conf directory.
  2. Use the cd command to go to <install directory>\bin.
  3. Execute the command dbConfig.cmd -b2bx true
  4. Test the connection and if necessary change the details.
  5. Save.

UNIX / Linux

  1. Stop the trading engine server. Make a backup copy of the datastoreconfig.xml file in the application's conf directory.
  2. Using the cd command, go to <install directory>\bin.
  3. Run dbConfig in a console window.
  4. The tool can be run in a command line with the following parameters:
  5. [-? | -help] [-d (sqlsrvr|ora|db2|derby|mysql)] [-p port] [-h host] [-n dbname] [-u username] [-pd password]
  6. Test the connection by examining the cn.log to see if Activator successfully connected to the database. If necessary, repeat the above steps and change the command line details.
  7. Save.

Related topics