Difference between revisions of "SQWareProduction:generic"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
Line 118: | Line 118: | ||
== tools == | == tools == | ||
+ | === sqwgen_Crypt.ksh === | ||
+ | Script $gvsqw_GenBin/../tools/sqwgen_Crypt.ksh:<br> | ||
+ | {{SQWareProduction_sqwgen_Crypt.ksh_presentation}} | ||
+ | [[SQWareProduction:generic:tools:sqwgen_Crypt.ksh|See the detailed help for sqwgen_Crypt.ksh]]<br><br> | ||
+ | |||
+ | === sqwgen_ListAsyncFilesGlobal.ksh === | ||
+ | Script $gvsqw_GenBin/../tools/sqwgen_ListAsyncFilesGlobal.ksh:<br> | ||
+ | {{SQWareProduction_sqwgen_ListAsyncFilesGlobal.ksh_presentation}} | ||
+ | [[SQWareProduction:generic:tools:sqwgen_ListAsyncFilesGlobal.ksh|See the detailed help for sqwgen_ListAsyncFilesGlobal.ksh]]<br><br> | ||
+ | |||
+ | === sqwgen_ListAsyncFiles.ksh === | ||
+ | Script $gvsqw_GenBin/../tools/sqwgen_ListAsyncFiles.ksh:<br> | ||
+ | {{SQWareProduction_sqwgen_ListAsyncFiles.ksh_presentation}} | ||
+ | [[SQWareProduction:generic:tools:sqwgen_ListAsyncFiles.ksh|See the detailed help for sqwgen_ListAsyncFiles.ksh]]<br><br> | ||
+ | |||
=== sqwgen_TestMySQL.ksh === | === sqwgen_TestMySQL.ksh === | ||
Script $gvsqw_GenBin/../tools/sqwgen_TestMySQL.ksh:<br> | Script $gvsqw_GenBin/../tools/sqwgen_TestMySQL.ksh:<br> | ||
Line 127: | Line 142: | ||
{{SQWareProduction_sqwgen_TestSendmail.ksh_presentation}} | {{SQWareProduction_sqwgen_TestSendmail.ksh_presentation}} | ||
[[SQWareProduction:generic:tools:sqwgen_TestSendmail.ksh|See the detailed help for sqwgen_TestSendmail.ksh]]<br><br> | [[SQWareProduction:generic:tools:sqwgen_TestSendmail.ksh|See the detailed help for sqwgen_TestSendmail.ksh]]<br><br> | ||
+ | |||
+ | === sqwgen_Uncrypt.ksh === | ||
+ | Script $gvsqw_GenBin/../tools/sqwgen_Uncrypt.ksh:<br> | ||
+ | {{SQWareProduction_sqwgen_Uncrypt.ksh_presentation}} | ||
+ | [[SQWareProduction:generic:tools:sqwgen_Uncrypt.ksh|See the detailed help for sqwgen_Uncrypt.ksh]]<br><br> | ||
<br> | <br> |
Revision as of 18:33, 8 March 2020
Presentation
Usage
It's the module locally operating of generic.
It is entirely written in ksh and sql.
It allows to manage the operation for generic.
Example uses of the tool:
- Backup
- Recovery
- Compute statistics
- Indicators collection to store in referential database SQWareRepository
- Rotate logs
- ....
This module is deployed locally on the machine hosting the authorities to manage,
in order to avoid any points of weakness related to an NFS mount or whatever.
The deployment is done through a simple command SQWareCentral module using inventory located in SQWareRepository !
Installation guide for SQWareProduction for generic
Explanation of directories
Directories located in $gvsqw_GenBin:
- bin : Directory containing standard scripts
- bin_cust : Directory containing customs scripts for your environnement
- etc : Directory containing the standard files of configuration
- etc_cust : Directory containing the customs files of configuration for your environnement (overload standards)
- help : Directory containing the standard files of help
- help_cust : Directory containing the customs files of help for your environnement
- lib : Directory containing the generic shell function librairies
- lib_cust : Directory containing the generic shell function librairies (overload standards)
- spm : Contain sql query toolkit
- tools : Directory containing the standard scripts used on an ad hoc
- tools_cust : Directory containing the customs scripts used on an ad hoc for your environnement
- menu : Directory containing the standard menus
- menu_cust : Directory containing the custom menus for your environnement
Naming convention of files
The majority of files are named with suffixes:
- *.ksh : for scripts
- *.cfg : for configuration files
- *.lib : for function librairies
- *.hlp : for help files
Naming convention in scripts
In general, the following naming convention is used in all scripts of SQWareProduction:
- gvsqw_ {} : global variable initialized by the environment and / or generic library
- lvsqw_ {} : local variable initialized by the script and / or a specific library
- gfsqw_ {} : function defined by a generic library
- lfsqw_ {} : function defined by the script and / or a specific library
bin
sqwgen_ExecSQL.ksh
Script $gvsqw_GenBin/bin/sqwgen_ExecSQL.ksh:
execute SQL file on instance
See the detailed help for sqwgen_ExecSQL.ksh
sqwgen_NetBackup.ksh
Script $gvsqw_GenBin/bin/sqwgen_NetBackup.ksh:
backup with NetBackup dump/backup files
See the detailed help for sqwgen_NetBackup.ksh
sqwgen_ParallelRun.ksh
Script $gvsqw_GenBin/bin/sqwgen_ParallelRun.ksh:
Manages the execution of unix commands in parallel mode
Takes in parameter file with unix command to execute
You can choose:
- The parallel degree
- Aggressiveness of run (number of seconds between two runs)
- Aggressiveness of check end (number of seconds between two checks of end)
See the detailed help for sqwgen_ParallelRun.ksh
sqwgen_RsyncBackup.ksh
Script $gvsqw_GenBin/bin/sqwgen_RsyncBackup.ksh:
rsync dir (without delete) to an other host
See the detailed help for sqwgen_RsyncBackup.ksh
sqwgen_RunJob.ksh
Script $gvsqw_GenBin/bin/sqwgen_RunJob.ksh:
Run <gvsqw_RdbmsName> scripts and generate log and error file
based on $gvsqw_RootCfg/sqw<gvsqw_RdbmsRoot>_Jobs.cfg configuration file
compress and purge oldest log files
See the detailed help for sqwgen_RunJob.ksh
etc
sqwgen_DbRefVar.cfg
Configuration file $gvsqw_GenBin/../etc/sqwgen_DbRefVar.cfg:
Global var for SQWareRepository connexion
It contains the operating variables of SQWareProduction.
See the detailed help for sqwgen_DbRefVar.cfg
sqwgen_GlobalVar.cfg
Configuration file $gvsqw_GenBin/../etc/sqwgen_GlobalVar.cfg:
Generic global var
It contains the operating variables of SQWareProduction.
See the detailed help for sqwgen_GlobalVar.cfg
sqwgen_IndicatorsVar.cfg
Configuration file $gvsqw_GenBin/../etc/sqwgen_IndicatorsVar.cfg:
Generic global var for indicators scripts
It contains the operating variables of SQWareProduction.
See the detailed help for sqwgen_IndicatorsVar.cfg
.profile
Sample file for .profile $gvsqw_GenBin/../etc/.profile:
Sample of lines to add to .profile of generic users.
See the detailed help for .profile
.profile_confort
File to put aliases $gvsqw_GenBin/../etc/.profile_confort:
Contains confort aliases of SQWareProduction for generic.
See the detailed help for .profile_confort
lib
sqwgen_ExecSQL.lib
shell functions library $gvsqw_GenBin/../lib/sqwgen_ExecSQL.lib:
lib for sqwgen_ExecSQL.ksh
See the detailed help for sqwgen_ExecSQL.lib
sqwgen_GatherIndicators.lib
shell functions library $gvsqw_GenBin/../lib/sqwgen_GatherIndicators.lib:
lib for sqw..._GatherIndicators.ksh
See the detailed help for sqwgen_GatherIndicators.lib
sqwgen_GatherStructure.lib
shell functions library $gvsqw_GenBin/../lib/sqwgen_GatherStructure.lib:
lib for sqw..._GatherIndicators.ksh
See the detailed help for sqwgen_GatherStructure.lib
sqwgen_Global.lib
shell functions library $gvsqw_GenBin/../lib/sqwgen_Global.lib:
central generic lib of global fonctions
See the detailed help for sqwgen_Global.lib
sqwgen_InsertIndicators.lib
shell functions library $gvsqw_GenBin/../lib/sqwgen_InsertIndicators.lib:
generic fonctions to insert into SQWareRepository
See the detailed help for sqwgen_InsertIndicators.lib
sqwgen_NetBackup.lib
shell functions library $gvsqw_GenBin/../lib/sqwgen_NetBackup.lib:
lib for sqwgen_NetBackup.ksh
See the detailed help for sqwgen_NetBackup.lib
sqwgen_RsyncBackup.lib
shell functions library $gvsqw_GenBin/../lib/sqwgen_RsyncBackup.lib:
lib for sqwgen_RsyncBackup.ksh.ksh
See the detailed help for sqwgen_RsyncBackup.lib
tools
sqwgen_Crypt.ksh
Script $gvsqw_GenBin/../tools/sqwgen_Crypt.ksh:
Generic script to crypt file with openssl
See the detailed help for sqwgen_Crypt.ksh
sqwgen_ListAsyncFilesGlobal.ksh
Script $gvsqw_GenBin/../tools/sqwgen_ListAsyncFilesGlobal.ksh:
List Async files (sql, log, mail) to upload in SQWareCentral (all in a directory)
See the detailed help for sqwgen_ListAsyncFilesGlobal.ksh
sqwgen_ListAsyncFiles.ksh
Script $gvsqw_GenBin/../tools/sqwgen_ListAsyncFiles.ksh:
List Async files (sql, log, mail) to upload in SQWareCentral
See the detailed help for sqwgen_ListAsyncFiles.ksh
sqwgen_TestMySQL.ksh
Script $gvsqw_GenBin/../tools/sqwgen_TestMySQL.ksh:
Generic test MySQL connection script
See the detailed help for sqwgen_TestMySQL.ksh
sqwgen_TestSendmail.ksh
Script $gvsqw_GenBin/../tools/sqwgen_TestSendmail.ksh:
Generic test sendmail script
See the detailed help for sqwgen_TestSendmail.ksh
sqwgen_Uncrypt.ksh
Script $gvsqw_GenBin/../tools/sqwgen_Uncrypt.ksh:
Generic script to uncrypt file with openssl
See the detailed help for sqwgen_Uncrypt.ksh
help
Contains help files for "-s" option of bin scripts.
spm
SQL query toolkit
See the detailed help for spm