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

From Wiki_dbSQWare
Jump to navigation Jump to search
← Older editNewer edit →
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=2023.03
export gvsqw_MssqlPassFile=$gvsqw_DistPasswdFile
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_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_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_SizeMaxStripe =>
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 10:37, 11 February 2023

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


File content: 

export gvsqw_SqwVersionDbms=2023.03
export gvsqw_MssqlPassFile=$gvsqw_DistPasswdFile
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_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_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_SizeMaxStripe => 
gvsqw_SizeMinTableIndicators => 
gvsqw_SqwVersionDbms => 
gvsqw_StringReplaceSch => 
gvsqw_SuppAlert => 
gvsqw_UserTypeList => 
gvsqw_WhereClauseGenDatabaseList => 
gvsqw_XpCmdShellWaitTimeOut =>
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=22929"