Perform post-installation tasks

If you perform an installation with an offline database, or if you want to customize scripts (see Personalize database scripts), you should select the Generated scripts only option to generate the database scripts but not to launch them. In this case, you must perform some post-installation tasks when the database is online and the customization is done:

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

Personalize database scripts

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 used

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

To initialize the database, execute the scripts located in subdirectory 1 in the order specified in the 1/scripts_index_a04_1.dat file.

The execution order for the update scripts is specified in the 2/scripts_index_a04_1.dat file.

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 Axway databases. 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).

Run post-installation scripts

Before starting and using the application, you must run XDBM to update the database (see Update a database with XDBM) and then 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