SQWareProduction:sybase:etc:sqwsyb GlobalVar.cfg : Différence entre versions
m (Updated by BatchUser) (Balise : Remplacé) |
m (Updated by BatchUser) |
||
Ligne 1 : | Ligne 1 : | ||
− | + | Fichier de configuration $gvsqw_SybBin/../etc/sqwsyb_GlobalVar.cfg:<br> | |
{{SQWareProduction_sqwsyb_GlobalVar.cfg_presentation}} | {{SQWareProduction_sqwsyb_GlobalVar.cfg_presentation}} | ||
− | {{ | + | <br> |
− | {{ | + | <br> |
+ | Contenu du fichier: | ||
+ | <pre> | ||
+ | export gvsqw_SqwVersionDbms=2024.07 | ||
+ | export gvsqw_ExcludeEvalVar='^gvsqw_ExternalDbaUser=|^gvsqw_SaUserPasswd=' | ||
+ | export gvsqw_SaUser='sa' | ||
+ | export gvsqw_PasswdFile="$HOME/.passwd" | ||
+ | export gvsqw_GlobalInterfacesFile='$SYBASE/interfaces' | ||
+ | export gvsqw_BackupServer='$(echo ${DSQUERY}|sed s,^DS_,BS_,)' | ||
+ | export gvsqw_RootAdmin='$HOME/${DSQUERY}' | ||
+ | export gvsqw_RootAdminDisable='$HOME' | ||
+ | export gvsqw_RootAdminDist='$HOME/admin/sybase/${DSQUERY}' | ||
+ | export gvsqw_RootCfg='$gvsqw_RootAdmin/sqwConfig' | ||
+ | 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_ExcludeDatabases="'dbccdb','sybsecurity','sybsystemdb','model','audsa'" | ||
+ | export gvsqw_WhereClauseGenDatabaseList="and dbid < 32000 and name not like '%tempdb%' | ||
+ | export gvsqw_WhereClauseGenDatabaseList_15=" | ||
+ | export gvsqw_SizeMinTableIndicators=100 | ||
+ | export gvsqw_DbAlias='$DSQUERY' | ||
+ | export gvsqw_DistGlobalInterfacesFile='$HOME/dbSQWare/SQWareCentral/etc_cust/dbsqware_interfaces' | ||
+ | export gvsqw_GenExcludeDatabasesObjects="^master$|^model$|^sybsystemprocs$" | ||
+ | export gvsqw_GenExcludeDatabasesObjectsExtra="" | ||
+ | export gvsqw_StringReplaceSch="tr -d '\015'|tr '\311' 'E'" | ||
+ | export gvsqw_PathList="HOME;gvsqw_RootAdmin;gvsqw_RootCfg;gvsqw_RootDump" | ||
+ | export gvsqw_PathListExtra="" | ||
+ | export gvsqw_DefNbAttempt=4 | ||
+ | export gvsqw_NbThreadDbcc=2 | ||
+ | export gvsqw_DefAGR_Dbcc=10 | ||
+ | export gvsqw_DefAGE_Dbcc=30 | ||
+ | export gvsqw_NbThreadCheckstorage=1 | ||
+ | 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_DefSizeMinTableRebuild=1 | ||
+ | export gvsqw_DefSizeMaxTableRebuild=10000 | ||
+ | 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_StatsSampleSizeMaxRead=1024 | ||
+ | export gvsqw_StatsSamplePctMini=1 | ||
+ | export gvsqw_DefSizeMaxTableUpdtStats=1000000 | ||
+ | export gvsqw_DefUpdtStatsType='index' #could by ('','index','table','all') | ||
+ | export gvsqw_MinPctChange=10 | ||
+ | export gvsqw_WithHashing='False' | ||
+ | export gvsqw_HashSize=1000000 | ||
+ | export gvsqw_NbThreadTable=2 | ||
+ | export gvsqw_DefAGR_Table=1 | ||
+ | export gvsqw_DefAGE_Table=5 | ||
+ | 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_DumpSyntaxType='NewSyntax' | ||
+ | export gvsqw_DumpSyslogins="Enable" | ||
+ | export gvsqw_DumpTruncMasterLog="Enable" | ||
+ | export gvsqw_RsyncDefaultSourceDir='/$(echo ${HOME}|cut -d/ -f2)/syb_dump/$DSQUERY' | ||
+ | export gvsqw_NbThreadCopyDump=2 | ||
+ | export gvsqw_DefAGR_CopyDump=10 | ||
+ | export gvsqw_DefAGE_CopyDump=30 | ||
+ | export gvsqw_NbThreadScp=2 | ||
+ | export gvsqw_DefAGR_Scp=10 | ||
+ | export gvsqw_DefAGE_Scp=30 | ||
+ | export gvsqw_DefCopyDumpNbGeneration=1 | ||
+ | export gvsqw_ExcludeDatabasesCopy="'master','sybsystemprocs'" | ||
+ | export gvsqw_NbThreadLoad=2 | ||
+ | export gvsqw_DefAGR_Load=10 | ||
+ | export gvsqw_DefAGE_Load=30 | ||
+ | export gvsqw_RsyncGap=20000 | ||
+ | export gvsqw_ExcludeDatabasesLoad="'master','sybsystemprocs'" | ||
+ | #export gvsqw_ForcedReturnCodeScript_sqwsyb_DumpAllDatabases=0 | ||
+ | </pre> | ||
+ | <br> | ||
+ | <br> | ||
+ | Explication des variables: | ||
+ | <pre> | ||
+ | gvsqw_BackupServer => | ||
+ | gvsqw_CluRatioMinIndex => | ||
+ | gvsqw_CluRatioMinTable => | ||
+ | gvsqw_ConfigFilePath => | ||
+ | gvsqw_DbAlias => | ||
+ | gvsqw_DefAGE_Checkstorage => | ||
+ | gvsqw_DefAGE_CopyDump => | ||
+ | gvsqw_DefAGE_Dbcc => | ||
+ | gvsqw_DefAGE_Dump => | ||
+ | gvsqw_DefAGE_Load => | ||
+ | gvsqw_DefAGE_Rebuild => | ||
+ | gvsqw_DefAGE_Scp => | ||
+ | gvsqw_DefAGE_Statistics => | ||
+ | gvsqw_DefAGE_Table => | ||
+ | gvsqw_DefAGE_UpdtStats => | ||
+ | gvsqw_DefAGR_Checkstorage => | ||
+ | gvsqw_DefAGR_CopyDump => | ||
+ | gvsqw_DefAGR_Dbcc => | ||
+ | gvsqw_DefAGR_Dump => | ||
+ | gvsqw_DefAGR_Load => | ||
+ | gvsqw_DefAGR_Rebuild => | ||
+ | gvsqw_DefAGR_Scp => | ||
+ | gvsqw_DefAGR_Statistics => | ||
+ | gvsqw_DefAGR_Table => | ||
+ | gvsqw_DefAGR_UpdtStats => | ||
+ | gvsqw_DefCompLevel => | ||
+ | gvsqw_DefCompRate => | ||
+ | gvsqw_DefCopyDumpNbGeneration => | ||
+ | gvsqw_DefDumpNbGeneration => | ||
+ | gvsqw_DefDumpType => | ||
+ | gvsqw_DefMaxSizeStrip => | ||
+ | gvsqw_DefNbAttempt => | ||
+ | gvsqw_DefNbStripeMax => | ||
+ | gvsqw_DefSizeMaxTableRebuild => | ||
+ | gvsqw_DefSizeMaxTableStatistics => | ||
+ | gvsqw_DefSizeMaxTableUpdtStats => | ||
+ | gvsqw_DefSizeMinTableRebuild => | ||
+ | gvsqw_DefUpdtStatsType => | ||
+ | gvsqw_DistGlobalInterfacesFile => | ||
+ | gvsqw_DumpSyntaxType => | ||
+ | gvsqw_DumpSyslogins => | ||
+ | gvsqw_DumpTruncMasterLog => | ||
+ | gvsqw_ErrorLog => | ||
+ | gvsqw_ErrorLogPath => | ||
+ | gvsqw_ExcludeDatabasesCopy => | ||
+ | gvsqw_ExcludeDatabases => | ||
+ | gvsqw_ExcludeDatabasesLoad => | ||
+ | gvsqw_ExcludeEvalVar => | ||
+ | #gvsqw_ForcedReturnCodeScript_sqwsyb_DumpAllDatabases => | ||
+ | gvsqw_GenExcludeDatabasesObjectsExtra => | ||
+ | gvsqw_GenExcludeDatabasesObjects => | ||
+ | gvsqw_GlobalInterfacesFile => | ||
+ | gvsqw_HashSize => | ||
+ | gvsqw_MinPctChange => | ||
+ | gvsqw_NbThreadCheckstorage => | ||
+ | gvsqw_NbThreadCopyDump => | ||
+ | gvsqw_NbThreadDbcc => | ||
+ | gvsqw_NbThreadDump => | ||
+ | gvsqw_NbThreadLoad => | ||
+ | gvsqw_NbThreadRebuild => | ||
+ | gvsqw_NbThreadScp => | ||
+ | gvsqw_NbThreadStatistics => | ||
+ | gvsqw_NbThreadTable => | ||
+ | gvsqw_NbThreadUpdtStats => | ||
+ | gvsqw_PasswdFile => | ||
+ | gvsqw_PathListExtra => | ||
+ | gvsqw_PathList => | ||
+ | gvsqw_RootAdmin => | ||
+ | gvsqw_RootAdminDisable => | ||
+ | gvsqw_RootAdminDist => | ||
+ | gvsqw_RootCfg => | ||
+ | gvsqw_RootDev => | ||
+ | gvsqw_RootDump => | ||
+ | gvsqw_RootDumpSource => | ||
+ | gvsqw_RsyncDefaultSourceDir => | ||
+ | gvsqw_RsyncGap => | ||
+ | gvsqw_RunFile => | ||
+ | gvsqw_RunFilePath => | ||
+ | gvsqw_SaUser => | ||
+ | gvsqw_SizeMinTableIndicators => | ||
+ | gvsqw_SqwVersionDbms => | ||
+ | gvsqw_StatsSamplePctMini => | ||
+ | gvsqw_StatsSampleSizeMaxRead => | ||
+ | gvsqw_StatsSizeMoMin100Pct => | ||
+ | gvsqw_StringReplaceSch => | ||
+ | gvsqw_SubPathList => | ||
+ | gvsqw_SubPathSys => | ||
+ | gvsqw_WhereClauseGenDatabaseList_15 => | ||
+ | gvsqw_WhereClauseGenDatabaseList => | ||
+ | gvsqw_WithHashing => | ||
+ | </pre> | ||
{{SQWareProductionSurchargeVar|sybase|Syb|sqwsyb_GlobalVar.cfg}} | {{SQWareProductionSurchargeVar|sybase|Syb|sqwsyb_GlobalVar.cfg}} | ||
<br> | <br> |
Version du 31 octobre 2024 à 15:44
Fichier de configuration $gvsqw_SybBin/../etc/sqwsyb_GlobalVar.cfg:
Global var for Sybase
Contient les variables operationnelles de SQWareProduction.
Contenu du fichier:
export gvsqw_SqwVersionDbms=2024.07 export gvsqw_ExcludeEvalVar='^gvsqw_ExternalDbaUser=|^gvsqw_SaUserPasswd=' export gvsqw_SaUser='sa' export gvsqw_PasswdFile="$HOME/.passwd" export gvsqw_GlobalInterfacesFile='$SYBASE/interfaces' export gvsqw_BackupServer='$(echo ${DSQUERY}|sed s,^DS_,BS_,)' export gvsqw_RootAdmin='$HOME/${DSQUERY}' export gvsqw_RootAdminDisable='$HOME' export gvsqw_RootAdminDist='$HOME/admin/sybase/${DSQUERY}' export gvsqw_RootCfg='$gvsqw_RootAdmin/sqwConfig' 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_ExcludeDatabases="'dbccdb','sybsecurity','sybsystemdb','model','audsa'" export gvsqw_WhereClauseGenDatabaseList="and dbid < 32000 and name not like '%tempdb%' export gvsqw_WhereClauseGenDatabaseList_15=" export gvsqw_SizeMinTableIndicators=100 export gvsqw_DbAlias='$DSQUERY' export gvsqw_DistGlobalInterfacesFile='$HOME/dbSQWare/SQWareCentral/etc_cust/dbsqware_interfaces' export gvsqw_GenExcludeDatabasesObjects="^master$|^model$|^sybsystemprocs$" export gvsqw_GenExcludeDatabasesObjectsExtra="" export gvsqw_StringReplaceSch="tr -d '\015'|tr '\311' 'E'" export gvsqw_PathList="HOME;gvsqw_RootAdmin;gvsqw_RootCfg;gvsqw_RootDump" export gvsqw_PathListExtra="" export gvsqw_DefNbAttempt=4 export gvsqw_NbThreadDbcc=2 export gvsqw_DefAGR_Dbcc=10 export gvsqw_DefAGE_Dbcc=30 export gvsqw_NbThreadCheckstorage=1 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_DefSizeMinTableRebuild=1 export gvsqw_DefSizeMaxTableRebuild=10000 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_StatsSampleSizeMaxRead=1024 export gvsqw_StatsSamplePctMini=1 export gvsqw_DefSizeMaxTableUpdtStats=1000000 export gvsqw_DefUpdtStatsType='index' #could by ('','index','table','all') export gvsqw_MinPctChange=10 export gvsqw_WithHashing='False' export gvsqw_HashSize=1000000 export gvsqw_NbThreadTable=2 export gvsqw_DefAGR_Table=1 export gvsqw_DefAGE_Table=5 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_DumpSyntaxType='NewSyntax' export gvsqw_DumpSyslogins="Enable" export gvsqw_DumpTruncMasterLog="Enable" export gvsqw_RsyncDefaultSourceDir='/$(echo ${HOME}|cut -d/ -f2)/syb_dump/$DSQUERY' export gvsqw_NbThreadCopyDump=2 export gvsqw_DefAGR_CopyDump=10 export gvsqw_DefAGE_CopyDump=30 export gvsqw_NbThreadScp=2 export gvsqw_DefAGR_Scp=10 export gvsqw_DefAGE_Scp=30 export gvsqw_DefCopyDumpNbGeneration=1 export gvsqw_ExcludeDatabasesCopy="'master','sybsystemprocs'" export gvsqw_NbThreadLoad=2 export gvsqw_DefAGR_Load=10 export gvsqw_DefAGE_Load=30 export gvsqw_RsyncGap=20000 export gvsqw_ExcludeDatabasesLoad="'master','sybsystemprocs'" #export gvsqw_ForcedReturnCodeScript_sqwsyb_DumpAllDatabases=0
Explication des variables:
gvsqw_BackupServer => gvsqw_CluRatioMinIndex => gvsqw_CluRatioMinTable => gvsqw_ConfigFilePath => gvsqw_DbAlias => gvsqw_DefAGE_Checkstorage => gvsqw_DefAGE_CopyDump => gvsqw_DefAGE_Dbcc => gvsqw_DefAGE_Dump => gvsqw_DefAGE_Load => gvsqw_DefAGE_Rebuild => gvsqw_DefAGE_Scp => gvsqw_DefAGE_Statistics => gvsqw_DefAGE_Table => gvsqw_DefAGE_UpdtStats => gvsqw_DefAGR_Checkstorage => gvsqw_DefAGR_CopyDump => gvsqw_DefAGR_Dbcc => gvsqw_DefAGR_Dump => gvsqw_DefAGR_Load => gvsqw_DefAGR_Rebuild => gvsqw_DefAGR_Scp => gvsqw_DefAGR_Statistics => gvsqw_DefAGR_Table => gvsqw_DefAGR_UpdtStats => gvsqw_DefCompLevel => gvsqw_DefCompRate => gvsqw_DefCopyDumpNbGeneration => gvsqw_DefDumpNbGeneration => gvsqw_DefDumpType => gvsqw_DefMaxSizeStrip => gvsqw_DefNbAttempt => gvsqw_DefNbStripeMax => gvsqw_DefSizeMaxTableRebuild => gvsqw_DefSizeMaxTableStatistics => gvsqw_DefSizeMaxTableUpdtStats => gvsqw_DefSizeMinTableRebuild => gvsqw_DefUpdtStatsType => gvsqw_DistGlobalInterfacesFile => gvsqw_DumpSyntaxType => gvsqw_DumpSyslogins => gvsqw_DumpTruncMasterLog => gvsqw_ErrorLog => gvsqw_ErrorLogPath => gvsqw_ExcludeDatabasesCopy => gvsqw_ExcludeDatabases => gvsqw_ExcludeDatabasesLoad => gvsqw_ExcludeEvalVar => #gvsqw_ForcedReturnCodeScript_sqwsyb_DumpAllDatabases => gvsqw_GenExcludeDatabasesObjectsExtra => gvsqw_GenExcludeDatabasesObjects => gvsqw_GlobalInterfacesFile => gvsqw_HashSize => gvsqw_MinPctChange => gvsqw_NbThreadCheckstorage => gvsqw_NbThreadCopyDump => gvsqw_NbThreadDbcc => gvsqw_NbThreadDump => gvsqw_NbThreadLoad => gvsqw_NbThreadRebuild => gvsqw_NbThreadScp => gvsqw_NbThreadStatistics => gvsqw_NbThreadTable => gvsqw_NbThreadUpdtStats => gvsqw_PasswdFile => gvsqw_PathListExtra => gvsqw_PathList => gvsqw_RootAdmin => gvsqw_RootAdminDisable => gvsqw_RootAdminDist => gvsqw_RootCfg => gvsqw_RootDev => gvsqw_RootDump => gvsqw_RootDumpSource => gvsqw_RsyncDefaultSourceDir => gvsqw_RsyncGap => gvsqw_RunFile => gvsqw_RunFilePath => gvsqw_SaUser => gvsqw_SizeMinTableIndicators => gvsqw_SqwVersionDbms => gvsqw_StatsSamplePctMini => gvsqw_StatsSampleSizeMaxRead => gvsqw_StatsSizeMoMin100Pct => gvsqw_StringReplaceSch => gvsqw_SubPathList => gvsqw_SubPathSys => gvsqw_WhereClauseGenDatabaseList_15 => gvsqw_WhereClauseGenDatabaseList => gvsqw_WithHashing =>