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

From Wiki_dbSQWare
Jump to navigation Jump to search
m Updated by BatchUser
m Updated by BatchUser
 
(8 intermediate revisions by the same user not shown)
Line 4: Line 4:
Functions explanation:
Functions explanation:
<pre>
<pre>
gfsqw_BeginningCom
gfsqw_GatherHostInfos
gfsqw_GatherPathInfos
gfsqw_GenListDatabase > $gvsqw_TmpFile.lst
gfsqw_GenListDatabase > $gvsqw_TmpFile.lst
gfsqw_InitPurges
gfsqw_InsertChanges
gfsqw_InsertIndicators "Alert"
gfsqw_InsertIndicators "Alert"
gfsqw_InsertIndicators "ArchiveXlog"
gfsqw_InsertIndicators "archivingDb"
gfsqw_InsertIndicators "archiving extensions"
gfsqw_InsertIndicators "IsInRecovery"
gfsqw_InsertIndicators "Licenses"
gfsqw_InsertIndicators "Licenses"
gfsqw_InsertIndicators "Parameters"
gfsqw_InsertIndicators "Parameters"
gfsqw_PurgeLogDirAndFiles
lfsqw_AddPathInfos
lfsqw_AddPathInfos =>
lfsqw_ArchiveXlog =>
lfsqw_Archiving
lfsqw_ArchivingDb =>
lfsqw_ArchivingExtensions
lfsqw_ArchivingExtensions =>
lfsqw_ArchivingParameters
lfsqw_GatherAlertLogFile
lfsqw_GatherAlertLogFile =>  
lfsqw_GatherAlertLogFile =>  
lfsqw_GatherDatabase
lfsqw_GatherDatabase =>  
lfsqw_GatherDatabase =>  
lfsqw_GatherDatabaseCitusSql =>
lfsqw_GatherDatabaseDetail
lfsqw_GatherDatabaseDetail =>
lfsqw_GatherDatabaseDetailSql =>
lfsqw_GatherDatabaseSql =>  
lfsqw_GatherDatabaseSql =>  
lfsqw_GatherDatabaseSql 2>&1 > ${gvsqw_TmpFile}
lfsqw_GatherDatabaseSql 2>&1 > ${gvsqw_TmpFile}
lfsqw_GatherFs
lfsqw_GatherFs =>  
lfsqw_GatherFs =>  
lfsqw_GatherOverLoaded 2>&1
lfsqw_GatherOverLoaded 2>&1
lfsqw_GatherParameters
lfsqw_GatherParameters =>  
lfsqw_GatherParameters =>  
lfsqw_GatherTables =>
lfsqw_GatherUsers
lfsqw_GatherTablesSql =>  
lfsqw_GatherUsers =>  
lfsqw_GenerateInsertAlert
lfsqw_GenerateInsertAlert
lfsqw_GenerateInsertLicenses
lfsqw_GenerateInsertLicenses
Line 22: Line 48:
lfsqw_GenerateInsertParameters
lfsqw_GenerateInsertParameters
lfsqw_GenerateInsertParameters =>  
lfsqw_GenerateInsertParameters =>  
lfsqw_GenerateListFsDbf =>
lfsqw_IsInRecovery
lfsqw_IsInRecovery =>
lfsqw_Main =>
lfsqw_PostArchivingParameters
</pre>
</pre>
<br>
<br>
{{SQWareProductionSurchargeLib|postgres|Pg|sqwpg_GatherIndicators.lib}}
{{SQWareProductionSurchargeLib|postgres|Pg|sqwpg_GatherIndicators.lib}}
<br>
<br>

Latest revision as of 16:02, 23 February 2025

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

gfsqw_BeginningCom
gfsqw_GatherHostInfos
gfsqw_GatherPathInfos
gfsqw_GenListDatabase > $gvsqw_TmpFile.lst
gfsqw_InitPurges
gfsqw_InsertChanges
gfsqw_InsertIndicators "Alert"
gfsqw_InsertIndicators "ArchiveXlog"
gfsqw_InsertIndicators "archivingDb"
gfsqw_InsertIndicators "archiving extensions"
gfsqw_InsertIndicators "IsInRecovery"
gfsqw_InsertIndicators "Licenses"
gfsqw_InsertIndicators "Parameters"
gfsqw_PurgeLogDirAndFiles
lfsqw_AddPathInfos
lfsqw_AddPathInfos => 
lfsqw_ArchiveXlog => 
lfsqw_Archiving
lfsqw_ArchivingDb => 
lfsqw_ArchivingExtensions
lfsqw_ArchivingExtensions => 
lfsqw_ArchivingParameters
lfsqw_GatherAlertLogFile
lfsqw_GatherAlertLogFile => 
lfsqw_GatherDatabase
lfsqw_GatherDatabase => 
lfsqw_GatherDatabaseCitusSql => 
lfsqw_GatherDatabaseDetail
lfsqw_GatherDatabaseDetail => 
lfsqw_GatherDatabaseDetailSql => 
lfsqw_GatherDatabaseSql => 
lfsqw_GatherDatabaseSql 2>&1 > ${gvsqw_TmpFile}
lfsqw_GatherFs
lfsqw_GatherFs => 
lfsqw_GatherOverLoaded 2>&1
lfsqw_GatherParameters
lfsqw_GatherParameters => 
lfsqw_GatherUsers
lfsqw_GatherUsers => 
lfsqw_GenerateInsertAlert
lfsqw_GenerateInsertLicenses
lfsqw_GenerateInsertLicenses => 
lfsqw_GenerateInsertParameters
lfsqw_GenerateInsertParameters => 
lfsqw_GenerateListFsDbf => 
lfsqw_IsInRecovery
lfsqw_IsInRecovery => 
lfsqw_Main => 
lfsqw_PostArchivingParameters


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 .