SQWareProduction:mssql:lib:sqwmsq GatherIndicators.lib: Difference between revisions

From Wiki_dbSQWare
Jump to navigation Jump to search
Exploit (talk | contribs)
m Updated by Expdbtools
 
Exploit (talk | contribs)
m Updated by Expdbtools
Line 1: Line 1:
Librairie de fonctions shell $gvsqw_MssBin/../lib/sqwmsq_GatherIndicators.lib:<br>
shell functions librairy $gvsqw_MssBin/../lib/sqwmsq_GatherIndicators.lib:<br>
lib for sqwmsq_GatherIndicators.ksh
{{SQWareProduction_sqwmsq_GatherIndicators.lib_presentation}}
<br>
<br>
Functions explanation:
<pre>
echo "lfsqw_SizeInstance=$lfsqw_SizeInstance\nNbDatabases=$NbDatabases">${gvsqw_TmpFile}.size
echo "lfsqw_SizeInstance=$lfsqw_SizeInstance\nNbDatabases=$NbDatabases">${gvsqw_TmpFile}.size
echo "values @Gather_date,'$lvsqw_InstanceParam',$lfsqw_SizeInstance,'$gvsqw_MajorVersion','$VersionPatch',$NbDatabases"
echo "values @Gather_date,'$lvsqw_InstanceParam',$lfsqw_SizeInstance,'$gvsqw_MajorVersion','$VersionPatch',$NbDatabases => "
gfsqw_InsertIndicators "archive"
gfsqw_InsertIndicators "archive"
grep "lfsqw_SizeInstance=" ${gvsqw_TmpFile}.size|cut -d= -f2|read lfsqw_SizeInstance
grep "lfsqw_SizeInstance=" ${gvsqw_TmpFile}.size|cut -d= -f2|read lfsqw_SizeInstance
lfsqw_Archivage
lfsqw_Archivage =>
lfsqw_GenerateInsertAlert
lfsqw_GenerateInsertAlert =>
lfsqw_GenInsertDatabases
lfsqw_GenInsertDatabases =>
lfsqw_GenInsertDataserver
lfsqw_GenInsertDataserver =>
lfsqw_GenInsertSpace
lfsqw_GenInsertSpace =>
lfsqw_SizeInstance=0
lfsqw_SizeInstance=0
        lfsqw_SizeInstance=lfsqw_SizeInstance+Size_db
lfsqw_SizeInstance=lfsqw_SizeInstance+Size_db =>  =>
lfsqw_SqlInsertSpace
lfsqw_SqlInsertSpace =>
</pre>
<br>
<br>
{{SQWareProductionSurchargeLib|mssql|Mss|sqwmsq_GatherIndicators.lib}}
{{SQWareProductionSurchargeLib|mssql|Mss|sqwmsq_GatherIndicators.lib}}
<br>
<br>

Revision as of 00:26, 16 December 2010

shell functions librairy $gvsqw_MssBin/../lib/sqwmsq_GatherIndicators.lib:
lib for sqwmsq_GatherIndicators.ksh
Functions explanation:

echo "lfsqw_SizeInstance=$lfsqw_SizeInstance\nNbDatabases=$NbDatabases">${gvsqw_TmpFile}.size
echo "values @Gather_date,'$lvsqw_InstanceParam',$lfsqw_SizeInstance,'$gvsqw_MajorVersion','$VersionPatch',$NbDatabases => "
gfsqw_InsertIndicators "archive"
grep "lfsqw_SizeInstance=" ${gvsqw_TmpFile}.size|cut -d= -f2|read lfsqw_SizeInstance
lfsqw_Archivage => 
lfsqw_GenerateInsertAlert => 
lfsqw_GenInsertDatabases => 
lfsqw_GenInsertDataserver => 
lfsqw_GenInsertSpace => 
lfsqw_SizeInstance=0
	lfsqw_SizeInstance=lfsqw_SizeInstance+Size_db =>  => 
lfsqw_SqlInsertSpace => 


Note:
You can overload functions contained in $gvsqw_MssBin/../lib/sqwmsq_GatherIndicators.lib

by function with same name in $gvsqw_MssBin/../lib_cust/sqwmsq_GatherIndicators.lib for all your environnement
or by $HOME/sqwConfig/sqwmsq_GatherIndicators.lib specifically for this user .