Difference between revisions of "SQWareProduction:mssql"
m (Updated by Expdbtools) |
Expdbtools (talk | contribs) |
||
Line 1: | Line 1: | ||
+ | {{SQWareProductionPresSgbd|Mssql|Msq|msq| | ||
+ | Exemple d'utilisations de l'outil: | ||
+ | *Backup(all databases) | ||
+ | *Restore(all databases) | ||
+ | *Collecte d'indicateurs qui sont remontés sur le référentiel bdd [[SQWareRepository:mssql|SQWareRepository]] | ||
+ | *Rebuild indexes(all databases) | ||
+ | *... | ||
+ | }} | ||
+ | |||
{{SQWareProductionPresSgbd|mssql|Mss}} | {{SQWareProductionPresSgbd|mssql|Mss}} | ||
Revision as of 22:57, 16 July 2010
Contents
- 1 Presentation
- 2 Presentation
- 3 bin
- 3.1 sqwmsq_BackupAllDatabases.ksh
- 3.2 sqwmsq_BackupDatabase.ksh
- 3.3 sqwmsq_CheckIndicators.ksh
- 3.4 sqwmsq_GatherIndicators.ksh
- 3.5 sqwmsq_ParallelRun.ksh
- 3.6 sqwmsq_RebuildIndexAllDatabases.ksh
- 3.7 sqwmsq_RebuildIndexDatabase.ksh
- 3.8 sqwmsq_RestoreAllDatabases.ksh
- 3.9 sqwmsq_RestoreDatabase.ksh
- 3.10 sqwmsq_RotateErrorLog.ksh
- 3.11 sqwmsq_RunJob.ksh
- 3.12 sqwmsq_StatisticsAllDatabases.ksh
- 3.13 sqwmsq_StatisticsDatabase.ksh
- 4 etc
- 5 lib
- 6 menu
- 7 tools
- 8 spm
Presentation
Usage
It's the module locally operating of Mssql.
It is entirely written in ksh and sql.
It allows to manage the operation for Mssql.
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 Mssql
Explanation of directories
Directories located in $gvsqw_MsqBin:
- 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
Presentation
Usage
It's the module locally operating of mssql.
It is entirely written in ksh and sql.
It allows to manage the operation for mssql.
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 mssql
Explanation of directories
Directories located in $gvsqw_MssBin:
- 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
sqwmsq_BackupAllDatabases.ksh
Script $gvsqw_MssBin/../bin/sqwmsq_BackupAllDatabases.ksh:
Run sqwmsq_BackupDatabase.ksh in // for all databases
Voir l'aide détaillée pour sqwmsq_BackupAllDatabases.ksh
sqwmsq_BackupDatabase.ksh
Script $gvsqw_MssBin/../bin/sqwmsq_BackupDatabase.ksh:
Backup database
Voir l'aide détaillée pour sqwmsq_BackupDatabase.ksh
sqwmsq_CheckIndicators.ksh
Script $gvsqw_MssBin/../bin/sqwmsq_CheckIndicators.ksh:
Check indicators
Voir l'aide détaillée pour sqwmsq_CheckIndicators.ksh
sqwmsq_GatherIndicators.ksh
Script $gvsqw_MssBin/../bin/sqwmsq_GatherIndicators.ksh:
Gather indicators
Voir l'aide détaillée pour sqwmsq_GatherIndicators.ksh
sqwmsq_ParallelRun.ksh
Script $gvsqw_MssBin/../bin/sqwmsq_ParallelRun.ksh:
Run of commands in //
Voir l'aide détaillée pour sqwmsq_ParallelRun.ksh
sqwmsq_RebuildIndexAllDatabases.ksh
Script $gvsqw_MssBin/../bin/sqwmsq_RebuildIndexAllDatabases.ksh:
Run sqwmsq_RebuildIndexDatabase.ksh in // for all databases
Voir l'aide détaillée pour sqwmsq_RebuildIndexAllDatabases.ksh
sqwmsq_RebuildIndexDatabase.ksh
Script $gvsqw_MssBin/../bin/sqwmsq_RebuildIndexDatabase.ksh:
Rebuild indexes
Voir l'aide détaillée pour sqwmsq_RebuildIndexDatabase.ksh
sqwmsq_RestoreAllDatabases.ksh
Script $gvsqw_MssBin/../bin/sqwmsq_RestoreAllDatabases.ksh:
Run sqwmsq_RestoreDatabase.ksh in // for all databases
Voir l'aide détaillée pour sqwmsq_RestoreAllDatabases.ksh
sqwmsq_RestoreDatabase.ksh
Script $gvsqw_MssBin/../bin/sqwmsq_RestoreDatabase.ksh:
Restore database
Voir l'aide détaillée pour sqwmsq_RestoreDatabase.ksh
sqwmsq_RotateErrorLog.ksh
Script $gvsqw_MssBin/../bin/sqwmsq_RotateErrorLog.ksh:
Rotate error log
Voir l'aide détaillée pour sqwmsq_RotateErrorLog.ksh
sqwmsq_RunJob.ksh
Script $gvsqw_MssBin/../bin/sqwmsq_RunJob.ksh:
Run of Mssql scripts
Voir l'aide détaillée pour sqwmsq_RunJob.ksh
sqwmsq_StatisticsAllDatabases.ksh
Script $gvsqw_MssBin/../bin/sqwmsq_StatisticsAllDatabases.ksh:
Run sqwmsq_StatisticsDatabase.ksh in //for all databases
Voir l'aide détaillée pour sqwmsq_StatisticsAllDatabases.ksh
sqwmsq_StatisticsDatabase.ksh
Script $gvsqw_MssBin/../bin/sqwmsq_StatisticsDatabase.ksh:
Update stats
Voir l'aide détaillée pour sqwmsq_StatisticsDatabase.ksh
etc
sqwmsq_DbRefVar.cfg
Fichier de configuration $gvsqw_MssBin/../etc/sqwmsq_DbRefVar.cfg:
Global var for indicators
Il contient les variables de fonctionnement de SQWareProduction.
Voir l'aide détaillée pour sqwmsq_DbRefVar.cfg
sqwmsq_GlobalVar.cfg
Fichier de configuration $gvsqw_MssBin/../etc/sqwmsq_GlobalVar.cfg:
Global var
Il contient les variables de fonctionnement de SQWareProduction.
Voir l'aide détaillée pour sqwmsq_GlobalVar.cfg
sqwmsq_Jobs.cfg
Fichier de configuration $gvsqw_MssBin/../etc/sqwmsq_Jobs.cfg:
Voir l'aide détaillée pour sqwmsq_Jobs.cfg
.profile
Fichier d'exemple $gvsqw_MssBin/../etc/.profile:
Voir l'aide détaillée pour .profile
.profile_confort
Fichier de positionnement d'alias $gvsqw_MssBin/../etc/.profile_confort:
Voir l'aide détaillée pour .profile_confort
lib
sqwmsq_BackupDatabase.lib
Librairie de fonctions shell $gvsqw_MssBin/../lib/sqwmsq_BackupDatabase.lib:
lib for sqwmsq_BackupDatabase.ksh
Voir l'aide détaillée pour sqwmsq_BackupDatabase.lib
sqwmsq_CheckIndicators.lib
Librairie de fonctions shell $gvsqw_MssBin/../lib/sqwmsq_CheckIndicators.lib:
lib for sqwmsq_CheckIndicators.ksh
Voir l'aide détaillée pour sqwmsq_CheckIndicators.lib
sqwmsq_CheckIndicators_Overload.lib
Librairie de fonctions shell $gvsqw_MssBin/../lib/sqwmsq_CheckIndicators_Overload.lib:
temple lib for overload sqwmsq_CheckIndicators.ksh
Voir l'aide détaillée pour sqwmsq_CheckIndicators_Overload.lib
sqwmsq_GatherIndicators.lib
Librairie de fonctions shell $gvsqw_MssBin/../lib/sqwmsq_GatherIndicators.lib:
lib for sqwmsq_GatherIndicators.ksh
Voir l'aide détaillée pour sqwmsq_GatherIndicators.lib
sqwmsq_GatherIndicators_Overload.lib
Librairie de fonctions shell $gvsqw_MssBin/../lib/sqwmsq_GatherIndicators_Overload.lib:
lib for overload sqwmsq_GatherIndicators.ksh
Voir l'aide détaillée pour sqwmsq_GatherIndicators_Overload.lib
sqwmsq_Global.lib
Librairie de fonctions shell $gvsqw_MssBin/../lib/sqwmsq_Global.lib:
central lib of generic fonctions
Voir l'aide détaillée pour sqwmsq_Global.lib
sqwmsq_InsertIndicators.lib
Librairie de fonctions shell $gvsqw_MssBin/../lib/sqwmsq_InsertIndicators.lib:
generic fonctions to insert into referential
Voir l'aide détaillée pour sqwmsq_InsertIndicators.lib
sqwmsq_RestoreDatabase.lib
Librairie de fonctions shell $gvsqw_MssBin/../lib/sqwmsq_RestoreDatabase.lib:
lib for sqwmsq_RestoreDatabase.ksh
Voir l'aide détaillée pour sqwmsq_RestoreDatabase.lib
sqwmsq_SetEnv.lib
Librairie de fonctions shell $gvsqw_MssBin/../lib/sqwmsq_SetEnv.lib:
fonction to set env for Mssql
Voir l'aide détaillée pour sqwmsq_SetEnv.lib
tools
spm
Ensemble de requêtes sql usuelles déjà écrites
Voir l'aide détaillée pour spm