Difference between revisions of "SQWareProduction:mssql:lib:sqwmsq GatherIndicators.lib"
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 =>
