Difference between revisions of "SQWareProduction:sybase:lib:sqwsyb GatherIndicators.lib"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
Line 9: Line 9:
 
gfsqw_InsertIndicators "databases"
 
gfsqw_InsertIndicators "databases"
 
gfsqw_InsertIndicators "dataserver"
 
gfsqw_InsertIndicators "dataserver"
 +
gfsqw_InsertIndicators "del users"
 
gfsqw_InsertIndicators "parameters"
 
gfsqw_InsertIndicators "parameters"
 
gfsqw_InsertIndicators "tables for $lvsqw_DbName"
 
gfsqw_InsertIndicators "tables for $lvsqw_DbName"
 +
gfsqw_InsertIndicators "users for $lvsqw_DbName"
 
lfsqw_AllTables =>  
 
lfsqw_AllTables =>  
 
lfsqw_ArchivingDb =>  
 
lfsqw_ArchivingDb =>  
Line 24: Line 26:
 
lfsqw_GatherParameters =>  
 
lfsqw_GatherParameters =>  
 
lfsqw_GenerateInsertAlert > ${gvsqw_TmpFile}.sql
 
lfsqw_GenerateInsertAlert > ${gvsqw_TmpFile}.sql
 +
lfsqw_GenerateListFsDbf =>
 
lfsqw_GenInsertDatabases =>  
 
lfsqw_GenInsertDatabases =>  
 
lfsqw_GenInsertDatabases > ${gvsqw_TmpFile}.sql
 
lfsqw_GenInsertDatabases > ${gvsqw_TmpFile}.sql
Line 35: Line 38:
 
lfsqw_Parameters | tee ${gvsqw_TmpFile}
 
lfsqw_Parameters | tee ${gvsqw_TmpFile}
 
lfsqw_Tables =>  
 
lfsqw_Tables =>  
 +
lfsqw_Users =>
 
</pre>
 
</pre>
 
<br>
 
<br>
 
{{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_GatherIndicators.lib}}
 
{{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_GatherIndicators.lib}}
 
<br>
 
<br>

Revision as of 17:25, 28 December 2021

shell functions library $gvsqw_SybBin/../lib/sqwsyb_GatherIndicators.lib:
lib for sqwsyb_GatherIndicators.ksh
Functions explanation:

gfsqw_GenDatabasesList > $gvsqw_TmpFile.lst
gfsqw_InsertIndicators "Alert"
gfsqw_InsertIndicators "archivingDb"
gfsqw_InsertIndicators "databases"
gfsqw_InsertIndicators "dataserver"
gfsqw_InsertIndicators "del users"
gfsqw_InsertIndicators "parameters"
gfsqw_InsertIndicators "tables for $lvsqw_DbName"
gfsqw_InsertIndicators "users for $lvsqw_DbName"
lfsqw_AllTables => 
lfsqw_ArchivingDb => 
lfsqw_ArchivingParameters
lfsqw_Databases
lfsqw_Databases => 
lfsqw_Dataserver => 
lfsqw_Dataserver | tee ${gvsqw_TmpFile}
lfsqw_GatherAlertLogFile => 
lfsqw_GatherDatabases => 
lfsqw_GatherDataserver => 
lfsqw_GatherFs => 
lfsqw_GatherParameters => 
lfsqw_GenerateInsertAlert > ${gvsqw_TmpFile}.sql
lfsqw_GenerateListFsDbf => 
lfsqw_GenInsertDatabases => 
lfsqw_GenInsertDatabases > ${gvsqw_TmpFile}.sql
lfsqw_GenInsertDataserver => 
lfsqw_GenInsertDataserver > ${gvsqw_TmpFile}.sql
lfsqw_GenInsertParameters => 
lfsqw_GenInsertParameters > ${gvsqw_TmpFile}.sql
lfsqw_GenInsertTables
lfsqw_GenInsertTables => 
lfsqw_Parameters => 
lfsqw_Parameters | tee ${gvsqw_TmpFile}
lfsqw_Tables => 
lfsqw_Users => 


Nuvola apps information.png
Note:
You can overload functions contained in $gvsqw_SybBin/../lib/sqwsyb_GatherIndicators.lib

by function with same name in $gvsqw_SybBin/../lib_cust/sqwsyb_GatherIndicators.lib for all your environnement
or by $HOME/sqwConfig/sqwsyb_GatherIndicators.lib specifically for this user .