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

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
Line 4: Line 4:
 
Functions explanation:
 
Functions explanation:
 
<pre>
 
<pre>
gfsqw_InsertIndicators "archiving"
+
gfsqw_GenDatabasesList > $gvsqw_TmpFile.lst
lfsqw_Archiving =>  
+
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_GenerateInsertAlert =>
+
lfsqw_GatherParameters =>  
lfsqw_GenerateInsertFs =>  
 
 
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 => 


Nuvola apps information.png
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 .