Difference between revisions of "SQWareProduction:postgres:lib:sqwpg GatherIndicators.lib"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
Line 22: Line 22:
 
lfsqw_GatherTables =>  
 
lfsqw_GatherTables =>  
 
lfsqw_GatherTablesSql =>  
 
lfsqw_GatherTablesSql =>  
 +
lfsqw_GatherUsers =>
 
lfsqw_GenerateInsertAlert
 
lfsqw_GenerateInsertAlert
 
lfsqw_GenerateInsertLicenses
 
lfsqw_GenerateInsertLicenses
Line 27: Line 28:
 
lfsqw_GenerateInsertParameters
 
lfsqw_GenerateInsertParameters
 
lfsqw_GenerateInsertParameters =>  
 
lfsqw_GenerateInsertParameters =>  
 +
lfsqw_GenerateListFsDbf =>
 
</pre>
 
</pre>
 
<br>
 
<br>
 
{{SQWareProductionSurchargeLib|postgres|Pg|sqwpg_GatherIndicators.lib}}
 
{{SQWareProductionSurchargeLib|postgres|Pg|sqwpg_GatherIndicators.lib}}
 
<br>
 
<br>

Revision as of 16:25, 28 December 2021

shell functions library $gvsqw_PgBin/../lib/sqwpg_GatherIndicators.lib:
lib for sqwpg_GatherIndicators.ksh
Functions explanation:

gfsqw_GenListDatabase > $gvsqw_TmpFile.lst
gfsqw_InsertIndicators "Alert"
gfsqw_InsertIndicators "ArchiveXlog"
gfsqw_InsertIndicators "archivingDb"
gfsqw_InsertIndicators "Licenses"
gfsqw_InsertIndicators "Parameters"
lfsqw_ArchiveXlog => 
lfsqw_ArchivingDb => 
lfsqw_ArchivingParameters
lfsqw_GatherAlertLogFile => 
lfsqw_GatherDatabase => 
lfsqw_GatherDatabaseSql => 
lfsqw_GatherDatabaseSql 2>&1 > ${gvsqw_TmpFile}
lfsqw_GatherFs => 
lfsqw_GatherOverLoaded 2>&1
lfsqw_GatherParameters => 
lfsqw_GatherTables => 
lfsqw_GatherTablesSql => 
lfsqw_GatherUsers => 
lfsqw_GenerateInsertAlert
lfsqw_GenerateInsertLicenses
lfsqw_GenerateInsertLicenses => 
lfsqw_GenerateInsertParameters
lfsqw_GenerateInsertParameters => 
lfsqw_GenerateListFsDbf => 


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

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