SQWareProduction:mssql:lib:sqwmsq GatherIndicators.lib: Difference between revisions
Jump to navigation
Jump to search
m Updated by Expdbtools |
m Updated by Expdbtools |
||
Line 1: | Line 1: | ||
shell functions librairy $gvsqw_MssBin/../lib/sqwmsq_GatherIndicators.lib:<br> | |||
{{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_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 =>