Difference between revisions of "SQWareProduction:sybase:lib:sqwsyb GatherIndicators.lib"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
Line 4: | Line 4: | ||
Functions explanation: | Functions explanation: | ||
<pre> | <pre> | ||
− | gfsqw_InsertIndicators " | + | gfsqw_GenDatabasesList > $gvsqw_TmpFile.lst |
− | + | gfsqw_InsertIndicators "databases" | |
+ | gfsqw_InsertIndicators "dataserver" | ||
+ | gfsqw_InsertIndicators $lvsqw_DbName | ||
+ | gfsqw_InsertIndicators "parameters" | ||
+ | lfsqw_AllTables => | ||
+ | lfsqw_Databases | ||
+ | lfsqw_Databases => | ||
lfsqw_Dataserver => | lfsqw_Dataserver => | ||
+ | lfsqw_Dataserver | tee ${gvsqw_TmpFile} | ||
lfsqw_GatherAlertLogFile => | lfsqw_GatherAlertLogFile => | ||
+ | lfsqw_GatherDatabases => | ||
+ | lfsqw_GatherDataserver => | ||
lfsqw_GatherFs => | lfsqw_GatherFs => | ||
− | + | lfsqw_GatherParameters => | |
− | |||
lfsqw_GenInsertDatabases => | lfsqw_GenInsertDatabases => | ||
+ | lfsqw_GenInsertDatabases | tee ${gvsqw_TmpFile}.sql | ||
lfsqw_GenInsertDataserver => | lfsqw_GenInsertDataserver => | ||
+ | lfsqw_GenInsertDataserver | tee ${gvsqw_TmpFile}.sql | ||
lfsqw_GenInsertParameters => | lfsqw_GenInsertParameters => | ||
+ | lfsqw_GenInsertParameters > ${gvsqw_TmpFile}.sql | ||
lfsqw_GenInsertTables => | lfsqw_GenInsertTables => | ||
+ | lfsqw_GenInsertTables | tee ${gvsqw_TmpFile}.sql | ||
lfsqw_Parameters => | lfsqw_Parameters => | ||
+ | lfsqw_Parameters | tee ${gvsqw_TmpFile} | ||
+ | lfsqw_Tables => | ||
</pre> | </pre> | ||
<br> | <br> | ||
{{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_GatherIndicators.lib}} | {{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_GatherIndicators.lib}} | ||
<br> | <br> |
Revision as of 17:35, 5 April 2014
shell functions library $gvsqw_SybBin/../lib/sqwsyb_GatherIndicators.lib:
lib for sqwsyb_GatherIndicators.ksh
Functions explanation:
gfsqw_GenDatabasesList > $gvsqw_TmpFile.lst gfsqw_InsertIndicators "databases" gfsqw_InsertIndicators "dataserver" gfsqw_InsertIndicators $lvsqw_DbName gfsqw_InsertIndicators "parameters" lfsqw_AllTables => lfsqw_Databases lfsqw_Databases => lfsqw_Dataserver => lfsqw_Dataserver | tee ${gvsqw_TmpFile} lfsqw_GatherAlertLogFile => lfsqw_GatherDatabases => lfsqw_GatherDataserver => lfsqw_GatherFs => lfsqw_GatherParameters => lfsqw_GenInsertDatabases => lfsqw_GenInsertDatabases | tee ${gvsqw_TmpFile}.sql lfsqw_GenInsertDataserver => lfsqw_GenInsertDataserver | tee ${gvsqw_TmpFile}.sql lfsqw_GenInsertParameters => lfsqw_GenInsertParameters > ${gvsqw_TmpFile}.sql lfsqw_GenInsertTables => lfsqw_GenInsertTables | tee ${gvsqw_TmpFile}.sql lfsqw_Parameters => lfsqw_Parameters | tee ${gvsqw_TmpFile} lfsqw_Tables =>