Perform post-installation tasks

If you perform an installation with an offline database, or if you want to customize scripts , you should select the Generated scripts only option to generate the database scripts but not to launch them.

Personalize the database

  1. Execute SQL scripts using XDBM to update the database of each component.
  2. Run post-installation scripts for each component 

The post-installation scripts must be run using the XDBM (Axway DataBase Manager) utility delivered with the installer. We strongly recommend the scripts only be customized and executed by a Database Administrator. Axway cannot be held responsible for any problems that may arise as a consequence of customizing the scripts.

The scripts are located in <installation_root_directory>/<product>/database, and contain the following sub-directories:

  • logs - log files created when the scripts are run
  • scripts - model content creation scripts
  • oracle - if Oracle is use

Oracle

The Oracle scripts are located in: <installation_root_directory>/<product>/database/oracle/scripts

MySQL

The MySQL scripts are located in: <installation_root_directory>/<product>/database/mysql/scripts

SQL Server

The SQL Server scripts are located in: <installation_root_directory>/<product>/database/sqlserver/scripts

Scripts personalization

It is strongly recommended that these scripts only be edited by experts with advanced knowledge of databases.

Patches

As with other Axway products, the user must use the XDBM Tool to update the database if the patch’s SQL scripts were manually updated.

Customize scripts in a patch

When a patch contains SQL scripts, you can select the Generate scripts only option and customize the scripts generated. The scripts must be run using the XDBM utility delivered with your Axway product unless otherwise specified in the Release Notes of the patch.

Remember that a patch may contain new scripts versions that may overwrite customization. It is under customer responsibility to validate its customization before applying scripts.

Update a database with XDBM

XDBM (AXway DataBase Manager) is a tool for initializing and modifying databases supporting Axway products. It is located in the <installation_root_directory>/Tools/XDBM directory.

To update a database, you can use either the graphical or the command line mode.

Graphic mode

To use the XDBM utility in graphic mode:

  1. Start the tool by launching <installation_root_directory>/tools/XDBM/xdbm.sh (<installation_root_directory>\tools\XDBM\xdbm.bat for Windows).
  2. In the drop-down menu, select the product you want to update.
  3. Click Connect on the toolbar and enter the connection password.
  4. You can then update the product’s model by clicking Update.
Note   Reports are available to list all scripts and their results.

Make sure you update all the products (from the product list) before using the product.

Note   Under UNIX, a graphical environment is mandatory to use this mode.

Command line mode

To use the XDBM utility in command line mode, start the tool by launching <installation_root_directory>/tools/XDBM/xdbmcmd_<component>_<schema_identifier>.sh (<installation_root_directory>\tools\XDBM\xdbmcmd_<component>_<schema_identifier>.bat for Windows).

For example:

  • xdbmcmd_AISDesigner_2.3.0.bat

Run post-installation scripts

Before starting and using the application, you must run the post-installation scripts.

If you are installing several components, you must run the post-installation scripts in the following order:

  1. Repository
  2. Administration, Report Server and Designer
  3. AccountingIntegrator

Below is the location of the scripts and the log files for each component.

Repository:

  • Post-installation script: [Installation_Path]/AIS/Repository/postinstall.bat(sh).
  • Log file: [Installation_Path]/AIS/Repository/log/config-api.log.

Administration:

  • Post-installation script: [Installation_Path]/AIS/Administration/postinstall.bat(sh).
  • Log file: [Installation_Path]/AIS/Administration/log/postinstall.log.

Report Server:

  • Post-installation script: [Installation_Path]/AIS/Report/postinstall.bat(sh).
  • Log file: [Installation_Path]/AIS/Report/log/postinstall.log.

Designer:

  • Post-installation script: [Installation_Path]/AIS/Designer/postinstall.bat(sh).
  • Log file: [Installation_Path]/AIS/Designer/extra/Tools/tools.log.

AccountingIntegrator

  • Post-installation script: [InstallationPath]/AccountingIntegrator/RuleServer/postinstall.bat(sh).
  • Log file:[Installation Path]/AccountingIntegrator/RuleServer/log/ruleServerConsole.log

Related Links