Difference between revisions of "SQWareProduction:sybase:lib:sqwsyb GatherIndicators.lib"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
| (4 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_GenDatabasesList > $gvsqw_TmpFile.lst | gfsqw_GenDatabasesList > $gvsqw_TmpFile.lst | ||
| + | gfsqw_InsertChanges | ||
gfsqw_InsertIndicators "Alert" | gfsqw_InsertIndicators "Alert" | ||
| + | gfsqw_InsertIndicators "archivingDb" | ||
gfsqw_InsertIndicators "databases" | gfsqw_InsertIndicators "databases" | ||
gfsqw_InsertIndicators "dataserver" | gfsqw_InsertIndicators "dataserver" | ||
| + | gfsqw_InsertIndicators "del users" | ||
gfsqw_InsertIndicators "parameters" | gfsqw_InsertIndicators "parameters" | ||
gfsqw_InsertIndicators "tables for $lvsqw_DbName" | gfsqw_InsertIndicators "tables for $lvsqw_DbName" | ||
| + | gfsqw_InsertIndicators "users for $lvsqw_DbName" | ||
| + | gfsqw_PurgeLogDirAndFiles | ||
| + | lfsqw_AllTables | ||
lfsqw_AllTables => | lfsqw_AllTables => | ||
| + | lfsqw_Archiving | ||
| + | lfsqw_ArchivingDb => | ||
lfsqw_ArchivingParameters | lfsqw_ArchivingParameters | ||
lfsqw_Databases | lfsqw_Databases | ||
| Line 16: | Line 27: | ||
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 | ||
| + | lfsqw_GenerateListFsDbf => | ||
lfsqw_GenInsertDatabases => | lfsqw_GenInsertDatabases => | ||
lfsqw_GenInsertDatabases > ${gvsqw_TmpFile}.sql | lfsqw_GenInsertDatabases > ${gvsqw_TmpFile}.sql | ||
| Line 30: | Line 48: | ||
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 => | ||
</pre> | </pre> | ||
<br> | <br> | ||
{{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_GatherIndicators.lib}} | {{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_GatherIndicators.lib}} | ||
<br> | <br> | ||
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 =>
