Difference between revisions of "SQWareCentral:general"

Revision as of 23:20, 19 December 2010

Presentation

Usage

SQWareCentral, is the central point of dbSQWare for all RDBMS.
Usage examples:

Central point of ssh connections
Search of instances, database/schema, ...
Deployment scripts of SQWareProduction for each RDBMS managed
Collection of indicators for each RDBMS managed
Repeat of collection for each RDBMS managed
Execute any type of action on a list
...

Installation guide for SQWareCentral

Explanation of directories

Directories located in $gvsqw_RootexpdbCentral:

action : Directory containing specific files for each managed RDBMS
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)
logs : Directory containing logs and temporaries files
menu : Directory containing the standard menus
menu_cust : Directory containing the custom menus for your environnement

Warning:
Do not change the standard scripts and configuration files of dbSQWare.

Use directories *_cust for customizations. This will facilitate version upgrades.

General architecture diagram SQWareCentral (when the SQWareProduction module is locally installed)

action

oracle

Centralised actions for oracle
Allows you to perform actions on oracle instances centrally:

Collection of indicators
Deploying Scripts
Repeat of collection of indicators
...

See the detailed help for oracle

sybase

Centralised actions for sybase
Allows you to perform actions on sybase instances centrally:

Collection of indicators
Deploying Scripts
Repeat of collection of indicators
...

See the detailed help for sybase

mysql

Centralised actions for mysql
Allows you to perform actions on mysql instances centrally:

Collection of indicators
Deploying Scripts
Repeat of collection of indicators
...

See the detailed help for mysql

mssql

Centralised actions for mssql
Allows you to perform actions on mssql instances centrally:

Collection of indicators
Deploying Scripts
Repeat of collection of indicators
...

See the detailed help for mssql

mongodb

Centralised actions for mongodb
Allows you to perform actions on mongodb instances centrally:

Collection of indicators
Deploying Scripts
Repeat of collection of indicators
...

See the detailed help for mongodb

DB2

Centralised actions for DB2
Allows you to perform actions on DB2 instances centrally:

Collection of indicators
Deploying Scripts
Repeat of collection of indicators
...

See the detailed help for DB2

postgres

Centralised actions for PostgreSQL
Allows you to perform actions on postgres instances centrally:

Collection of indicators
Deploying Scripts
Repeat of collection of indicators
...

See the detailed help for PostgreSQL

teradata

Centralised actions for Teradata
Allows you to perform actions on teradata instances centrally:

Collection of indicators
Deploying Scripts
Repeat of collection of indicators
...

See the detailed help for Teradata

cassandra

Centralised actions for Cassandra
Allows you to perform actions on cassandra instances centrally:

Collection of indicators
Deploying Scripts
Repeat of collection of indicators
...

See the detailed help for Cassandra

ingres

Centralised actions for ingres
Allows you to perform actions on ingres instances centrally:

Collection of indicators
Deploying Scripts
Repeat of collection of indicators
...

See the detailed help for ingres

action

ingres

Centralised actions for ingres
Allows you to perform actions on ingres instances centrally:

Collection of indicators
Deploying Scripts
Repeat of collection of indicators
...

See the detailed help for ingres

mssql

Centralised actions for mssql
Allows you to perform actions on mssql instances centrally:

Collection of indicators
Deploying Scripts
Repeat of collection of indicators
...

See the detailed help for mssql

mysql

Centralised actions for mysql
Allows you to perform actions on mysql instances centrally:

Collection of indicators
Deploying Scripts
Repeat of collection of indicators
...

See the detailed help for mysql

oracle

Centralised actions for oracle
Allows you to perform actions on oracle instances centrally:

Collection of indicators
Deploying Scripts
Repeat of collection of indicators
...

See the detailed help for oracle

sybase

Centralised actions for sybase
Allows you to perform actions on sybase instances centrally:

Collection of indicators
Deploying Scripts
Repeat of collection of indicators
...

See the detailed help for sybase

bin

sqwc_Connect.ksh

Script $gvsqw_RootexpdbCentral/bin/sqwc_Connect.ksh:
Can connect via ssh on the server hosting the requested instance from the center point (from reference files of instances).
Accessible by the alias 'c'.
See the detailed help for sqwc_Connect.ksh

sqwc_SearchDatabase.ksh

Script $gvsqw_RootexpdbCentral/bin/sqwc_SearchDatabase.ksh:
Search on the string passed as argument in the database reference file.
Accessible by the alias 'cb'.
See the detailed help for sqwc_SearchDatabase.ksh

sqwc_SearchInstance.ksh

Script $gvsqw_RootexpdbCentral/bin/sqwc_SearchInstance.ksh:
Search on the string passed as argument in the instances reference file.
Accessible by the alias 'ch'.
See the detailed help for sqwc_SearchInstance.ksh

sqwc_Show.ksh

Script $gvsqw_RootexpdbCentral/bin/sqwc_Show.ksh:
Manages an online help on variables, aliases, ... of SQWareCentral.
Accessible by the alias 'show'.
See the detailed help for sqwc_Show.ksh

sqwc_TrtAuto.ksh

Script $gvsqw_RootexpdbCentral/bin/sqwc_TrtAuto.ksh:
Can run on one type of DBMS (passed as parameter), action (passed as parameter), on the list of users or instances (passed as parameter).
See available actions:

See available list generators:

See the detailed help for sqwc_TrtAuto.ksh

etc

sqwc_Aliases_en.hlp

Help file $gvsqw_RootexpdbCentral/etc/sqwc_Aliases_en.hlp:
English help on aliases of SQWareCentral.

sqwc_Aliases_fr.hlp

Help file $gvsqw_RootexpdbCentral/etc/sqwc_Aliases_fr.hlp:
French help on aliases of SQWareCentral.

sqwc_General_en.hlp

Help file $gvsqw_RootexpdbCentral/etc/sqwc_General_en.hlp:
English general help on SQWareCentral.

sqwc_General_fr.hlp

Help file $gvsqw_RootexpdbCentral/etc/sqwc_General_fr.hlp:
French general help on SQWareCentral.

sqwc_GlobalVar.cfg

Configuration file $gvsqw_RootexpdbCentral/etc/sqwc_GlobalVar.cfg:
Contains global variables of SQWareCentral gvsqw_xxx.
See the detailed help for sqwc_GlobalVar.cfg

sqwc_Lang.cfg

Configuration file $gvsqw_RootexpdbCentral/etc/sqwc_Lang.cfg:
Contains the language variable for expdbcentral.
See the detailed help for sqwc_Lang.cfg

sqwc_Var_en.hlp

Help file $gvsqw_RootexpdbCentral/etc/sqwc_Var_en.hlp:
English help on variables of SQWareCentral.

sqwc_Var_fr.hlp

Help file $gvsqw_RootexpdbCentral/etc/sqwc_Var_fr.hlp:
French help on variables of SQWareCentral.

licenceGPL.txt

File $gvsqw_RootexpdbCentral/etc/licenceGPL.txt:
GPL licence file.
See the detailed help for licenceGPL.txt

.profile

Profile file $gvsqw_RootexpdbCentral/etc/.profile:
Profile file for SQWareCentral user.
Load all configuration files.

.profile_confort

File to put aliases $gvsqw_RootexpdbCentral/etc/.profile_confort:
Contains confort aliases of SQWareCentral.
Load all .profile_confort.

Note:
You can overload $gvsqw_RootexpdbCentral/etc/.profile_confort

by $gvsqw_RootexpdbCentral/etc/.profile_confort for all your environnement
or by $HOME/edtConfig/.profile_confort specifically for this user..

lib

sqwc_Global.lib

shell functions librairy $gvsqw_RootexpdbCentral/lib/sqwc_Global.lib:
Contains the global function to scripts gfsqw_xxx()
See the detailed help for sqwc_Global.lib

logs

help

Contains help files for -s option of bin scripts.

@@ Line 1: / Line 1: @@
 {{SQWareCentralPres}}
-== Action ==
+== action ==
-=== Mssql ===
+=== ingres ===
-Centralised actions for Mssql<br>
+Centralised actions for ingres<br>
-Allows you to perform actions on Mssql instances centrally:
+Allows you to perform actions on ingres instances centrally:
-* Collection of indicators
+*Collection of indicators
-* Deploying Scripts
+*Deploying Scripts
-* Repeat of collection of indicators
+*Repeat of collection of indicators
+*...
+[[SQWareCentral:ingres|See the detailed help for ingres]]<br>
+<br>
+=== mssql ===
+Centralised actions for mssql<br>
+Allows you to perform actions on mssql instances centrally:
+*Collection of indicators
+*Deploying Scripts
+*Repeat of collection of indicators
 *...
 [[SQWareCentral:mssql|See the detailed help for mssql]]<br>
 <br>
+=== mysql ===
-=== Mysql ===
+Centralised actions for mysql<br>
-Centralised actions for Mysql<br>
+Allows you to perform actions on mysql instances centrally:
-Allows you to perform actions on Mysql instances centrally:
+*Collection of indicators
-* Collection of indicators
+*Deploying Scripts
-* Deploying Scripts
+*Repeat of collection of indicators
-* Repeat of collection of indicators
 *...
 [[SQWareCentral:mysql|See the detailed help for mysql]]<br>
 <br>
+=== oracle ===
-=== Oracle ===
+Centralised actions for oracle<br>
-Centralised actions for Oracle<br>
+Allows you to perform actions on oracle instances centrally:
-Allows you to perform actions on Oracle instances centrally:
+*Collection of indicators
-* Collection of indicators
+*Deploying Scripts
-* Deploying Scripts
+*Repeat of collection of indicators
-* Repeat of collection of indicators
 *...
 [[SQWareCentral:oracle|See the detailed help for oracle]]<br>
 <br>
+=== sybase ===
-=== Sybase ===
+Centralised actions for sybase<br>
-Centralised actions for Sybase<br>
+Allows you to perform actions on sybase instances centrally:
-Allows you to perform actions on Sybase dataservers centrally:
+*Collection of indicators
-* Collection of indicators
+*Deploying Scripts
-* Deploying Scripts
+*Repeat of collection of indicators
-* Repeat of collection of indicators
 *...
 [[SQWareCentral:sybase|See the detailed help for sybase]]<br>
 <br>
-=== Ingres ===
-Centralised actions for Ingres<br>
-Allows you to perform actions on Ingres instances centrally:
-* Collection of indicators
-* Deploying Scripts
-* Repeat of collection of indicators
-*...
-[[SQWareCentral:ingres|See the detailed help for ingres]]<br>
 <br>
@@ Line 55: / Line 52: @@
 === sqwc_Connect.ksh ===
 Script $gvsqw_RootexpdbCentral/bin/sqwc_Connect.ksh:<br>
-permet de se connecter par ssh sur le serveur hébergeant l'instance demandée depuis le point central (à partir des fichiers de référence d'instances).<br>
+{{SQWareCentral_sqwc_Connect.ksh_presentation}}
-accessible par l'alias 'c'.<br>
+[[SQWareCentral:bin:sqwc_Connect.ksh|See the detailed help for sqwc_Connect.ksh]]<br>
-[[SQWareCentral:bin:sqwc_Connect.ksh|Voir l'aide détaillée pour sqwc_Connect.ksh]]<br><br>
 === sqwc_SearchDatabase.ksh ===
 Script $gvsqw_RootexpdbCentral/bin/sqwc_SearchDatabase.ksh:<br>
-lance une recherche sur la chaine passée en argument dans les fichiers de référence database.<br>
+{{SQWareCentral_sqwc_SearchDatabase.ksh_presentation}}
-accessible par l'alias 'cb'.<br>
+[[SQWareCentral:bin:sqwc_SearchDatabase.ksh|See the detailed help for sqwc_SearchDatabase.ksh]]<br>
-[[SQWareCentral:bin:sqwc_SearchDatabase.ksh|Voir l'aide détaillée pour sqwc_SearchDatabase.ksh]]<br><br>
 === sqwc_SearchInstance.ksh ===
 Script $gvsqw_RootexpdbCentral/bin/sqwc_SearchInstance.ksh:<br>
-lance une recherche sur la chaine passée en argument dans les fichiers de référence instance.<br>
+{{SQWareCentral_sqwc_SearchInstance.ksh_presentation}}
-accessible par l'alias 'ch'.<br>
+[[SQWareCentral:bin:sqwc_SearchInstance.ksh|See the detailed help for sqwc_SearchInstance.ksh]]<br>
-[[SQWareCentral:bin:sqwc_SearchInstance.ksh|Voir l'aide détaillée pour sqwc_SearchInstance.ksh]]<br><br>
 === sqwc_Show.ksh ===
 Script $gvsqw_RootexpdbCentral/bin/sqwc_Show.ksh:<br>
-gère une aide en ligne sur les variables, alias, ... de SQWareCentral.<br>
+{{SQWareCentral_sqwc_Show.ksh_presentation}}
-accéssible par l'alias 'show'.<br>
+[[SQWareCentral:bin:sqwc_Show.ksh|See the detailed help for sqwc_Show.ksh]]<br>
-[[SQWareCentral:bin:sqwc_Show.ksh|Voir l'aide détaillée pour sqwc_Show.ksh]]<br><br>
 === sqwc_TrtAuto.ksh ===
 Script $gvsqw_RootexpdbCentral/bin/sqwc_TrtAuto.ksh:<br>
-permet d'exécuter sur un type de SGBD (passée en paramètre), une action (passée en paramètre), sur la liste d'instances ou de users (passée en paramètre).<br>
+{{SQWareCentral_sqwc_TrtAuto.ksh_presentation}}
-[[SQWareCentral:bin:sqwc_TrtAuto.ksh|Voir l'aide détaillée pour sqwc_TrtAuto.ksh]]<br>
+[[SQWareCentral:bin:sqwc_TrtAuto.ksh|See the detailed help for sqwc_TrtAuto.ksh]]<br>
-Voir les actions disponibles:
+<br>
-*[[SQWareCentral:mssql#auto|MsSql]]
-*[[SQWareCentral:mysql#auto|MySql]]
-*[[SQWareCentral:oracle#auto|Oracle]]
-*[[SQWareCentral:sybase#auto|Sybase]]
-Voir les listes disponibles:
-*[[SQWareCentral:mssql#lst|MsSql]]
-*[[SQWareCentral:mysql#lst|MySql]]
-*[[SQWareCentral:oracle#lst|Oracle]]
-*[[SQWareCentral:sybase#lst|Sybase]]
-<br><br>
 == etc ==
-=== .profile ===
-Fichier de positionnement d'environnement $gvsqw_RootexpdbCentral/etc/.profile:<br>
-contient l'initialisation des variables d'environnement de SQWareCentral.<br>
-[[SQWareCentral:etc:.profile|Voir l'aide détaillée pour .profile]]<br><br>
-=== .profile_confort ===
-Fichier de positionnement de l'environnement confort $gvsqw_RootexpdbCentral/etc/.profile_confort:<br>
-contient l'initialisation des alias, prompt, entête putty, ... de SQWareCentral lorsque la session est rattachée à un terminal.<br>
-[[SQWareCentral:etc:.profile_confort|Voir l'aide détaillée pour .profile_confort]]<br><br>
 === sqwc_Aliases_en.hlp ===
-Fichier d'aide $gvsqw_RootexpdbCentral/etc/sqwc_Aliases_en.hlp:<br>
+Help file $gvsqw_RootexpdbCentral/etc/sqwc_Aliases_en.hlp:<br>
-contient l'aide en anglais pour les alias de SQWareCentral.<br><br>
+{{SQWareCentral_sqwc_Aliases_en.hlp_presentation}}
 === sqwc_Aliases_fr.hlp ===
-Fichier d'aide $gvsqw_RootexpdbCentral/etc/sqwc_Aliases_fr.hlp:<br>
+Help file $gvsqw_RootexpdbCentral/etc/sqwc_Aliases_fr.hlp:<br>
-contient l'aide en français pour les alias de SQWareCentral.<br><br>
+{{SQWareCentral_sqwc_Aliases_fr.hlp_presentation}}
+=== sqwc_General_en.hlp ===
+Help file $gvsqw_RootexpdbCentral/etc/sqwc_General_en.hlp:<br>
+{{SQWareCentral_sqwc_General_en.hlp_presentation}}
+=== sqwc_General_fr.hlp ===
+Help file $gvsqw_RootexpdbCentral/etc/sqwc_General_fr.hlp:<br>
+{{SQWareCentral_sqwc_General_fr.hlp_presentation}}
 === sqwc_GlobalVar.cfg ===
-Fichier de configuration $gvsqw_RootexpdbCentral/etc/sqwc_GlobalVar.cfg:<br>
+Configuration file $gvsqw_RootexpdbCentral/etc/sqwc_GlobalVar.cfg:<br>
-contient les variables globales de SQWareCentral $gvsqw_yyy.<br>
+{{SQWareCentral_sqwc_GlobalVar.cfg_presentation}}
-[[SQWareCentral:etc:sqwc_GlobalVar.cfg|Voir l'aide détaillée pour sqwc_GlobalVar.cfg]]<br><br>
+[[SQWareCentral:etc:sqwc_GlobalVar.cfg|See the detailed help for sqwc_GlobalVar.cfg]]<br>
 === sqwc_Lang.cfg ===
-Fichier de configuration $gvsqw_RootexpdbCentral/etc/sqwc_Lang.cfg:<br>
+Configuration file $gvsqw_RootexpdbCentral/etc/sqwc_Lang.cfg:<br>
-contient la variable de langue pour expdbcentral.<br>
+{{SQWareCentral_sqwc_Lang.cfg_presentation}}
-[[SQWareCentral:etc:sqwc_Lang.cfg|Voir l'aide détaillée pour sqwc_Lang.cfg]]<br><br>
+[[SQWareCentral:etc:sqwc_Lang.cfg|See the detailed help for sqwc_Lang.cfg]]<br>
 === sqwc_Var_en.hlp ===
-Fichier d'aide $gvsqw_RootexpdbCentral/etc/sqwc_Var_en.hlp:<br>
+Help file $gvsqw_RootexpdbCentral/etc/sqwc_Var_en.hlp:<br>
-contient l'aide en anglais pour les variables de SQWareCentral.<br><br>
+{{SQWareCentral_sqwc_Var_en.hlp_presentation}}
 === sqwc_Var_fr.hlp ===
-Fichier d'aide $gvsqw_RootexpdbCentral/etc/sqwc_Var_fr.hlp:<br>
+Help file $gvsqw_RootexpdbCentral/etc/sqwc_Var_fr.hlp:<br>
-contient l'aide en français pour les variables de SQWareCentral.<br><br>
+{{SQWareCentral_sqwc_Var_fr.hlp_presentation}}
 === licenceGPL.txt ===
-Fichier $gvsqw_RootexpdbCentral/etc/licenceGPL.txt:<br>
+File $gvsqw_RootexpdbCentral/etc/licenceGPL.txt:<br>
-contient la licence GPL V3<br>
+{{SQWareCentral_licenceGPL.txt_presentation}}
-[[SQWareCentral:etc:licenceGPL.txt|Voir l'aide détaillée pour licenceGPL.txt]]<br>
+[[SQWareCentral:etc:licenceGPL.txt|See the detailed help for licenceGPL.txt]]<br>
-<br><br>
+=== .profile ===
+Profile file $gvsqw_RootexpdbCentral/etc/.profile:<br>
+Profile file for SQWareCentral user.<br>
+Load all configuration files.<br>
+=== .profile_confort ===
+File to put aliases $gvsqw_RootexpdbCentral/etc/.profile_confort:<br>
+Contains confort aliases of SQWareCentral.<br>
+Load all .profile_confort.<br>
+{{SQWareCentralSurchargeConfort}}
+<br>
+<br>
 == lib ==
 === sqwc_Global.lib ===
-Librairie de fonctions shell $gvsqw_RootexpdbCentral/lib/sqwc_Global.lib:<br>
+shell functions librairy $gvsqw_RootexpdbCentral/lib/sqwc_Global.lib:<br>
-contient les fonction globales aux scripts gfsqw_xxx().<br>
+{{SQWareProduction_sqwc_Global.lib_presentation}}
-[[SQWareCentral:lib:sqwc_Global.lib|Voir l'aide détaillée pour sqwc_Global.lib]]<br><br>
+[[SQWareCentral:lib:sqwc_Global.lib|See the detailed help for sqwc_Global.lib]]<br>
+<br>
-<br><br>
+== logs ==
+<br>
-== logs ==
+== menu ==
-Répertoire contenant les logs et les fichiers temporaires de SQWareCentral<br><br>
+<br>
+== help ==
+Contains help files for -s option of bin scripts.<br>
 <br><br>

Difference between revisions of "SQWareCentral:general"

Revision as of 23:20, 19 December 2010

Contents

Presentation

Usage

Explanation of directories

General architecture diagram SQWareCentral (when the SQWareProduction module is locally installed)

action

oracle

sybase

mysql

mssql

mongodb

DB2

postgres

teradata

cassandra

ingres

action

ingres

mssql

mysql

oracle

sybase

bin

sqwc_Connect.ksh

sqwc_SearchDatabase.ksh

sqwc_SearchInstance.ksh

sqwc_Show.ksh

sqwc_TrtAuto.ksh

etc

sqwc_Aliases_en.hlp

sqwc_Aliases_fr.hlp

sqwc_General_en.hlp

sqwc_General_fr.hlp

sqwc_GlobalVar.cfg

sqwc_Lang.cfg

sqwc_Var_en.hlp

sqwc_Var_fr.hlp

licenceGPL.txt

.profile

.profile_confort

lib

sqwc_Global.lib

logs

menu

help

Navigation menu

Search