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

From Wiki_dbSQWare
Jump to navigation Jump to search
← Older editNewer edit →
m Updated by BatchUser
m Updated by BatchUser
Line 4: Line 4:
Functions explanation:
Functions explanation:
<pre>
<pre>
gfsqw_BeginningCom
gfsqw_GatherHostInfos
gfsqw_GenDatabasesList > $gvsqw_TmpFile.lst
gfsqw_GenDatabasesList > $gvsqw_TmpFile.lst
gfsqw_InsertChanges
gfsqw_InsertIndicators "Alert"
gfsqw_InsertIndicators "Alert"
gfsqw_InsertIndicators "archivingDb"
gfsqw_InsertIndicators "archivingDb"
Line 13: Line 16:
gfsqw_InsertIndicators "tables for $lvsqw_DbName"
gfsqw_InsertIndicators "tables for $lvsqw_DbName"
gfsqw_InsertIndicators "users for $lvsqw_DbName"
gfsqw_InsertIndicators "users for $lvsqw_DbName"
lfsqw_AllTables
lfsqw_AllTables =>  
lfsqw_AllTables =>  
lfsqw_Archiving
lfsqw_ArchivingDb =>  
lfsqw_ArchivingDb =>  
lfsqw_ArchivingParameters
lfsqw_ArchivingParameters
Line 20: Line 25:
lfsqw_Dataserver =>  
lfsqw_Dataserver =>  
lfsqw_Dataserver | tee ${gvsqw_TmpFile}
lfsqw_Dataserver | tee ${gvsqw_TmpFile}
lfsqw_GatherAlertLogFile
lfsqw_GatherAlertLogFile =>  
lfsqw_GatherAlertLogFile =>  
lfsqw_GatherDatabases
lfsqw_GatherDatabases =>  
lfsqw_GatherDatabases =>  
lfsqw_GatherDataserver
lfsqw_GatherDataserver =>  
lfsqw_GatherDataserver =>  
lfsqw_GatherFs
lfsqw_GatherFs =>  
lfsqw_GatherFs =>  
lfsqw_GatherOverLoaded
lfsqw_GatherParameters
lfsqw_GatherParameters =>  
lfsqw_GatherParameters =>  
lfsqw_GenerateInsertAlert > ${gvsqw_TmpFile}.sql
lfsqw_GenerateInsertAlert > ${gvsqw_TmpFile}.sql
Line 35: Line 46:
lfsqw_GenInsertTables
lfsqw_GenInsertTables
lfsqw_GenInsertTables =>  
lfsqw_GenInsertTables =>  
lfsqw_Main =>
lfsqw_Parameters =>  
lfsqw_Parameters =>  
lfsqw_Parameters | tee ${gvsqw_TmpFile}
lfsqw_Parameters | tee ${gvsqw_TmpFile}
lfsqw_PostArchivingParameters
lfsqw_Tables =>  
lfsqw_Tables =>  
lfsqw_Users =>  
lfsqw_Users =>  

Revision as of 18:21, 24 January 2023

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

gfsqw_BeginningCom
gfsqw_GatherHostInfos
gfsqw_GenDatabasesList > $gvsqw_TmpFile.lst
gfsqw_InsertChanges
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_AllTables => 
lfsqw_Archiving
lfsqw_ArchivingDb => 
lfsqw_ArchivingParameters
lfsqw_Databases
lfsqw_Databases => 
lfsqw_Dataserver => 
lfsqw_Dataserver | tee ${gvsqw_TmpFile}
lfsqw_GatherAlertLogFile
lfsqw_GatherAlertLogFile => 
lfsqw_GatherDatabases
lfsqw_GatherDatabases => 
lfsqw_GatherDataserver
lfsqw_GatherDataserver => 
lfsqw_GatherFs
lfsqw_GatherFs => 
lfsqw_GatherOverLoaded
lfsqw_GatherParameters
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_Main => 
lfsqw_Parameters => 
lfsqw_Parameters | tee ${gvsqw_TmpFile}
lfsqw_PostArchivingParameters
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 .


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:sybase:lib:sqwsyb_GatherIndicators.lib&oldid=22457"