Difference between revisions of "SQWareProduction:mssql:etc:sqwmsq GlobalVar.cfg"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
(Tag: Replaced)
m (Updated by BatchUser)
Line 1: Line 1:
 
Configuration file $gvsqw_MsqBin/../etc/sqwmsq_GlobalVar.cfg:<br>
 
Configuration file $gvsqw_MsqBin/../etc/sqwmsq_GlobalVar.cfg:<br>
 
{{SQWareProduction_sqwmsq_GlobalVar.cfg_presentation}}
 
{{SQWareProduction_sqwmsq_GlobalVar.cfg_presentation}}
−
{{SQWareProduction_sqwmsq_GlobalVar.cfg_content}}
+
<br>
−
{{SQWareProduction_sqwmsq_GlobalVar.cfg_explanation}}
+
<br>
 +
File content:
 +
<pre>
 +
export gvsqw_SqwVersionDbms=2024.07
 +
export gvsqw_MssqlPassFile=$gvsqw_DistPasswdFile
 +
export gvsqw_DistPasswdFile="$HOME/.passwd_mssql"
 +
export gvsqw_MssqlSaUser='sa'
 +
export gvsqw_RootAdmin='$HOME/admin/${lvsqw_InstanceParam}'
 +
export gvsqw_RootAdminDisable='$HOME'
 +
export gvsqw_RootCfg='$gvsqw_RootAdmin/sqwConfig'
 +
export gvsqw_WhereClauseGenDatabaseList="and name not like 'tempdb%' and name not like 'ReportServer%TempDb'"
 +
export gvsqw_DbAlias='$lvsqw_InstanceParam'
 +
export gvsqw_SuppAlert=90
 +
#export gvsqw_MsSqlErrorMsg='^Msg 3014, Level 0, State 1|^Msg 3211, Level 0, State 1|^Msg 4035, Level 0, State 1|^Server ..*, Line 1|@@rowcount'
 +
export gvsqw_MsSqlErrorMsg='^Msg [0-9][0-9]*, Level 0, State 1|^Server ..*, Line 1|@@rowcount'
 +
export gvsqw_XpCmdShellWaitTimeOut=300
 +
export gvsqw_Collate='Latin1_General_CI_AI'
 +
export gvsqw_NbThreadBackup=4
 +
export gvsqw_DefAGR_Backup=5
 +
export gvsqw_DefAGE_Backup=20
 +
export gvsqw_BackupNbGeneration=2
 +
export gvsqw_SizeMaxStripe=40000
 +
export gvsqw_NbMaxStripe=5
 +
export gvsqw_BackupStatSize=10
 +
export gvsqw_NbThreadRebuild=4
 +
export gvsqw_DefAGR_Rebuild=5
 +
export gvsqw_DefAGE_Rebuild=20
 +
export gvsqw_SetOptionsRebuild='set ansi_defaults, concat_null_yields_null on
 +
export gvsqw_RebuildType='index' #Rebuild type, 'all' for tables, 'index' for indexes
 +
export gvsqw_MinRatioReb=30 #Min avg_fragmentation_in_percent before rebuild
 +
export gvsqw_MinRatioRgz=10 #Min avg_fragmentation_in_percent before reorganize
 +
export gvsqw_SizeMinIndexRebuild=1 #Min size of index in Mb to take into account
 +
export gvsqw_SizeMaxIndexRebuild=50000 #Max size of index in Mb to take into account
 +
export gvsqw_NbThreadStatistics=4
 +
export gvsqw_DefAGR_Statistics=5
 +
export gvsqw_DefAGE_Statistics=20
 +
export gvsqw_NbThreadRestore=4
 +
export gvsqw_DefAGR_Restore=5
 +
export gvsqw_DefAGE_Restore=20
 +
export gvsqw_RestoreStatSize=5
 +
export gvsqw_NbThreadCheckdb=4
 +
export gvsqw_DefAGR_Checkdb=5
 +
export gvsqw_DefAGE_Checkdb=20
 +
export gvsqw_SizeMinTableIndicators=10
 +
export gvsqw_BackupsIndicatorsDays=2
 +
export gvsqw_ExcludeDatabaseStatus="'OFFLINE','RESTORING'"
 +
export gvsqw_GenExcludeDatabasesObjects="^master$|^msdb$|^model$|^ReportServer"
 +
export gvsqw_GenExcludeDatabasesObjectsExtra=""
 +
export gvsqw_StringReplaceSch="tr -d '\015'|tr '\311' 'E'"
 +
export gvsqw_UserTypeList="'SQL_LOGIN','WINDOWS_LOGIN'"
 +
#export gvsqw_ForcedReturnCodeScript_sqwmsq_BackupAllDatabases=0
 +
#export gvsqw_ForcedReturnCodeScript_sqwmsq_BackupDatabase=0
 +
#export gvsqw_ForcedReturnCodeScript_sqwmsq_CheckdbAllDatabases=0
 +
#export gvsqw_ForcedReturnCodeScript_sqwmsq_CheckdbDatabase=0
 +
#export gvsqw_ForcedReturnCodeScript_sqwmsq_CheckIndicators=0
 +
#export gvsqw_ForcedReturnCodeScript_sqwmsq_GatherIndicators=0
 +
#export gvsqw_ForcedReturnCodeScript_sqwmsq_ParallelRun=0
 +
#export gvsqw_ForcedReturnCodeScript_sqwmsq_RebuildIndexAllDatabases=0
 +
#export gvsqw_ForcedReturnCodeScript_sqwmsq_RebuildIndexDatabase=0
 +
#export gvsqw_ForcedReturnCodeScript_sqwmsq_RestoreAllDatabases=0
 +
#export gvsqw_ForcedReturnCodeScript_sqwmsq_RestoreDatabase=0
 +
#export gvsqw_ForcedReturnCodeScript_sqwmsq_RotateErrorLog=0
 +
#export gvsqw_ForcedReturnCodeScript_sqwmsq_StatisticsAllDatabases=0
 +
#export gvsqw_ForcedReturnCodeScript_sqwmsq_StatisticsDatabase=0
 +
</pre>
 +
<br>
 +
<br>
 +
Variables explanation:
 +
<pre>
 +
gvsqw_BackupNbGeneration =>
 +
gvsqw_BackupsIndicatorsDays =>
 +
gvsqw_BackupStatSize =>
 +
gvsqw_Collate =>
 +
gvsqw_DbAlias =>
 +
gvsqw_DefAGE_Backup =>
 +
gvsqw_DefAGE_Checkdb =>
 +
gvsqw_DefAGE_Rebuild =>
 +
gvsqw_DefAGE_Restore =>
 +
gvsqw_DefAGE_Statistics =>
 +
gvsqw_DefAGR_Backup =>
 +
gvsqw_DefAGR_Checkdb =>
 +
gvsqw_DefAGR_Rebuild =>
 +
gvsqw_DefAGR_Restore =>
 +
gvsqw_DefAGR_Statistics =>
 +
gvsqw_DistPasswdFile =>
 +
gvsqw_ExcludeDatabaseStatus =>
 +
#gvsqw_ForcedReturnCodeScript_sqwmsq_BackupAllDatabases =>
 +
#gvsqw_ForcedReturnCodeScript_sqwmsq_BackupDatabase =>
 +
#gvsqw_ForcedReturnCodeScript_sqwmsq_CheckdbAllDatabases =>
 +
#gvsqw_ForcedReturnCodeScript_sqwmsq_CheckdbDatabase =>
 +
#gvsqw_ForcedReturnCodeScript_sqwmsq_CheckIndicators =>
 +
#gvsqw_ForcedReturnCodeScript_sqwmsq_GatherIndicators =>
 +
#gvsqw_ForcedReturnCodeScript_sqwmsq_ParallelRun =>
 +
#gvsqw_ForcedReturnCodeScript_sqwmsq_RebuildIndexAllDatabases =>
 +
#gvsqw_ForcedReturnCodeScript_sqwmsq_RebuildIndexDatabase =>
 +
#gvsqw_ForcedReturnCodeScript_sqwmsq_RestoreAllDatabases =>
 +
#gvsqw_ForcedReturnCodeScript_sqwmsq_RestoreDatabase =>
 +
#gvsqw_ForcedReturnCodeScript_sqwmsq_RotateErrorLog =>
 +
#gvsqw_ForcedReturnCodeScript_sqwmsq_StatisticsAllDatabases =>
 +
#gvsqw_ForcedReturnCodeScript_sqwmsq_StatisticsDatabase =>
 +
gvsqw_GenExcludeDatabasesObjectsExtra =>
 +
gvsqw_GenExcludeDatabasesObjects =>
 +
gvsqw_MinRatioReb =>
 +
gvsqw_MinRatioRgz =>
 +
gvsqw_MsSqlErrorMsg =>
 +
#gvsqw_MsSqlErrorMsg =>
 +
gvsqw_MssqlPassFile =>
 +
gvsqw_MssqlSaUser =>
 +
gvsqw_NbMaxStripe =>
 +
gvsqw_NbThreadBackup =>
 +
gvsqw_NbThreadCheckdb =>
 +
gvsqw_NbThreadRebuild =>
 +
gvsqw_NbThreadRestore =>
 +
gvsqw_NbThreadStatistics =>
 +
gvsqw_RebuildType =>
 +
gvsqw_RestoreStatSize =>
 +
gvsqw_RootAdmin =>
 +
gvsqw_RootAdminDisable =>
 +
gvsqw_RootCfg =>
 +
gvsqw_SetOptionsRebuild =>
 +
gvsqw_SizeMaxIndexRebuild =>
 +
gvsqw_SizeMaxStripe =>
 +
gvsqw_SizeMinIndexRebuild =>
 +
gvsqw_SizeMinTableIndicators =>
 +
gvsqw_SqwVersionDbms =>
 +
gvsqw_StringReplaceSch =>
 +
gvsqw_SuppAlert =>
 +
gvsqw_UserTypeList =>
 +
gvsqw_WhereClauseGenDatabaseList =>
 +
gvsqw_XpCmdShellWaitTimeOut =>
 +
</pre>
 
{{SQWareProductionSurchargeVar|mssql|Msq|sqwmsq_GlobalVar.cfg}}
 
{{SQWareProductionSurchargeVar|mssql|Msq|sqwmsq_GlobalVar.cfg}}
 
<br>
 
<br>

Revision as of 15:50, 31 October 2024

Configuration file $gvsqw_MsqBin/../etc/sqwmsq_GlobalVar.cfg:
Global var for Mssql
It contains the operating variables of SQWareProduction.


File content: 

export gvsqw_SqwVersionDbms=2024.07
	export gvsqw_MssqlPassFile=$gvsqw_DistPasswdFile
	export gvsqw_DistPasswdFile="$HOME/.passwd_mssql"
export gvsqw_MssqlSaUser='sa'
export gvsqw_RootAdmin='$HOME/admin/${lvsqw_InstanceParam}'
export gvsqw_RootAdminDisable='$HOME'
export gvsqw_RootCfg='$gvsqw_RootAdmin/sqwConfig'
export gvsqw_WhereClauseGenDatabaseList="and name not like 'tempdb%' and name not like 'ReportServer%TempDb'"
export gvsqw_DbAlias='$lvsqw_InstanceParam'
export gvsqw_SuppAlert=90
#export gvsqw_MsSqlErrorMsg='^Msg 3014, Level 0, State 1|^Msg 3211, Level 0, State 1|^Msg 4035, Level 0, State 1|^Server ..*, Line 1|@@rowcount'
export gvsqw_MsSqlErrorMsg='^Msg [0-9][0-9]*, Level 0, State 1|^Server ..*, Line 1|@@rowcount'
export gvsqw_XpCmdShellWaitTimeOut=300
export gvsqw_Collate='Latin1_General_CI_AI'
export gvsqw_NbThreadBackup=4
export gvsqw_DefAGR_Backup=5
export gvsqw_DefAGE_Backup=20
export gvsqw_BackupNbGeneration=2
export gvsqw_SizeMaxStripe=40000
export gvsqw_NbMaxStripe=5
export gvsqw_BackupStatSize=10
export gvsqw_NbThreadRebuild=4
export gvsqw_DefAGR_Rebuild=5
export gvsqw_DefAGE_Rebuild=20
export gvsqw_SetOptionsRebuild='set ansi_defaults, concat_null_yields_null on
export gvsqw_RebuildType='index' #Rebuild type, 'all' for tables, 'index' for indexes
export gvsqw_MinRatioReb=30 #Min avg_fragmentation_in_percent before rebuild
export gvsqw_MinRatioRgz=10 #Min avg_fragmentation_in_percent before reorganize
export gvsqw_SizeMinIndexRebuild=1 #Min size of index in Mb to take into account
export gvsqw_SizeMaxIndexRebuild=50000 #Max size of index in Mb to take into account
export gvsqw_NbThreadStatistics=4
export gvsqw_DefAGR_Statistics=5
export gvsqw_DefAGE_Statistics=20
export gvsqw_NbThreadRestore=4
export gvsqw_DefAGR_Restore=5
export gvsqw_DefAGE_Restore=20
export gvsqw_RestoreStatSize=5
export gvsqw_NbThreadCheckdb=4
export gvsqw_DefAGR_Checkdb=5
export gvsqw_DefAGE_Checkdb=20
export gvsqw_SizeMinTableIndicators=10
export gvsqw_BackupsIndicatorsDays=2
export gvsqw_ExcludeDatabaseStatus="'OFFLINE','RESTORING'"
export gvsqw_GenExcludeDatabasesObjects="^master$|^msdb$|^model$|^ReportServer"
export gvsqw_GenExcludeDatabasesObjectsExtra=""
export gvsqw_StringReplaceSch="tr -d '\015'|tr '\311' 'E'"
export gvsqw_UserTypeList="'SQL_LOGIN','WINDOWS_LOGIN'"
#export gvsqw_ForcedReturnCodeScript_sqwmsq_BackupAllDatabases=0
#export gvsqw_ForcedReturnCodeScript_sqwmsq_BackupDatabase=0
#export gvsqw_ForcedReturnCodeScript_sqwmsq_CheckdbAllDatabases=0
#export gvsqw_ForcedReturnCodeScript_sqwmsq_CheckdbDatabase=0
#export gvsqw_ForcedReturnCodeScript_sqwmsq_CheckIndicators=0
#export gvsqw_ForcedReturnCodeScript_sqwmsq_GatherIndicators=0
#export gvsqw_ForcedReturnCodeScript_sqwmsq_ParallelRun=0
#export gvsqw_ForcedReturnCodeScript_sqwmsq_RebuildIndexAllDatabases=0
#export gvsqw_ForcedReturnCodeScript_sqwmsq_RebuildIndexDatabase=0
#export gvsqw_ForcedReturnCodeScript_sqwmsq_RestoreAllDatabases=0
#export gvsqw_ForcedReturnCodeScript_sqwmsq_RestoreDatabase=0
#export gvsqw_ForcedReturnCodeScript_sqwmsq_RotateErrorLog=0
#export gvsqw_ForcedReturnCodeScript_sqwmsq_StatisticsAllDatabases=0
#export gvsqw_ForcedReturnCodeScript_sqwmsq_StatisticsDatabase=0



Variables explanation: 

gvsqw_BackupNbGeneration => 
gvsqw_BackupsIndicatorsDays => 
gvsqw_BackupStatSize => 
gvsqw_Collate => 
gvsqw_DbAlias => 
gvsqw_DefAGE_Backup => 
gvsqw_DefAGE_Checkdb => 
gvsqw_DefAGE_Rebuild => 
gvsqw_DefAGE_Restore => 
gvsqw_DefAGE_Statistics => 
gvsqw_DefAGR_Backup => 
gvsqw_DefAGR_Checkdb => 
gvsqw_DefAGR_Rebuild => 
gvsqw_DefAGR_Restore => 
gvsqw_DefAGR_Statistics => 
	gvsqw_DistPasswdFile => 
gvsqw_ExcludeDatabaseStatus => 
#gvsqw_ForcedReturnCodeScript_sqwmsq_BackupAllDatabases => 
#gvsqw_ForcedReturnCodeScript_sqwmsq_BackupDatabase => 
#gvsqw_ForcedReturnCodeScript_sqwmsq_CheckdbAllDatabases => 
#gvsqw_ForcedReturnCodeScript_sqwmsq_CheckdbDatabase => 
#gvsqw_ForcedReturnCodeScript_sqwmsq_CheckIndicators => 
#gvsqw_ForcedReturnCodeScript_sqwmsq_GatherIndicators => 
#gvsqw_ForcedReturnCodeScript_sqwmsq_ParallelRun => 
#gvsqw_ForcedReturnCodeScript_sqwmsq_RebuildIndexAllDatabases => 
#gvsqw_ForcedReturnCodeScript_sqwmsq_RebuildIndexDatabase => 
#gvsqw_ForcedReturnCodeScript_sqwmsq_RestoreAllDatabases => 
#gvsqw_ForcedReturnCodeScript_sqwmsq_RestoreDatabase => 
#gvsqw_ForcedReturnCodeScript_sqwmsq_RotateErrorLog => 
#gvsqw_ForcedReturnCodeScript_sqwmsq_StatisticsAllDatabases => 
#gvsqw_ForcedReturnCodeScript_sqwmsq_StatisticsDatabase => 
gvsqw_GenExcludeDatabasesObjectsExtra => 
gvsqw_GenExcludeDatabasesObjects => 
gvsqw_MinRatioReb => 
gvsqw_MinRatioRgz => 
gvsqw_MsSqlErrorMsg => 
#gvsqw_MsSqlErrorMsg => 
	gvsqw_MssqlPassFile => 
gvsqw_MssqlSaUser => 
gvsqw_NbMaxStripe => 
gvsqw_NbThreadBackup => 
gvsqw_NbThreadCheckdb => 
gvsqw_NbThreadRebuild => 
gvsqw_NbThreadRestore => 
gvsqw_NbThreadStatistics => 
gvsqw_RebuildType => 
gvsqw_RestoreStatSize => 
gvsqw_RootAdmin => 
gvsqw_RootAdminDisable => 
gvsqw_RootCfg => 
gvsqw_SetOptionsRebuild => 
gvsqw_SizeMaxIndexRebuild => 
gvsqw_SizeMaxStripe => 
gvsqw_SizeMinIndexRebuild => 
gvsqw_SizeMinTableIndicators => 
gvsqw_SqwVersionDbms => 
gvsqw_StringReplaceSch => 
gvsqw_SuppAlert => 
gvsqw_UserTypeList => 
gvsqw_WhereClauseGenDatabaseList => 
gvsqw_XpCmdShellWaitTimeOut =>
Nuvola apps information.png
Note:
You can overload variables contain in $gvsqw_MsqBin/../etc/sqwmsq_GlobalVar.cfg

by the same variables in $gvsqw_MsqBin/../etc_cust/sqwmsq_GlobalVar.cfg for all your environnement
or in $HOME/sqwConfig/sqwmsq_GlobalVar.cfg specifically for this user.


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:mssql:etc:sqwmsq_GlobalVar.cfg&oldid=29066"