Difference between revisions of "SQWareProduction:adabas"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
Line 16: | Line 16: | ||
{{SQWareProduction_sqwada_ExecSQL.ksh_presentation}} | {{SQWareProduction_sqwada_ExecSQL.ksh_presentation}} | ||
[[SQWareProduction:adabas:bin:sqwada_ExecSQL.ksh|See the detailed help for sqwada_ExecSQL.ksh]]<br><br> | [[SQWareProduction:adabas:bin:sqwada_ExecSQL.ksh|See the detailed help for sqwada_ExecSQL.ksh]]<br><br> | ||
+ | |||
+ | === sqwada_FailWithoutMail.ksh === | ||
+ | Script $gvsqw_AdaBin/bin/sqwada_FailWithoutMail.ksh:<br> | ||
+ | {{SQWareProduction_sqwada_FailWithoutMail.ksh_presentation}} | ||
+ | [[SQWareProduction:adabas:bin:sqwada_FailWithoutMail.ksh|See the detailed help for sqwada_FailWithoutMail.ksh]]<br><br> | ||
=== sqwada_GatherIndicators.ksh === | === sqwada_GatherIndicators.ksh === |
Latest revision as of 08:57, 18 December 2023
Presentation
Usage
It's the module locally operating of adabas.
It is entirely written in ksh and sql.
It allows to manage the operation for adabas.
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 adabas
Explanation of directories
Directories located in $gvsqw_AdaBin:
- 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
sqwada_Backup.ksh
Script $gvsqw_AdaBin/bin/sqwada_Backup.ksh:
run a backup with adabck
See the detailed help for sqwada_Backup.ksh
sqwada_DeleteCheckpoints.ksh
Script $gvsqw_AdaBin/bin/sqwada_DeleteCheckpoints.ksh:
Supress checkpoints
See the detailed help for sqwada_DeleteCheckpoints.ksh
sqwada_ExecSQL.ksh
Script $gvsqw_AdaBin/bin/sqwada_ExecSQL.ksh:
execute SQL file on instance
See the detailed help for sqwada_ExecSQL.ksh
sqwada_FailWithoutMail.ksh
Script $gvsqw_AdaBin/bin/sqwada_FailWithoutMail.ksh:
exit with error and display imput parameters
See the detailed help for sqwada_FailWithoutMail.ksh
sqwada_GatherIndicators.ksh
Script $gvsqw_AdaBin/bin/sqwada_GatherIndicators.ksh:
gather DBA indicators
See the detailed help for sqwada_GatherIndicators.ksh
sqwada_NetBackup.ksh
Script $gvsqw_AdaBin/bin/sqwada_NetBackup.ksh:
backup with NetBackup dump/backup files
See the detailed help for sqwada_NetBackup.ksh
sqwada_ParallelRun.ksh
Script $gvsqw_AdaBin/bin/sqwada_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 sqwada_ParallelRun.ksh
sqwada_Reorg.ksh
Script $gvsqw_AdaBin/bin/sqwada_Reorg.ksh:
reorganize base with adaord
See the detailed help for sqwada_Reorg.ksh
sqwada_RunJob.ksh
Script $gvsqw_AdaBin/bin/sqwada_RunJob.ksh:
Run Adabas scripts and generate log and error file
based on $gvsqw_RootCfg/sqwada_Jobs.cfg configuration file
compress and purge oldest log files
See the detailed help for sqwada_RunJob.ksh
etc
sqwada_CreInst_CrontabRef.cfg
Configuration file $gvsqw_AdaBin/../etc/sqwada_CreInst_CrontabRef.cfg:
See the detailed help for sqwada_CreInst_CrontabRef.cfg
sqwada_CreInst_Jobs.cfg
Configuration file $gvsqw_AdaBin/../etc/sqwada_CreInst_Jobs.cfg:
See the detailed help for sqwada_CreInst_Jobs.cfg
sqwada_GlobalVar.cfg
Configuration file $gvsqw_AdaBin/../etc/sqwada_GlobalVar.cfg:
Global var for Adabas
It contains the operating variables of SQWareProduction.
See the detailed help for sqwada_GlobalVar.cfg
.profile
Sample file for .profile $gvsqw_AdaBin/../etc/.profile:
Sample of lines to add to .profile of adabas users.
See the detailed help for .profile
.profile_confort
File to put aliases $gvsqw_AdaBin/../etc/.profile_confort:
Contains confort aliases of SQWareProduction for adabas.
See the detailed help for .profile_confort
lib
sqwada_Backup.lib
shell functions library $gvsqw_AdaBin/../lib/sqwada_Backup.lib:
lib for sqwada_Backup.ksh
See the detailed help for sqwada_Backup.lib
sqwada_DeleteCheckpoints.lib
shell functions library $gvsqw_AdaBin/../lib/sqwada_DeleteCheckpoints.lib:
lib for sqwada_DeleteCheckpoints.ksh
See the detailed help for sqwada_DeleteCheckpoints.lib
sqwada_GatherIndicators.lib
shell functions library $gvsqw_AdaBin/../lib/sqwada_GatherIndicators.lib:
lib for sqwada_GatherIndicators.ksh
See the detailed help for sqwada_GatherIndicators.lib
sqwada_GatherIndicators_Overload.lib
shell functions library $gvsqw_AdaBin/../lib/sqwada_GatherIndicators_Overload.lib:
lib for overLoad sqwada_GatherIndicators.ksh
See the detailed help for sqwada_GatherIndicators_Overload.lib
sqwada_GenerateCreateInstance.lib
shell functions library $gvsqw_AdaBin/../lib/sqwada_GenerateCreateInstance.lib:
lib for generate create instance
See the detailed help for sqwada_GenerateCreateInstance.lib
sqwada_Global.lib
shell functions library $gvsqw_AdaBin/../lib/sqwada_Global.lib:
central lib of generic fonctions for adabas
See the detailed help for sqwada_Global.lib
sqwada_NetBackup.lib
shell functions library $gvsqw_AdaBin/../lib/sqwada_NetBackup.lib:
lib for sqwgen_NetBackup.ksh
See the detailed help for sqwada_NetBackup.lib
sqwada_Reorg.lib
shell functions library $gvsqw_AdaBin/../lib/sqwada_Reorg.lib:
lib for sqwada_Reorg.ksh
See the detailed help for sqwada_Reorg.lib
sqwada_SetEnv.lib
shell functions library $gvsqw_AdaBin/../lib/sqwada_SetEnv.lib:
fonction to set env for $DBID
See the detailed help for sqwada_SetEnv.lib
tools
sqwada_Crypt.ksh
Script $gvsqw_AdaBin/../tools/sqwada_Crypt.ksh:
Generic script to crypt file with openssl
See the detailed help for sqwada_Crypt.ksh
sqwada_GenerateCreateInstance.ksh
Script $gvsqw_AdaBin/../tools/sqwada_GenerateCreateInstance.ksh:
Generate create instance files
See the detailed help for sqwada_GenerateCreateInstance.ksh
sqwada_ListAsyncFilesGlobal.ksh
Script $gvsqw_AdaBin/../tools/sqwada_ListAsyncFilesGlobal.ksh:
List Async files (sql, log, mail) to upload in SQWareCentral (all in a directory)
See the detailed help for sqwada_ListAsyncFilesGlobal.ksh
sqwada_ListAsyncFiles.ksh
Script $gvsqw_AdaBin/../tools/sqwada_ListAsyncFiles.ksh:
List Async files (sql, log, mail) to upload in SQWareCentral
See the detailed help for sqwada_ListAsyncFiles.ksh
sqwada_SetEnv.ksh
Script $gvsqw_AdaBin/../tools/sqwada_SetEnv.ksh:
set env for $DBID
See the detailed help for sqwada_SetEnv.ksh
sqwada_TestMySQL.ksh
Script $gvsqw_AdaBin/../tools/sqwada_TestMySQL.ksh:
Generic test MySQL connection script
See the detailed help for sqwada_TestMySQL.ksh
sqwada_TestSendmail.ksh
Script $gvsqw_AdaBin/../tools/sqwada_TestSendmail.ksh:
Generic test sendmail script
See the detailed help for sqwada_TestSendmail.ksh
sqwada_Uncrypt.ksh
Script $gvsqw_AdaBin/../tools/sqwada_Uncrypt.ksh:
Generic script to uncrypt file with openssl
See the detailed help for sqwada_Uncrypt.ksh
sqwmys_TestMySQL.ksh
Script $gvsqw_AdaBin/../tools/sqwmys_TestMySQL.ksh:
Generic test MySQL connection script
See the detailed help for sqwmys_TestMySQL.ksh
sqwmys_TestSendmail.ksh
Script $gvsqw_AdaBin/../tools/sqwmys_TestSendmail.ksh:
Generic test sendmail script
See the detailed help for sqwmys_TestSendmail.ksh
help
Contains help files for "-s" option of bin scripts.
spm
SQL query toolkit
See the detailed help for spm