SQWareProduction:mssql:etc:sqwmsq GlobalVar.cfg

Fichier de configuration $gvsqw_MsqBin/../etc/sqwmsq_GlobalVar.cfg:
Global var for Mssql
Contient les variables operationnelles de SQWareProduction.


Contenu du fichier:

export gvsqw_SqwVersionDbms=2024.03
	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

Explication des variables:

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 =>