Functionalities & Features

This chapter presents the built-in functionally and features of DMK.

Automatic activation of the profile

A profile template is delivered with DMK. Follow the instructions to configure DMK sourcing at login time.

Linux/Unix login-Shell profile:

Depending on your SHELL the profile file can be called “.profile” or “.bash_profile”.

cat ${DMK_HOME}/templates/profile/dmk.mysql.profile >> ~/.profile

Alias & Variable Management : ${DMK_HOME}/etc/dmk.conf

DMK set the environment using “${DMK_HOME}/etc/dmk.conf” in 3 steps

All these steps match to a section from the “${DMK_HOME}/etc/dmk.conf” file. Which are defined by brackets “[…]”, example follows:

[GLOBAL]

var::MYSQL_CNF::=::nooption::"/u01/app/mysql/etc/my.cnf"::

…

alias::vic::novar_noforce::"vi ${MYSQL_CNF}"::


[SID]

var::DMK_MYSQL_ADMIN::=::nowarn::"${MYSQL_BASE}/admin/${MYSQL_SERVER}/log"::

…

alias::cda::var_noforce::'cd ${MYSQL_BASE}/admin/${MYSQL_SERVER}'::


[mysqld2]

var::MYSQL_BASE::=::nowarn::"/u01/app/mysql"::# location of global mysql base

…

alias::mq::novar_noforce::"mysql --defaults-file=${MYSQL_BASE}/admin/${MYSQL_SERVER}/.my.cnf'":

The database section [+ASM1] is set specially for the environment of the database “+ASM1”. If aliases or variables overwrite a defined one from any other section, it will be re-initialized by switching to next environment.

Automatic creation of aliases and variables for modules

DMK interacts with other dbi services toolkits (DMK_HA,DMK_DBBACKUP,DMK_SQL, aso ….), this interaction feature is available for customers on Linux/Unix platforms.

Details of the feature:

• Directories located under ${MYSQL_BASE}/local

• Creates an alias and a variable with the name of the directory in Uppercase

• The System variable ${PATH} is extended with the “bin” directory

mysql@vmoraoel:/home/mysql/ [rdbms1120] ls -d /u01/app/mysql/local/demo/*

/u01/app/mysql/local/demo/bin

mysql@vmoraoel:/u01/app/mysql/local/ [rdbms112] alias demo

alias demo='cd /u01/app/mysql/local/demo'

mysql@vmoraoel:/u01/app/mysql/local/ [rdbms112] echo ${PATH}

...:/u01/app/mysql/local/demo/bin

mysql@vmoraoel:/u01/app/mysql/local/ [rdbms112] echo ${SQLPATH}

...:/u01/app/mysql/local/demo/sql

mysql@vmoraoel:/u01/app/mysql/local/ [rdbms112] echo ${DEMO}

/u01/app/mysql/local/demo

⚠️ Aliases won’t be created for directories containing the hyphen “-“ character.