Difference between revisions of "SQWareProduction:mssql:lib:sqwmsq GatherIndicators.lib"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
| Line 4: | Line 4: | ||
Functions explanation: | Functions explanation: | ||
<pre> | <pre> | ||
| + | gfsqw_ExecSql ${gvsqw_TmpFile}.sql 2>&1| tr -d "\015" |tee ${gvsqw_TmpFile} | ||
| + | gfsqw_ExecSql "sp_helpdb" 2>&1| tr -d "\015" |tee ${gvsqw_TmpFile} | ||
| + | gfsqw_GenDatabasesList > $gvsqw_TmpFile.lst | ||
gfsqw_InsertIndicators "archive" | gfsqw_InsertIndicators "archive" | ||
| + | gfsqw_InsertIndicators "License" | ||
| + | gfsqw_InsertIndicators "Parameters" | ||
lfsqw_Archivage => | lfsqw_Archivage => | ||
| + | lfsqw_GatherDatabases => | ||
| + | lfsqw_GatherSpace => | ||
lfsqw_GenerateInsertAlert => | lfsqw_GenerateInsertAlert => | ||
lfsqw_GenInsertDatabases => | lfsqw_GenInsertDatabases => | ||
lfsqw_GenInsertDataserver => | lfsqw_GenInsertDataserver => | ||
| + | lfsqw_GenInsertLicense => | ||
| + | lfsqw_GenInsertLicense|tee ${gvsqw_TmpFile}.sql | ||
| + | lfsqw_GenInsertParameters => | ||
| + | lfsqw_GenInsertParameters|tee ${gvsqw_TmpFile}.sql | ||
lfsqw_GenInsertSpace => | lfsqw_GenInsertSpace => | ||
| + | lfsqw_GenInsertTables => | ||
| + | lfsqw_License => | ||
| + | lfsqw_Parameters => | ||
lfsqw_SizeInstance=0 | lfsqw_SizeInstance=0 | ||
lfsqw_SqlInsertSpace => | lfsqw_SqlInsertSpace => | ||
| + | lfsqw_SqlInsertSpace >> ${gvsqw_TmpFile}.sql | ||
| + | lfsqw_Tables => | ||
</pre> | </pre> | ||
<br> | <br> | ||
{{SQWareProductionSurchargeLib|mssql|Mss|sqwmsq_GatherIndicators.lib}} | {{SQWareProductionSurchargeLib|mssql|Mss|sqwmsq_GatherIndicators.lib}} | ||
<br> | <br> | ||
Revision as of 12:54, 23 January 2012
shell functions library $gvsqw_MssBin/../lib/sqwmsq_GatherIndicators.lib:
lib for sqwmsq_GatherIndicators.ksh
Functions explanation:
gfsqw_ExecSql ${gvsqw_TmpFile}.sql 2>&1| tr -d "\015" |tee ${gvsqw_TmpFile}
gfsqw_ExecSql "sp_helpdb" 2>&1| tr -d "\015" |tee ${gvsqw_TmpFile}
gfsqw_GenDatabasesList > $gvsqw_TmpFile.lst
gfsqw_InsertIndicators "archive"
gfsqw_InsertIndicators "License"
gfsqw_InsertIndicators "Parameters"
lfsqw_Archivage =>
lfsqw_GatherDatabases =>
lfsqw_GatherSpace =>
lfsqw_GenerateInsertAlert =>
lfsqw_GenInsertDatabases =>
lfsqw_GenInsertDataserver =>
lfsqw_GenInsertLicense =>
lfsqw_GenInsertLicense|tee ${gvsqw_TmpFile}.sql
lfsqw_GenInsertParameters =>
lfsqw_GenInsertParameters|tee ${gvsqw_TmpFile}.sql
lfsqw_GenInsertSpace =>
lfsqw_GenInsertTables =>
lfsqw_License =>
lfsqw_Parameters =>
lfsqw_SizeInstance=0
lfsqw_SqlInsertSpace =>
lfsqw_SqlInsertSpace >> ${gvsqw_TmpFile}.sql
lfsqw_Tables =>
