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.
Updated about 1 month ago