SQWareProduction:sybase:etc:sqwsyb GlobalVar.cfg

From Wiki_dbSQWare
Revision as of 20:31, 18 January 2013 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Configuration file $gvsqw_SybBin/../etc/sqwsyb_GlobalVar.cfg:
Global var for Sybase
It contains the operating variables of SQWareProduction.


File content: 

export gvsqw_EdtVersion=2.0.13
export gvsqw_ConnectDb=Enable
export gvsqw_InstanceNameForceCase='UpperCase'
export gvsqw_Hostname=$(hostname|cut -d '.' -f1)
export gvsqw_MailMsg_sybase="TrtSybAuto$gvsqw_Env"
export gvsqw_Mail_sybase='default@dbsqware.com'
export gvsqw_SendmailHtmlFormat=enable
export gvsqw_PreFormatHtlml=enable
export gvsqw_Colors=enable
export gvsqw_TraceJobDb=enable
export gvsqw_UploadLogFile=enable
export gvsqw_TraceBackup=enable
export gvsqw_UploadLogFileMaxLine=200
export gvsqw_SaUser='sa'
export gvsqw_PasswdFile="$HOME/.passwd"
export gvsqw_DistPasswdFile="$HOME/.passwd_sybase"
export gvsqw_GlobalInterfacesFile='$SYBASE/interfaces'
export gvsqw_EgrepIvFs='Filesystem|Disponible'
export gvsqw_SuppLogsHisto=30
export gvsqw_GzipLogsHisto=7
export gvsqw_SuppAlert=90
export gvsqw_BackupServer='$(echo ${DSQUERY}|sed "s,^DS_,BS_,")'
export gvsqw_RootAdmin='$HOME/${DSQUERY}'
export gvsqw_RootAdminDist='$HOME/admin/sybase/${DSQUERY}'
export gvsqw_RootCfg='$gvsqw_RootAdmin/edtConfig'
export gvsqw_RootDev='/$(echo $HOME|cut -d/ -f2)/data/${DSQUERY}'
export gvsqw_RunFile='$HOME/${DSQUERY}/runfile/RUN_${DSQUERY}'
export gvsqw_RunFilePath='$HOME/${DSQUERY}/runfile'
export gvsqw_ConfigFilePath='$HOME/${DSQUERY}/cfg'
export gvsqw_ErrorLogPath='$HOME/${DSQUERY}/log'
export gvsqw_ErrorLog='$HOME/${DSQUERY}/log/${DSQUERY}.log'
export gvsqw_SubPathSys='sys'
export gvsqw_SubPathList='sys,errorlog'
export gvsqw_NbThread=2
export gvsqw_SshOptions="-q -o BatchMode=yes -o StrictHostKeyChecking=no"
export gvsqw_ScpOptions="-o BatchMode=yes -o StrictHostKeyChecking=no"
export gvsqw_ExcludeDatabases="'dbccdb','sybsecurity','sybsystemdb','model','audsa'"
export gvsqw_WhereClauseGenDatabaseList="and name not like '%tempdb%'"
export gvsqw_CHtmlError='<font color="#FF0000">'
export gvsqw_CHtmlOk='<font color="#00FF00">'
export gvsqw_CHtmlInfo='<font color="#0000FF">'
export gvsqw_CHtmlEnd='</font>'
export gvsqw_THtmlBegin='<table  class="edt">'
export gvsqw_THtmlEnd='</table>'
export gvsqw_THtmlThBegin='<tr class="edtth"><th>'
export gvsqw_THtmlThEnd='</th></tr>'
export gvsqw_THtmlThInter='</th><th>'
export gvsqw_THtmlTdBegin1='<tr class="edtnc"><td>'
export gvsqw_THtmlTdBegin2='<tr class="sqwc_"><td>'
export gvsqw_THtmlTdEnd='</td></tr>'
export gvsqw_THtmlTdInter='</td><td>'
export gvsqw_THtmlPre="<pre class='edt'>"
export gvsqw_THtmlPreEnd="

"

export gvsqw_HtmlCss="<html><head> export gvsqw_SizeMinTableIndicators=100 export gvsqw_DbAlias='$DSQUERY'

  1. export gvsqw_DistSaUser='user'
  2. export gvsqw_DistSaUserPasswd='passwd'

export gvsqw_DistGlobalInterfacesFile='$HOME/dbSQWare/SQWareCentral/etc_cust/dbsqware_interfaces' export gvsqw_DefNbAttempt=4 export gvsqw_NbThreadDbcc=2 export gvsqw_DefAGR_Dbcc=10 export gvsqw_DefAGE_Dbcc=30 export gvsqw_NbThreadCheckstorage=2 export gvsqw_DefAGR_Checkstorage=10 export gvsqw_DefAGE_Checkstorage=30 export gvsqw_NbThreadRebuild=2 export gvsqw_DefAGR_Rebuild=10 export gvsqw_DefAGE_Rebuild=30 export gvsqw_CluRatioMinTable=80 export gvsqw_CluRatioMinIndex=80 export gvsqw_DefSizeMinTable=1 export gvsqw_NbThreadStatistics=2 export gvsqw_DefAGR_Statistics=10 export gvsqw_DefAGE_Statistics=30 export gvsqw_DefSizeMaxTableStatistics=50000 export gvsqw_NbThreadUpdtStats=2 export gvsqw_DefAGR_UpdtStats=10 export gvsqw_DefAGE_UpdtStats=30 export gvsqw_StatsSizeMoMin100Pct=256 export gvsqw_StatsSampleSizeMaxMo=1024 export gvsqw_StatsSamplePctMini=2 export gvsqw_NbThreadDump=2 export gvsqw_DefAGR_Dump=10 export gvsqw_DefAGE_Dump=30 export gvsqw_RootDump='/$(echo ${HOME}|cut -d/ -f2)/syb_dump/$DSQUERY' export gvsqw_RootDumpSource='/$(echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/syb_dump/$lvsqw_DataserverSource' export gvsqw_DefDumpType=full export gvsqw_DefMaxSizeStrip=4096 export gvsqw_DefCompLevel=1 export gvsqw_DefCompRate=22 export gvsqw_DefDumpNbGeneration=2 export gvsqw_DefNbStripeMax=6 export gvsqw_NbThreadScp=2 export gvsqw_DefAGR_Scp=10 export gvsqw_DefAGE_Scp=30 export gvsqw_RsyncGap=20000

  1. export gvsqw_ForcedReturnCodeScript_sqwsyb_DumpAllDatabases=0

export gvsqw_WebDbaURL="http://webdba"

  1. export gvsqw_WebDbaUserConn='Connection string ssh user@hostname'



Variable explanation: 

gvsqw_BackupServer => 
gvsqw_CHtmlEnd => 
gvsqw_CHtmlError => 
gvsqw_CHtmlInfo => 
gvsqw_CHtmlOk => 
gvsqw_CluRatioMinIndex => 
gvsqw_CluRatioMinTable => 
gvsqw_Colors => 
gvsqw_ConfigFilePath => 
gvsqw_ConnectDb => 
gvsqw_DbAlias => 
gvsqw_DefAGE_Checkstorage => 
gvsqw_DefAGE_Dbcc => 
gvsqw_DefAGE_Dump => 
gvsqw_DefAGE_Rebuild => 
gvsqw_DefAGE_Scp => 
gvsqw_DefAGE_Statistics => 
gvsqw_DefAGE_UpdtStats => 
gvsqw_DefAGR_Checkstorage => 
gvsqw_DefAGR_Dbcc => 
gvsqw_DefAGR_Dump => 
gvsqw_DefAGR_Rebuild => 
gvsqw_DefAGR_Scp => 
gvsqw_DefAGR_Statistics => 
gvsqw_DefAGR_UpdtStats => 
gvsqw_DefCompLevel => 
gvsqw_DefCompRate => 
gvsqw_DefDumpNbGeneration => 
gvsqw_DefDumpType => 
gvsqw_DefMaxSizeStrip => 
gvsqw_DefNbAttempt => 
gvsqw_DefNbStripeMax => 
gvsqw_DefSizeMaxTableStatistics => 
gvsqw_DefSizeMinTable => 
gvsqw_DistGlobalInterfacesFile => 
gvsqw_DistPasswdFile => 
#gvsqw_DistSaUserPasswd => 
#gvsqw_DistSaUser => 
gvsqw_EdtVersion => 
gvsqw_EgrepIvFs => 
gvsqw_ErrorLog => 
gvsqw_ErrorLogPath => 
gvsqw_ExcludeDatabases => 
#gvsqw_ForcedReturnCodeScript_sqwsyb_DumpAllDatabases => 
gvsqw_GlobalInterfacesFile => 
gvsqw_GzipLogsHisto => 
gvsqw_Hostname => 
gvsqw_HtmlCss => 
gvsqw_InstanceNameForceCase => 
gvsqw_MailMsg_sybase => 
gvsqw_Mail_sybase => 
gvsqw_NbThread => 
gvsqw_NbThreadCheckstorage => 
gvsqw_NbThreadDbcc => 
gvsqw_NbThreadDump => 
gvsqw_NbThreadRebuild => 
gvsqw_NbThreadScp => 
gvsqw_NbThreadStatistics => 
gvsqw_NbThreadUpdtStats => 
gvsqw_PasswdFile => 
gvsqw_PreFormatHtlml => 
gvsqw_RootAdminDist => 
gvsqw_RootAdmin => 
gvsqw_RootCfg => 
gvsqw_RootDev => 
gvsqw_RootDump => 
gvsqw_RootDumpSource => 
gvsqw_RsyncGap => 
gvsqw_RunFile => 
gvsqw_RunFilePath => 
gvsqw_SaUser => 
gvsqw_ScpOptions => 
gvsqw_SendmailHtmlFormat => 
gvsqw_SizeMinTableIndicators => 
gvsqw_SshOptions => 
gvsqw_StatsSamplePctMini => 
gvsqw_StatsSampleSizeMaxMo => 
gvsqw_StatsSizeMoMin100Pct => 
gvsqw_SubPathList => 
gvsqw_SubPathSys => 
gvsqw_SuppAlert => 
gvsqw_SuppLogsHisto => 
gvsqw_THtmlBegin => 
gvsqw_THtmlEnd => 
gvsqw_THtmlPreEnd => 
gvsqw_THtmlPre => 
gvsqw_THtmlTdBegin1 => 
gvsqw_THtmlTdBegin2 => 
gvsqw_THtmlTdEnd => 
gvsqw_THtmlTdInter => 
gvsqw_THtmlThBegin => 
gvsqw_THtmlThEnd => 
gvsqw_THtmlThInter => 
gvsqw_TraceBackup => 
gvsqw_TraceJobDb => 
gvsqw_UploadLogFile => 
gvsqw_UploadLogFileMaxLine => 
gvsqw_WebDbaURL => 
#gvsqw_WebDbaUserConn => 
gvsqw_WhereClauseGenDatabaseList =>
Note:
You can overload variables contain in $gvsqw_SybBin/../etc/sqwsyb_GlobalVar.cfg

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


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:sybase:etc:sqwsyb_GlobalVar.cfg&oldid=3842"