Primeur Online Docs
Data One Installation Manager
Data One Installation Manager
  • 🚀GETTING STARTED
    • Introduction to the installation process
    • Modules and components of Primeur Data One
      • Asynchronous and event-driven architecture
  • Data One Platform Modules vs Data One Platform Components
  • SYSTEM REQUIREMENTS
    • System requirements
      • Global system requirements 🚀
      • DOIM system requirements
      • CEMAN system requirements
      • Data Watcher system requirements
      • STENG system requirements
      • DMZ Gateway system requirements
      • Data Shaper system requirements
      • Storage requirements
  • TOPOLOGY PATTERNS
    • Network topology recommendations
    • Data One common domain topology patterns
  • INSTALL DATA MOVER
    • Planning initial installation and master configuration
      • Data One runtime services, nodes, and components
    • Data Mover Domain Master Configuration reference
    • Performing initial installation and master configuration
      • Creating database objects for PostgreSQL
      • Creating database objects for Oracle
      • Executing the installer
      • Configuring load balancer rules for Data One WUI access on CEMAN
      • Configuring firewall rules
    • Running the system for the first time
      • Basic system control: starting, stopping and checking status
      • Launching Data One WUI
      • Wiring your STENG cluster together
  • INSTALL DATA SHAPER
    • Introduction to Data Shaper installation process
    • Planning Data Shaper installation
    • Data Shaper System Requirements
    • Data Shaper Domain Master Configuration reference
    • Performing Data Shaper initial installation and master configuration
      • Creating database objects for PostgreSQL
      • Creating database objects for Oracle
      • Executing Data Shaper installer
      • Configuring additional firewall rules for Data Shaper
  • CLI and Configuration files
    • dataone.sh reference
    • doim.sh reference
    • dataonedbmgr.sh reference
    • dataonedb.cfg reference
Powered by GitBook
On this page
  • Introduction to the Data One database update
  • dataonedbmgr.sh -sqlrun
  • Syntax
  • Description
  • Checking the command outcome
  1. CLI and Configuration files

dataonedbmgr.sh reference

Previousdoim.sh referenceNextdataonedb.cfg reference

Last updated 2 months ago

Introduction to the 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 pending installation 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 .

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 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 detail:

  • On the console output, 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.

reference page of the dataonedb.cfg configuration file
dataonedb.cfg reference