HomeGuides
Log In
Guides

dataonedbmgr.sh reference - NEW! 🚀

Introduction to Data One database update

dataonedbmgr.sh is a command that assists the Administrator in updating the Data One database before installing product update packages. This command will analyze and process, in sequence, all the installation pending update packages stored in the <DOIM_HOME>/pkg-repo/tf-inbox folder.

To run SQL scripts from DOIM control node in an assisted way see dataonedbmgr.sh -sqlrun here below.

The database schema and base product data update is driven by the <DOIM_HOME>/config/dataonedb.cfg file. Before running the dataonedbmgr.sh database update command, make sure you carefully fill in all the required parameters as described in the reference page of the dataonedb.cfg configuration file.

NOTE: it is recommended to perform a full database backup before updating your database with dataonedbmgr.sh.

dataonedbmgr.sh -sqlrun

To run SQL scripts from the DOIM control node in an assisted way, make sure you filled it all the required database configuration parameters in <DOIM_HOME>/config/dataonedb.cfg (see the dataonedb.cfg reference page).

Syntax

Run the command from <DOIM_HOME>/bin:

  • ./dataonedbmgr.sh -sqlrun

Description

This dataonedbmgr.sh verb runs SQL scripts from DOIM control node.

Checking the command outcome

The command outcome can be checked at several levels of details:

  • On the console output, in order to have a very short outcome indicator
  • On the global log file <DOIM_HOME>/log/dataonedbmgr.log
  • On script-specific log files, one for each distinct SQL script <DOIM_HOME>/log/dataonedbmgr_<packagename>_<sqlscriptname>.log

The command processes all the required DDL and DML SQL scripts in sequence. When an error occurs the command immediately terminates reporting a detailed error message in the logs.

Once the cause of the error has been analyzed by an Administrator and resolved, the command can be safely run again because all DDL and DML SQL scripts that were successfully processed in a previous run will be automatically skipped.