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

From Wiki_dbSQWare
Jump to navigation Jump to 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 => 


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 .