SQWareProduction:mssql:etc:sqwmsq GlobalVar.cfg
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.06
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=10 #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 =>
