Activator 5.12 Administrator Guide 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. Before using the tool, stop the server. Make a backup copy of the datastoreconfig.xml file in the application's conf directory. 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. 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. Restart the server when you are done. Run dbConfig Windows To run dbConfig on Windows machines: From the Start menu Stop the server. Make a backup copy of the datastoreconfig.xml file in the application's conf directory. Start the tool: Select Start > Programs > Axway Software > Axway Activator > Activator Server> DB Configuration . The software opens the Datastore Configurator page. From the Datastore Configurator page, click Test Connection. If the connection is correct, a confirmation field is displayed. From the installation folder Stop the server. Make a backup copy of the datastoreconfig.xml file in the application's conf directory. Locate the tool: Go to <install directory>\bin and click dbConfig.cmd. The software opens the Datastore Configurator page. From the Datastore Configurator page, click Test Connection. If the connection is correct, a confirmation field is displayed. From the command line Stop the server. Make a backup copy of the datastoreconfig.xml file in the application's conf directory. Use the cd command to go to <install directory>\bin. Execute the command dbConfig.cmd -b2bx true Test the connection and if necessary change the details. Save. UNIX / Linux Stop the trading engine server. Make a backup copy of the datastoreconfig.xml file in the application's conf directory. Using the cd command, go to <install directory>\bin. Run dbConfig in a console window. The tool can be run in a command line with the following parameters: [-? | -help] [-d (sqlsrvr|ora|db2|derby|mysql)] [-p port] [-h host] [-n dbname] [-u username] [-pd password] 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. Save. Related topics Trading engine governance script Tools in bin directory Document generator Tools in tools directory Check the collaboration and action trees Related Links
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. Before using the tool, stop the server. Make a backup copy of the datastoreconfig.xml file in the application's conf directory. 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. 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. Restart the server when you are done. Run dbConfig Windows To run dbConfig on Windows machines: From the Start menu Stop the server. Make a backup copy of the datastoreconfig.xml file in the application's conf directory. Start the tool: Select Start > Programs > Axway Software > Axway Activator > Activator Server> DB Configuration . The software opens the Datastore Configurator page. From the Datastore Configurator page, click Test Connection. If the connection is correct, a confirmation field is displayed. From the installation folder Stop the server. Make a backup copy of the datastoreconfig.xml file in the application's conf directory. Locate the tool: Go to <install directory>\bin and click dbConfig.cmd. The software opens the Datastore Configurator page. From the Datastore Configurator page, click Test Connection. If the connection is correct, a confirmation field is displayed. From the command line Stop the server. Make a backup copy of the datastoreconfig.xml file in the application's conf directory. Use the cd command to go to <install directory>\bin. Execute the command dbConfig.cmd -b2bx true Test the connection and if necessary change the details. Save. UNIX / Linux Stop the trading engine server. Make a backup copy of the datastoreconfig.xml file in the application's conf directory. Using the cd command, go to <install directory>\bin. Run dbConfig in a console window. The tool can be run in a command line with the following parameters: [-? | -help] [-d (sqlsrvr|ora|db2|derby|mysql)] [-p port] [-h host] [-n dbname] [-u username] [-pd password] 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. Save. Related topics Trading engine governance script Tools in bin directory Document generator Tools in tools directory Check the collaboration and action trees