Difference between revisions of "SQWareProduction:sybase:lib:sqwsyb GatherIndicators.lib"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 6: | Line 6: | ||
gfsqw_BeginningCom | gfsqw_BeginningCom | ||
gfsqw_GatherHostInfos | gfsqw_GatherHostInfos | ||
| + | gfsqw_GatherPathInfos | ||
gfsqw_GenDatabasesList > $gvsqw_TmpFile.lst | gfsqw_GenDatabasesList > $gvsqw_TmpFile.lst | ||
gfsqw_InsertChanges | gfsqw_InsertChanges | ||
| Line 16: | Line 17: | ||
gfsqw_InsertIndicators "tables for $lvsqw_DbName" | gfsqw_InsertIndicators "tables for $lvsqw_DbName" | ||
gfsqw_InsertIndicators "users for $lvsqw_DbName" | gfsqw_InsertIndicators "users for $lvsqw_DbName" | ||
| + | gfsqw_PurgeLogDirAndFiles | ||
lfsqw_AllTables | lfsqw_AllTables | ||
lfsqw_AllTables => | lfsqw_AllTables => | ||
Latest revision as of 17:52, 27 September 2023
shell functions library $gvsqw_SybBin/../lib/sqwsyb_GatherIndicators.lib:
lib for sqwsyb_GatherIndicators.ksh
Functions explanation:
gfsqw_BeginningCom
gfsqw_GatherHostInfos
gfsqw_GatherPathInfos
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"
gfsqw_PurgeLogDirAndFiles
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 =>
