Difference between revisions of "SQWareProduction:postgres:lib:sqwpg GatherIndicators.lib"
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 17: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 =>
