Difference between revisions of "SQWareProduction:sybase"
m (Updated by Expdbtools) |
m (Updated by Expdbtools) |
||
Line 1: | Line 1: | ||
− | {{SQWareProductionPresSgbd|sybase|Syb}} | + | {{SQWareProductionPresSgbd|sybase|Syb|syb}} |
== bin == | == bin == | ||
Line 5: | Line 5: | ||
Script $gvsqw_SybBin/bin/sqwsyb_CheckIndicators.ksh:<br> | Script $gvsqw_SybBin/bin/sqwsyb_CheckIndicators.ksh:<br> | ||
{{SQWareProduction_sqwsyb_CheckIndicators.ksh_presentation}} | {{SQWareProduction_sqwsyb_CheckIndicators.ksh_presentation}} | ||
− | + | [[SQWareProduction:sybase:bin:sqwsyb_CheckIndicators.ksh|See the detailed help for sqwsyb_CheckIndicators.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:bin:sqwsyb_CheckIndicators.ksh|See the detailed help for sqwsyb_CheckIndicators.ksh]]<br> | ||
=== sqwsyb_CheckstorageAllDatabases.ksh === | === sqwsyb_CheckstorageAllDatabases.ksh === | ||
Script $gvsqw_SybBin/bin/sqwsyb_CheckstorageAllDatabases.ksh:<br> | Script $gvsqw_SybBin/bin/sqwsyb_CheckstorageAllDatabases.ksh:<br> | ||
{{SQWareProduction_sqwsyb_CheckstorageAllDatabases.ksh_presentation}} | {{SQWareProduction_sqwsyb_CheckstorageAllDatabases.ksh_presentation}} | ||
− | + | [[SQWareProduction:sybase:bin:sqwsyb_CheckstorageAllDatabases.ksh|See the detailed help for sqwsyb_CheckstorageAllDatabases.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:bin:sqwsyb_CheckstorageAllDatabases.ksh|See the detailed help for sqwsyb_CheckstorageAllDatabases.ksh]]<br> | ||
=== sqwsyb_CheckstorageDatabase.ksh === | === sqwsyb_CheckstorageDatabase.ksh === | ||
Script $gvsqw_SybBin/bin/sqwsyb_CheckstorageDatabase.ksh:<br> | Script $gvsqw_SybBin/bin/sqwsyb_CheckstorageDatabase.ksh:<br> | ||
{{SQWareProduction_sqwsyb_CheckstorageDatabase.ksh_presentation}} | {{SQWareProduction_sqwsyb_CheckstorageDatabase.ksh_presentation}} | ||
− | + | [[SQWareProduction:sybase:bin:sqwsyb_CheckstorageDatabase.ksh|See the detailed help for sqwsyb_CheckstorageDatabase.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:bin:sqwsyb_CheckstorageDatabase.ksh|See the detailed help for sqwsyb_CheckstorageDatabase.ksh]]<br> | ||
=== sqwsyb_CopyDumpDatabase.ksh === | === sqwsyb_CopyDumpDatabase.ksh === | ||
Script $gvsqw_SybBin/bin/sqwsyb_CopyDumpDatabase.ksh:<br> | Script $gvsqw_SybBin/bin/sqwsyb_CopyDumpDatabase.ksh:<br> | ||
{{SQWareProduction_sqwsyb_CopyDumpDatabase.ksh_presentation}} | {{SQWareProduction_sqwsyb_CopyDumpDatabase.ksh_presentation}} | ||
− | + | [[SQWareProduction:sybase:bin:sqwsyb_CopyDumpDatabase.ksh|See the detailed help for sqwsyb_CopyDumpDatabase.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:bin:sqwsyb_CopyDumpDatabase.ksh|See the detailed help for sqwsyb_CopyDumpDatabase.ksh]]<br> | ||
=== sqwsyb_DbccAllDatabases.ksh === | === sqwsyb_DbccAllDatabases.ksh === | ||
Script $gvsqw_SybBin/bin/sqwsyb_DbccAllDatabases.ksh:<br> | Script $gvsqw_SybBin/bin/sqwsyb_DbccAllDatabases.ksh:<br> | ||
{{SQWareProduction_sqwsyb_DbccAllDatabases.ksh_presentation}} | {{SQWareProduction_sqwsyb_DbccAllDatabases.ksh_presentation}} | ||
− | + | [[SQWareProduction:sybase:bin:sqwsyb_DbccAllDatabases.ksh|See the detailed help for sqwsyb_DbccAllDatabases.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:bin:sqwsyb_DbccAllDatabases.ksh|See the detailed help for sqwsyb_DbccAllDatabases.ksh]]<br> | ||
=== sqwsyb_DbccDatabase.ksh === | === sqwsyb_DbccDatabase.ksh === | ||
Script $gvsqw_SybBin/bin/sqwsyb_DbccDatabase.ksh:<br> | Script $gvsqw_SybBin/bin/sqwsyb_DbccDatabase.ksh:<br> | ||
{{SQWareProduction_sqwsyb_DbccDatabase.ksh_presentation}} | {{SQWareProduction_sqwsyb_DbccDatabase.ksh_presentation}} | ||
− | + | [[SQWareProduction:sybase:bin:sqwsyb_DbccDatabase.ksh|See the detailed help for sqwsyb_DbccDatabase.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:bin:sqwsyb_DbccDatabase.ksh|See the detailed help for sqwsyb_DbccDatabase.ksh]]<br> | ||
=== sqwsyb_DumpAllDatabases.ksh === | === sqwsyb_DumpAllDatabases.ksh === | ||
Script $gvsqw_SybBin/bin/sqwsyb_DumpAllDatabases.ksh:<br> | Script $gvsqw_SybBin/bin/sqwsyb_DumpAllDatabases.ksh:<br> | ||
{{SQWareProduction_sqwsyb_DumpAllDatabases.ksh_presentation}} | {{SQWareProduction_sqwsyb_DumpAllDatabases.ksh_presentation}} | ||
− | + | [[SQWareProduction:sybase:bin:sqwsyb_DumpAllDatabases.ksh|See the detailed help for sqwsyb_DumpAllDatabases.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:bin:sqwsyb_DumpAllDatabases.ksh|See the detailed help for sqwsyb_DumpAllDatabases.ksh]]<br> | ||
=== sqwsyb_DumpDatabase.ksh === | === sqwsyb_DumpDatabase.ksh === | ||
Script $gvsqw_SybBin/bin/sqwsyb_DumpDatabase.ksh:<br> | Script $gvsqw_SybBin/bin/sqwsyb_DumpDatabase.ksh:<br> | ||
{{SQWareProduction_sqwsyb_DumpDatabase.ksh_presentation}} | {{SQWareProduction_sqwsyb_DumpDatabase.ksh_presentation}} | ||
− | + | [[SQWareProduction:sybase:bin:sqwsyb_DumpDatabase.ksh|See the detailed help for sqwsyb_DumpDatabase.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:bin:sqwsyb_DumpDatabase.ksh|See the detailed help for sqwsyb_DumpDatabase.ksh]]<br> | ||
=== sqwsyb_GatherIndicators.ksh === | === sqwsyb_GatherIndicators.ksh === | ||
Script $gvsqw_SybBin/bin/sqwsyb_GatherIndicators.ksh:<br> | Script $gvsqw_SybBin/bin/sqwsyb_GatherIndicators.ksh:<br> | ||
{{SQWareProduction_sqwsyb_GatherIndicators.ksh_presentation}} | {{SQWareProduction_sqwsyb_GatherIndicators.ksh_presentation}} | ||
− | + | [[SQWareProduction:sybase:bin:sqwsyb_GatherIndicators.ksh|See the detailed help for sqwsyb_GatherIndicators.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:bin:sqwsyb_GatherIndicators.ksh|See the detailed help for sqwsyb_GatherIndicators.ksh]]<br> | ||
=== sqwsyb_KillSessions.ksh === | === sqwsyb_KillSessions.ksh === | ||
Script $gvsqw_SybBin/bin/sqwsyb_KillSessions.ksh:<br> | Script $gvsqw_SybBin/bin/sqwsyb_KillSessions.ksh:<br> | ||
{{SQWareProduction_sqwsyb_KillSessions.ksh_presentation}} | {{SQWareProduction_sqwsyb_KillSessions.ksh_presentation}} | ||
− | + | [[SQWareProduction:sybase:bin:sqwsyb_KillSessions.ksh|See the detailed help for sqwsyb_KillSessions.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:bin:sqwsyb_KillSessions.ksh|See the detailed help for sqwsyb_KillSessions.ksh]]<br> | ||
=== sqwsyb_LoadDatabase.ksh === | === sqwsyb_LoadDatabase.ksh === | ||
Script $gvsqw_SybBin/bin/sqwsyb_LoadDatabase.ksh:<br> | Script $gvsqw_SybBin/bin/sqwsyb_LoadDatabase.ksh:<br> | ||
{{SQWareProduction_sqwsyb_LoadDatabase.ksh_presentation}} | {{SQWareProduction_sqwsyb_LoadDatabase.ksh_presentation}} | ||
− | + | [[SQWareProduction:sybase:bin:sqwsyb_LoadDatabase.ksh|See the detailed help for sqwsyb_LoadDatabase.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:bin:sqwsyb_LoadDatabase.ksh|See the detailed help for sqwsyb_LoadDatabase.ksh]]<br> | ||
=== sqwsyb_ParallelRun.ksh === | === sqwsyb_ParallelRun.ksh === | ||
Script $gvsqw_SybBin/bin/sqwsyb_ParallelRun.ksh:<br> | Script $gvsqw_SybBin/bin/sqwsyb_ParallelRun.ksh:<br> | ||
{{SQWareProduction_sqwsyb_ParallelRun.ksh_presentation}} | {{SQWareProduction_sqwsyb_ParallelRun.ksh_presentation}} | ||
− | + | [[SQWareProduction:sybase:bin:sqwsyb_ParallelRun.ksh|See the detailed help for sqwsyb_ParallelRun.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:bin:sqwsyb_ParallelRun.ksh|See the detailed help for sqwsyb_ParallelRun.ksh]]<br> | ||
=== sqwsyb_RebuildAllDatabases.ksh === | === sqwsyb_RebuildAllDatabases.ksh === | ||
Script $gvsqw_SybBin/bin/sqwsyb_RebuildAllDatabases.ksh:<br> | Script $gvsqw_SybBin/bin/sqwsyb_RebuildAllDatabases.ksh:<br> | ||
{{SQWareProduction_sqwsyb_RebuildAllDatabases.ksh_presentation}} | {{SQWareProduction_sqwsyb_RebuildAllDatabases.ksh_presentation}} | ||
− | + | [[SQWareProduction:sybase:bin:sqwsyb_RebuildAllDatabases.ksh|See the detailed help for sqwsyb_RebuildAllDatabases.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:bin:sqwsyb_RebuildAllDatabases.ksh|See the detailed help for sqwsyb_RebuildAllDatabases.ksh]]<br> | ||
=== sqwsyb_RebuildDatabase.ksh === | === sqwsyb_RebuildDatabase.ksh === | ||
Script $gvsqw_SybBin/bin/sqwsyb_RebuildDatabase.ksh:<br> | Script $gvsqw_SybBin/bin/sqwsyb_RebuildDatabase.ksh:<br> | ||
{{SQWareProduction_sqwsyb_RebuildDatabase.ksh_presentation}} | {{SQWareProduction_sqwsyb_RebuildDatabase.ksh_presentation}} | ||
− | + | [[SQWareProduction:sybase:bin:sqwsyb_RebuildDatabase.ksh|See the detailed help for sqwsyb_RebuildDatabase.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:bin:sqwsyb_RebuildDatabase.ksh|See the detailed help for sqwsyb_RebuildDatabase.ksh]]<br> | ||
=== sqwsyb_RunJob.ksh === | === sqwsyb_RunJob.ksh === | ||
Script $gvsqw_SybBin/bin/sqwsyb_RunJob.ksh:<br> | Script $gvsqw_SybBin/bin/sqwsyb_RunJob.ksh:<br> | ||
{{SQWareProduction_sqwsyb_RunJob.ksh_presentation}} | {{SQWareProduction_sqwsyb_RunJob.ksh_presentation}} | ||
− | + | [[SQWareProduction:sybase:bin:sqwsyb_RunJob.ksh|See the detailed help for sqwsyb_RunJob.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:bin:sqwsyb_RunJob.ksh|See the detailed help for sqwsyb_RunJob.ksh]]<br> | ||
=== sqwsyb_StatisticsAllDatabases.ksh === | === sqwsyb_StatisticsAllDatabases.ksh === | ||
Script $gvsqw_SybBin/bin/sqwsyb_StatisticsAllDatabases.ksh:<br> | Script $gvsqw_SybBin/bin/sqwsyb_StatisticsAllDatabases.ksh:<br> | ||
{{SQWareProduction_sqwsyb_StatisticsAllDatabases.ksh_presentation}} | {{SQWareProduction_sqwsyb_StatisticsAllDatabases.ksh_presentation}} | ||
− | + | [[SQWareProduction:sybase:bin:sqwsyb_StatisticsAllDatabases.ksh|See the detailed help for sqwsyb_StatisticsAllDatabases.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:bin:sqwsyb_StatisticsAllDatabases.ksh|See the detailed help for sqwsyb_StatisticsAllDatabases.ksh]]<br> | ||
=== sqwsyb_StatisticsDatabase.ksh === | === sqwsyb_StatisticsDatabase.ksh === | ||
Script $gvsqw_SybBin/bin/sqwsyb_StatisticsDatabase.ksh:<br> | Script $gvsqw_SybBin/bin/sqwsyb_StatisticsDatabase.ksh:<br> | ||
{{SQWareProduction_sqwsyb_StatisticsDatabase.ksh_presentation}} | {{SQWareProduction_sqwsyb_StatisticsDatabase.ksh_presentation}} | ||
− | + | [[SQWareProduction:sybase:bin:sqwsyb_StatisticsDatabase.ksh|See the detailed help for sqwsyb_StatisticsDatabase.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:bin:sqwsyb_StatisticsDatabase.ksh|See the detailed help for sqwsyb_StatisticsDatabase.ksh]]<br> | ||
=== sqwsyb_UpdtStatsAllDatabases.ksh === | === sqwsyb_UpdtStatsAllDatabases.ksh === | ||
Script $gvsqw_SybBin/bin/sqwsyb_UpdtStatsAllDatabases.ksh:<br> | Script $gvsqw_SybBin/bin/sqwsyb_UpdtStatsAllDatabases.ksh:<br> | ||
{{SQWareProduction_sqwsyb_UpdtStatsAllDatabases.ksh_presentation}} | {{SQWareProduction_sqwsyb_UpdtStatsAllDatabases.ksh_presentation}} | ||
− | + | [[SQWareProduction:sybase:bin:sqwsyb_UpdtStatsAllDatabases.ksh|See the detailed help for sqwsyb_UpdtStatsAllDatabases.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:bin:sqwsyb_UpdtStatsAllDatabases.ksh|See the detailed help for sqwsyb_UpdtStatsAllDatabases.ksh]]<br> | ||
=== sqwsyb_UpdtStatsDatabase.ksh === | === sqwsyb_UpdtStatsDatabase.ksh === | ||
Script $gvsqw_SybBin/bin/sqwsyb_UpdtStatsDatabase.ksh:<br> | Script $gvsqw_SybBin/bin/sqwsyb_UpdtStatsDatabase.ksh:<br> | ||
{{SQWareProduction_sqwsyb_UpdtStatsDatabase.ksh_presentation}} | {{SQWareProduction_sqwsyb_UpdtStatsDatabase.ksh_presentation}} | ||
+ | [[SQWareProduction:sybase:bin:sqwsyb_UpdtStatsDatabase.ksh|See the detailed help for sqwsyb_UpdtStatsDatabase.ksh]]<br><br> | ||
+ | |||
<br> | <br> | ||
− | |||
− | |||
− | |||
== etc == | == etc == | ||
Line 124: | Line 105: | ||
<br> | <br> | ||
{{SQWareProductionSurchargeEtc|sybase|Syb|sqwsyb_CreDs_Cfg.cfg}} | {{SQWareProductionSurchargeEtc|sybase|Syb|sqwsyb_CreDs_Cfg.cfg}} | ||
− | + | [[SQWareProduction:sybase:etc:sqwsyb_CreDs_Cfg.cfg|See the detailed help for sqwsyb_CreDs_Cfg.cfg]]<br><br> | |
− | [[SQWareProduction:sybase:etc:sqwsyb_CreDs_Cfg.cfg|See the detailed help for sqwsyb_CreDs_Cfg.cfg]]<br> | ||
=== sqwsyb_CreDs_CrontabRef.cfg === | === sqwsyb_CreDs_CrontabRef.cfg === | ||
Line 132: | Line 112: | ||
<br> | <br> | ||
{{SQWareProductionSurchargeEtc|sybase|Syb|sqwsyb_CreDs_CrontabRef.cfg}} | {{SQWareProductionSurchargeEtc|sybase|Syb|sqwsyb_CreDs_CrontabRef.cfg}} | ||
− | + | [[SQWareProduction:sybase:etc:sqwsyb_CreDs_CrontabRef.cfg|See the detailed help for sqwsyb_CreDs_CrontabRef.cfg]]<br><br> | |
− | [[SQWareProduction:sybase:etc:sqwsyb_CreDs_CrontabRef.cfg|See the detailed help for sqwsyb_CreDs_CrontabRef.cfg]]<br> | ||
=== sqwsyb_CreDs_Jobs.cfg === | === sqwsyb_CreDs_Jobs.cfg === | ||
Line 140: | Line 119: | ||
<br> | <br> | ||
{{SQWareProductionSurchargeEtc|sybase|Syb|sqwsyb_CreDs_Jobs.cfg}} | {{SQWareProductionSurchargeEtc|sybase|Syb|sqwsyb_CreDs_Jobs.cfg}} | ||
− | + | [[SQWareProduction:sybase:etc:sqwsyb_CreDs_Jobs.cfg|See the detailed help for sqwsyb_CreDs_Jobs.cfg]]<br><br> | |
− | [[SQWareProduction:sybase:etc:sqwsyb_CreDs_Jobs.cfg|See the detailed help for sqwsyb_CreDs_Jobs.cfg]]<br> | ||
=== sqwsyb_CreDs_RunBs.cfg === | === sqwsyb_CreDs_RunBs.cfg === | ||
Line 148: | Line 126: | ||
<br> | <br> | ||
{{SQWareProductionSurchargeEtc|sybase|Syb|sqwsyb_CreDs_RunBs.cfg}} | {{SQWareProductionSurchargeEtc|sybase|Syb|sqwsyb_CreDs_RunBs.cfg}} | ||
− | + | [[SQWareProduction:sybase:etc:sqwsyb_CreDs_RunBs.cfg|See the detailed help for sqwsyb_CreDs_RunBs.cfg]]<br><br> | |
− | [[SQWareProduction:sybase:etc:sqwsyb_CreDs_RunBs.cfg|See the detailed help for sqwsyb_CreDs_RunBs.cfg]]<br> | ||
=== sqwsyb_CreDs_RunDs.cfg === | === sqwsyb_CreDs_RunDs.cfg === | ||
Line 156: | Line 133: | ||
<br> | <br> | ||
{{SQWareProductionSurchargeEtc|sybase|Syb|sqwsyb_CreDs_RunDs.cfg}} | {{SQWareProductionSurchargeEtc|sybase|Syb|sqwsyb_CreDs_RunDs.cfg}} | ||
− | + | [[SQWareProduction:sybase:etc:sqwsyb_CreDs_RunDs.cfg|See the detailed help for sqwsyb_CreDs_RunDs.cfg]]<br><br> | |
− | [[SQWareProduction:sybase:etc:sqwsyb_CreDs_RunDs.cfg|See the detailed help for sqwsyb_CreDs_RunDs.cfg]]<br> | ||
=== sqwsyb_CrontabRef.cfg === | === sqwsyb_CrontabRef.cfg === | ||
Line 164: | Line 140: | ||
<br> | <br> | ||
{{SQWareProductionSurchargeEtc|sybase|Syb|sqwsyb_CrontabRef.cfg}} | {{SQWareProductionSurchargeEtc|sybase|Syb|sqwsyb_CrontabRef.cfg}} | ||
− | + | [[SQWareProduction:sybase:etc:sqwsyb_CrontabRef.cfg|See the detailed help for sqwsyb_CrontabRef.cfg]]<br><br> | |
− | [[SQWareProduction:sybase:etc:sqwsyb_CrontabRef.cfg|See the detailed help for sqwsyb_CrontabRef.cfg]]<br> | ||
=== sqwsyb_DbRefVar.cfg === | === sqwsyb_DbRefVar.cfg === | ||
Line 172: | Line 147: | ||
<br> | <br> | ||
{{SQWareProductionSurchargeVar|sybase|Syb|sqwsyb_DbRefVar.cfg}} | {{SQWareProductionSurchargeVar|sybase|Syb|sqwsyb_DbRefVar.cfg}} | ||
− | + | [[SQWareProduction:sybase:etc:sqwsyb_DbRefVar.cfg|See the detailed help for sqwsyb_DbRefVar.cfg]]<br><br> | |
− | [[SQWareProduction:sybase:etc:sqwsyb_DbRefVar.cfg|See the detailed help for sqwsyb_DbRefVar.cfg]]<br> | ||
=== sqwsyb_GlobalVar.cfg === | === sqwsyb_GlobalVar.cfg === | ||
Line 180: | Line 154: | ||
<br> | <br> | ||
{{SQWareProductionSurchargeVar|sybase|Syb|sqwsyb_GlobalVar.cfg}} | {{SQWareProductionSurchargeVar|sybase|Syb|sqwsyb_GlobalVar.cfg}} | ||
− | + | [[SQWareProduction:sybase:etc:sqwsyb_GlobalVar.cfg|See the detailed help for sqwsyb_GlobalVar.cfg]]<br><br> | |
− | [[SQWareProduction:sybase:etc:sqwsyb_GlobalVar.cfg|See the detailed help for sqwsyb_GlobalVar.cfg]]<br> | ||
=== sqwsyb_IndicatorsVar.cfg === | === sqwsyb_IndicatorsVar.cfg === | ||
Line 188: | Line 161: | ||
<br> | <br> | ||
{{SQWareProductionSurchargeEtc|sybase|Syb|sqwsyb_IndicatorsVar.cfg}} | {{SQWareProductionSurchargeEtc|sybase|Syb|sqwsyb_IndicatorsVar.cfg}} | ||
− | + | [[SQWareProduction:sybase:etc:sqwsyb_IndicatorsVar.cfg|See the detailed help for sqwsyb_IndicatorsVar.cfg]]<br><br> | |
− | [[SQWareProduction:sybase:etc:sqwsyb_IndicatorsVar.cfg|See the detailed help for sqwsyb_IndicatorsVar.cfg]]<br> | ||
=== sqwsyb_Jobs.cfg === | === sqwsyb_Jobs.cfg === | ||
Line 196: | Line 168: | ||
<br> | <br> | ||
{{SQWareProductionSurchargeEtc|sybase|Syb|sqwsyb_Jobs.cfg}} | {{SQWareProductionSurchargeEtc|sybase|Syb|sqwsyb_Jobs.cfg}} | ||
− | + | [[SQWareProduction:sybase:etc:sqwsyb_Jobs.cfg|See the detailed help for sqwsyb_Jobs.cfg]]<br><br> | |
− | [[SQWareProduction:sybase:etc:sqwsyb_Jobs.cfg|See the detailed help for sqwsyb_Jobs.cfg]]<br> | ||
=== sqwsyb_Template.cfg === | === sqwsyb_Template.cfg === | ||
Line 204: | Line 175: | ||
<br> | <br> | ||
{{SQWareProductionSurchargeEtc|sybase|Syb|sqwsyb_Template.cfg}} | {{SQWareProductionSurchargeEtc|sybase|Syb|sqwsyb_Template.cfg}} | ||
− | + | [[SQWareProduction:sybase:etc:sqwsyb_Template.cfg|See the detailed help for sqwsyb_Template.cfg]]<br><br> | |
− | [[SQWareProduction:sybase:etc:sqwsyb_Template.cfg|See the detailed help for sqwsyb_Template.cfg]]<br> | ||
=== .profile === | === .profile === | ||
Line 215: | Line 185: | ||
File to put aliases $gvsqw_SybBin/../etc/.profile_confort:<br> | File to put aliases $gvsqw_SybBin/../etc/.profile_confort:<br> | ||
Contains confort aliases of SQWareProduction for RDBMS sybase.<br> | Contains confort aliases of SQWareProduction for RDBMS sybase.<br> | ||
− | |||
{{SQWareProductionSurchargeConfort|sybase|Syb}} | {{SQWareProductionSurchargeConfort|sybase|Syb}} | ||
<br> | <br> | ||
− | [[SQWareProduction:sybase:etc:.profile_confort|See the detailed help for .profile_confort]]<br> | + | [[SQWareProduction:sybase:etc:.profile_confort|See the detailed help for .profile_confort]]<br><br> |
− | + | <br> | |
== lib == | == lib == | ||
Line 226: | Line 195: | ||
shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_CheckIndicators.lib:<br> | shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_CheckIndicators.lib:<br> | ||
{{SQWareProduction_sqwsyb_CheckIndicators.lib_presentation}} | {{SQWareProduction_sqwsyb_CheckIndicators.lib_presentation}} | ||
− | |||
{{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_CheckIndicators.lib}} | {{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_CheckIndicators.lib}} | ||
<br> | <br> | ||
− | [[SQWareProduction:sybase:lib:sqwsyb_CheckIndicators.lib|See the detailed help for sqwsyb_CheckIndicators.lib]]<br> | + | [[SQWareProduction:sybase:lib:sqwsyb_CheckIndicators.lib|See the detailed help for sqwsyb_CheckIndicators.lib]]<br><br> |
=== sqwsyb_CheckIndicators_Overload.lib === | === sqwsyb_CheckIndicators_Overload.lib === | ||
shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_CheckIndicators_Overload.lib:<br> | shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_CheckIndicators_Overload.lib:<br> | ||
{{SQWareProduction_sqwsyb_CheckIndicators_Overload.lib_presentation}} | {{SQWareProduction_sqwsyb_CheckIndicators_Overload.lib_presentation}} | ||
− | |||
{{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_CheckIndicators_Overload.lib}} | {{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_CheckIndicators_Overload.lib}} | ||
<br> | <br> | ||
− | [[SQWareProduction:sybase:lib:sqwsyb_CheckIndicators_Overload.lib|See the detailed help for sqwsyb_CheckIndicators_Overload.lib]]<br> | + | [[SQWareProduction:sybase:lib:sqwsyb_CheckIndicators_Overload.lib|See the detailed help for sqwsyb_CheckIndicators_Overload.lib]]<br><br> |
=== sqwsyb_DumpDatabase.lib === | === sqwsyb_DumpDatabase.lib === | ||
shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_DumpDatabase.lib:<br> | shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_DumpDatabase.lib:<br> | ||
{{SQWareProduction_sqwsyb_DumpDatabase.lib_presentation}} | {{SQWareProduction_sqwsyb_DumpDatabase.lib_presentation}} | ||
− | |||
{{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_DumpDatabase.lib}} | {{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_DumpDatabase.lib}} | ||
<br> | <br> | ||
− | [[SQWareProduction:sybase:lib:sqwsyb_DumpDatabase.lib|See the detailed help for sqwsyb_DumpDatabase.lib]]<br> | + | [[SQWareProduction:sybase:lib:sqwsyb_DumpDatabase.lib|See the detailed help for sqwsyb_DumpDatabase.lib]]<br><br> |
=== sqwsyb_GatherIndicators.lib === | === sqwsyb_GatherIndicators.lib === | ||
shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_GatherIndicators.lib:<br> | shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_GatherIndicators.lib:<br> | ||
{{SQWareProduction_sqwsyb_GatherIndicators.lib_presentation}} | {{SQWareProduction_sqwsyb_GatherIndicators.lib_presentation}} | ||
− | |||
{{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_GatherIndicators.lib}} | {{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_GatherIndicators.lib}} | ||
<br> | <br> | ||
− | [[SQWareProduction:sybase:lib:sqwsyb_GatherIndicators.lib|See the detailed help for sqwsyb_GatherIndicators.lib]]<br> | + | [[SQWareProduction:sybase:lib:sqwsyb_GatherIndicators.lib|See the detailed help for sqwsyb_GatherIndicators.lib]]<br><br> |
=== sqwsyb_GenerateCreateDataserver.lib === | === sqwsyb_GenerateCreateDataserver.lib === | ||
shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_GenerateCreateDataserver.lib:<br> | shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_GenerateCreateDataserver.lib:<br> | ||
{{SQWareProduction_sqwsyb_GenerateCreateDataserver.lib_presentation}} | {{SQWareProduction_sqwsyb_GenerateCreateDataserver.lib_presentation}} | ||
− | |||
{{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_GenerateCreateDataserver.lib}} | {{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_GenerateCreateDataserver.lib}} | ||
<br> | <br> | ||
− | [[SQWareProduction:sybase:lib:sqwsyb_GenerateCreateDataserver.lib|See the detailed help for sqwsyb_GenerateCreateDataserver.lib]]<br> | + | [[SQWareProduction:sybase:lib:sqwsyb_GenerateCreateDataserver.lib|See the detailed help for sqwsyb_GenerateCreateDataserver.lib]]<br><br> |
=== sqwsyb_Global.lib === | === sqwsyb_Global.lib === | ||
shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_Global.lib:<br> | shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_Global.lib:<br> | ||
{{SQWareProduction_sqwsyb_Global.lib_presentation}} | {{SQWareProduction_sqwsyb_Global.lib_presentation}} | ||
− | |||
{{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_Global.lib}} | {{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_Global.lib}} | ||
<br> | <br> | ||
− | [[SQWareProduction:sybase:lib:sqwsyb_Global.lib|See the detailed help for sqwsyb_Global.lib]]<br> | + | [[SQWareProduction:sybase:lib:sqwsyb_Global.lib|See the detailed help for sqwsyb_Global.lib]]<br><br> |
=== sqwsyb_InsertIndicators.lib === | === sqwsyb_InsertIndicators.lib === | ||
shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_InsertIndicators.lib:<br> | shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_InsertIndicators.lib:<br> | ||
{{SQWareProduction_sqwsyb_InsertIndicators.lib_presentation}} | {{SQWareProduction_sqwsyb_InsertIndicators.lib_presentation}} | ||
− | |||
{{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_InsertIndicators.lib}} | {{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_InsertIndicators.lib}} | ||
<br> | <br> | ||
− | [[SQWareProduction:sybase:lib:sqwsyb_InsertIndicators.lib|See the detailed help for sqwsyb_InsertIndicators.lib]]<br> | + | [[SQWareProduction:sybase:lib:sqwsyb_InsertIndicators.lib|See the detailed help for sqwsyb_InsertIndicators.lib]]<br><br> |
=== sqwsyb_SetEnv.lib === | === sqwsyb_SetEnv.lib === | ||
shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_SetEnv.lib:<br> | shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_SetEnv.lib:<br> | ||
{{SQWareProduction_sqwsyb_SetEnv.lib_presentation}} | {{SQWareProduction_sqwsyb_SetEnv.lib_presentation}} | ||
− | |||
{{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_SetEnv.lib}} | {{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_SetEnv.lib}} | ||
<br> | <br> | ||
− | [[SQWareProduction:sybase:lib:sqwsyb_SetEnv.lib|See the detailed help for sqwsyb_SetEnv.lib]]<br> | + | [[SQWareProduction:sybase:lib:sqwsyb_SetEnv.lib|See the detailed help for sqwsyb_SetEnv.lib]]<br><br> |
=== sqwsyb_UpdtStatsDatabase.lib === | === sqwsyb_UpdtStatsDatabase.lib === | ||
shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_UpdtStatsDatabase.lib:<br> | shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_UpdtStatsDatabase.lib:<br> | ||
{{SQWareProduction_sqwsyb_UpdtStatsDatabase.lib_presentation}} | {{SQWareProduction_sqwsyb_UpdtStatsDatabase.lib_presentation}} | ||
− | |||
{{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_UpdtStatsDatabase.lib}} | {{SQWareProductionSurchargeLib|sybase|Syb|sqwsyb_UpdtStatsDatabase.lib}} | ||
<br> | <br> | ||
− | [[SQWareProduction:sybase:lib:sqwsyb_UpdtStatsDatabase.lib|See the detailed help for sqwsyb_UpdtStatsDatabase.lib]]<br> | + | [[SQWareProduction:sybase:lib:sqwsyb_UpdtStatsDatabase.lib|See the detailed help for sqwsyb_UpdtStatsDatabase.lib]]<br><br> |
− | + | <br> | |
== menu == | == menu == | ||
− | + | <br> | |
== tools == | == tools == | ||
Line 304: | Line 264: | ||
Script $gvsqw_SybBin/../tools/sqwsyb_GenerateCreateDataserver.ksh:<br> | Script $gvsqw_SybBin/../tools/sqwsyb_GenerateCreateDataserver.ksh:<br> | ||
{{SQWareProduction_sqwsyb_GenerateCreateDataserver.ksh_presentation}} | {{SQWareProduction_sqwsyb_GenerateCreateDataserver.ksh_presentation}} | ||
− | + | [[SQWareProduction:sybase:tools:sqwsyb_GenerateCreateDataserver.ksh|See the detailed help for sqwsyb_GenerateCreateDataserver.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:tools:sqwsyb_GenerateCreateDataserver.ksh|See the detailed help for sqwsyb_GenerateCreateDataserver.ksh]]<br> | ||
=== sqwsyb_GetSaPass.ksh === | === sqwsyb_GetSaPass.ksh === | ||
Line 312: | Line 271: | ||
<br> | <br> | ||
{{SQWareProductionSurchargeToo|sybase|Syb|sqwsyb_GetSaPass.ksh}} | {{SQWareProductionSurchargeToo|sybase|Syb|sqwsyb_GetSaPass.ksh}} | ||
− | + | [[SQWareProduction:sybase:tools:sqwsyb_GetSaPass.ksh|See the detailed help for sqwsyb_GetSaPass.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:tools:sqwsyb_GetSaPass.ksh|See the detailed help for sqwsyb_GetSaPass.ksh]]<br> | ||
=== sqwsyb_SetEnv.ksh === | === sqwsyb_SetEnv.ksh === | ||
Line 320: | Line 278: | ||
<br> | <br> | ||
{{SQWareProductionSurchargeToo|sybase|Syb|sqwsyb_SetEnv.ksh}} | {{SQWareProductionSurchargeToo|sybase|Syb|sqwsyb_SetEnv.ksh}} | ||
− | + | [[SQWareProduction:sybase:tools:sqwsyb_SetEnv.ksh|See the detailed help for sqwsyb_SetEnv.ksh]]<br><br> | |
− | [[SQWareProduction:sybase:tools:sqwsyb_SetEnv.ksh|See the detailed help for sqwsyb_SetEnv.ksh]]<br> | ||
=== sqwsyb_Spm.ksh === | === sqwsyb_Spm.ksh === | ||
Script $gvsqw_SybBin/../tools/sqwsyb_Spm.ksh:<br> | Script $gvsqw_SybBin/../tools/sqwsyb_Spm.ksh:<br> | ||
{{SQWareProduction_sqwsyb_Spm.ksh_presentation}} | {{SQWareProduction_sqwsyb_Spm.ksh_presentation}} | ||
+ | [[SQWareProduction:sybase:tools:sqwsyb_Spm.ksh|See the detailed help for sqwsyb_Spm.ksh]]<br><br> | ||
+ | |||
<br> | <br> | ||
− | |||
− | |||
− | |||
== help == | == help == | ||
Line 339: | Line 295: | ||
[[SQWareProduction:sybase:spm|See the detailed help for spm]]<br> | [[SQWareProduction:sybase:spm|See the detailed help for spm]]<br> | ||
− | + | <br> |
Revision as of 19:04, 18 December 2010
Contents
- 1 Presentation
- 2 bin
- 2.1 sqwsyb_CheckIndicators.ksh
- 2.2 sqwsyb_CheckstorageAllDatabases.ksh
- 2.3 sqwsyb_CheckstorageDatabase.ksh
- 2.4 sqwsyb_CopyDumpDatabase.ksh
- 2.5 sqwsyb_DbccAllDatabases.ksh
- 2.6 sqwsyb_DbccDatabase.ksh
- 2.7 sqwsyb_DumpAllDatabases.ksh
- 2.8 sqwsyb_DumpDatabase.ksh
- 2.9 sqwsyb_GatherIndicators.ksh
- 2.10 sqwsyb_KillSessions.ksh
- 2.11 sqwsyb_LoadDatabase.ksh
- 2.12 sqwsyb_ParallelRun.ksh
- 2.13 sqwsyb_RebuildAllDatabases.ksh
- 2.14 sqwsyb_RebuildDatabase.ksh
- 2.15 sqwsyb_RunJob.ksh
- 2.16 sqwsyb_StatisticsAllDatabases.ksh
- 2.17 sqwsyb_StatisticsDatabase.ksh
- 2.18 sqwsyb_UpdtStatsAllDatabases.ksh
- 2.19 sqwsyb_UpdtStatsDatabase.ksh
- 3 etc
- 3.1 sqwsyb_CreDs_Cfg.cfg
- 3.2 sqwsyb_CreDs_CrontabRef.cfg
- 3.3 sqwsyb_CreDs_Jobs.cfg
- 3.4 sqwsyb_CreDs_RunBs.cfg
- 3.5 sqwsyb_CreDs_RunDs.cfg
- 3.6 sqwsyb_CrontabRef.cfg
- 3.7 sqwsyb_DbRefVar.cfg
- 3.8 sqwsyb_GlobalVar.cfg
- 3.9 sqwsyb_IndicatorsVar.cfg
- 3.10 sqwsyb_Jobs.cfg
- 3.11 sqwsyb_Template.cfg
- 3.12 .profile
- 3.13 .profile_confort
- 4 lib
- 5 menu
- 6 tools
- 7 help
- 8 spm
Presentation
Usage
It's the module locally operating of sybase.
It is entirely written in ksh and sql.
It allows to manage the operation for sybase.
Example uses of the tool:
- Backup
- Recovery
- Compute statistics
- Indicators collection to store in referential database SQWareRepository
- Rotate logs
- ....
This module is deployed locally on the machine hosting the authorities to manage,
in order to avoid any points of weakness related to an NFS mount or whatever.
The deployment is done through a simple command SQWareCentral module using inventory located in SQWareRepository !
Installation guide for SQWareProduction for sybase
Explanation of directories
Directories located in $gvsqw_SybBin:
- bin : Directory containing standard scripts
- bin_cust : Directory containing customs scripts for your environnement
- etc : Directory containing the standard files of configuration
- etc_cust : Directory containing the customs files of configuration for your environnement (overload standards)
- help : Directory containing the standard files of help
- help_cust : Directory containing the customs files of help for your environnement
- lib : Directory containing the generic shell function librairies
- lib_cust : Directory containing the generic shell function librairies (overload standards)
- spm : Contain sql query toolkit
- tools : Directory containing the standard scripts used on an ad hoc
- tools_cust : Directory containing the customs scripts used on an ad hoc for your environnement
- menu : Directory containing the standard menus
- menu_cust : Directory containing the custom menus for your environnement
Naming convention of files
The majority of files are named with suffixes:
- *.ksh : for scripts
- *.cfg : for configuration files
- *.lib : for function librairies
- *.hlp : for help files
Naming convention in scripts
In general, the following naming convention is used in all scripts of SQWareProduction:
- gvsqw_ {} : global variable initialized by the environment and / or generic library
- lvsqw_ {} : local variable initialized by the script and / or a specific library
- gfsqw_ {} : function defined by a generic library
- lfsqw_ {} : function defined by the script and / or a specific library
bin
sqwsyb_CheckIndicators.ksh
Script $gvsqw_SybBin/bin/sqwsyb_CheckIndicators.ksh:
Checks the indicators collected by sqwsyb_GatherIndicators.ksh
indicators are stored in SQWareRepository
generates email in html format with links to SQWareWeb
Standards checks:
- Dataservers without indicators
- Usage rate of databases
- Usage rate of FS
- Dataserver without backup succeed since ${gvsqw_NbDaysFull} days
- Databases without backup full succeed since ${gvsqw_NbDaysFull} days
See the detailed help for sqwsyb_CheckIndicators.ksh
sqwsyb_CheckstorageAllDatabases.ksh
Script $gvsqw_SybBin/bin/sqwsyb_CheckstorageAllDatabases.ksh:
Run of sqwsyb_CheckstorageDatabase.ksh in parallel mode
You can choose:
- The parallel degree
- Aggressiveness of run (number of seconds between two runs)
- Aggressiveness of check end (number of seconds between two checks of end)
Filters to generate database list (you can mix all off them):
- Include list of database
- Exclude list of database
- Include like clause
- Exclude like clause
- Where clause
See the detailed help for sqwsyb_CheckstorageAllDatabases.ksh
sqwsyb_CheckstorageDatabase.ksh
Script $gvsqw_SybBin/bin/sqwsyb_CheckstorageDatabase.ksh:
Run Checkstorage commands on database
See the detailed help for sqwsyb_CheckstorageDatabase.ksh
sqwsyb_CopyDumpDatabase.ksh
Script $gvsqw_SybBin/bin/sqwsyb_CopyDumpDatabase.ksh:
Copy Dump file by rsync between two dataservers
You can choose different options:
- different unix users between the two dataservers
- parallel degree of copy
- the file to copy (latest full Dump by default)
- different directory (by default search in standard directory)
The script can also:
- run shell script before Load
- run shell script after Load
See the detailed help for sqwsyb_CopyDumpDatabase.ksh
sqwsyb_DbccAllDatabases.ksh
Script $gvsqw_SybBin/bin/sqwsyb_DbccAllDatabases.ksh:
Run of sqwsyb_DbccDatabase.ksh in parallel mode
You can choose:
- The parallel degree
- Aggressiveness of run (number of seconds between two runs)
- Aggressiveness of check end (number of seconds between two checks of end)
Filters to generate database list (you can mix all off them):
- Include list of database
- Exclude list of database
- Include like clause
- Exclude like clause
- Where clause
See the detailed help for sqwsyb_DbccAllDatabases.ksh
sqwsyb_DbccDatabase.ksh
Script $gvsqw_SybBin/bin/sqwsyb_DbccDatabase.ksh:
Run Dbcc command on database
See the detailed help for sqwsyb_DbccDatabase.ksh
sqwsyb_DumpAllDatabases.ksh
Script $gvsqw_SybBin/bin/sqwsyb_DumpAllDatabases.ksh:
Run of sqwsyb_DumpDatabase.ksh in parallel mode
You can choose:
- The parallel degree
- Aggressiveness of run (number of seconds between two runs)
- Aggressiveness of check end (number of seconds between two checks of end)
Filters to generate database list (you can mix all off them):
- Include list of database
- Exclude list of database
- Include like clause
- Exclude like clause
- Where clause
See the detailed help for sqwsyb_DumpAllDatabases.ksh
sqwsyb_DumpDatabase.ksh
Script $gvsqw_SybBin/bin/sqwsyb_DumpDatabase.ksh:
Generate Dump database
You can choose type of Dump (by default full):
- full -> full Dump
- inc -> Dump tran
- stb -> Dump tran for standby
- fstb -> full Dump plus Dump tran for standby
Script automatically determine how many stripes
Makes backup of master..syslogins (permet to make synchronisation on Load)
Makes purges of Dump generations
You can change default values:
- compression level
- force number of stripes
- size max of a stripe
- number of Dump generations to keep online
See the detailed help for sqwsyb_DumpDatabase.ksh
sqwsyb_GatherIndicators.ksh
Script $gvsqw_SybBin/bin/sqwsyb_GatherIndicators.ksh:
Gather Sybase indicators and put them in SQWareRepository
Summary of collection:
- Volumetry (use, free) of dataserver
- Volumetry (use, free) of databases
- Volumetry of tables
- Volumetry (use, free) of FS
- Version, options, configuration, ... of dataserver
See the detailed help for sqwsyb_GatherIndicators.ksh
sqwsyb_KillSessions.ksh
Script $gvsqw_SybBin/bin/sqwsyb_KillSessions.ksh:
Generate kill of sybase connections
You can include or exclude databases by lists
By default kill all sessions
you can also choose the number of retry to kill session
See the detailed help for sqwsyb_KillSessions.ksh
sqwsyb_LoadDatabase.ksh
Script $gvsqw_SybBin/bin/sqwsyb_LoadDatabase.ksh:
Standard database Load sybase
script dynamically find dump files to Load
You can choose type of Load (by default full):
- full -> Load full dump
- inc -> Load dump tran
- stb -> Load dump tran for standby
- fstb -> Load full dump plus dump tran for standby
You can choose to online database or not(default on):
- on -> online
- off -> not online
- ostb -> online for standby access
The script can also:
- kill connected sessions on the database to Load
- make a synchronisation of syslogins/sysusers
- run shell script before Load
- run shell script after Load
See the detailed help for sqwsyb_LoadDatabase.ksh
sqwsyb_ParallelRun.ksh
Script $gvsqw_SybBin/bin/sqwsyb_ParallelRun.ksh:
Manages the execution of unix commands in parallel mode
Takes in parameter file with unix command to execute
You can choose:
- The parallel degree
- Aggressiveness of run (number of seconds between two runs)
- Aggressiveness of check end (number of seconds between two checks of end)
See the detailed help for sqwsyb_ParallelRun.ksh
sqwsyb_RebuildAllDatabases.ksh
Script $gvsqw_SybBin/bin/sqwsyb_RebuildAllDatabases.ksh:
Run of sqwsyb_RebuildDatabase.ksh in parallel mode
You can choose:
- The parallel degree
- Aggressiveness of run (number of seconds between two runs)
- Aggressiveness of check end (number of seconds between two checks of end)
Filters to generate database list (you can mix all off them):
- Include list of database
- Exclude list of database
- Include like clause
- Exclude like clause
- Where clause
See the detailed help for sqwsyb_RebuildAllDatabases.ksh
sqwsyb_RebuildDatabase.ksh
Script $gvsqw_SybBin/bin/sqwsyb_RebuildDatabase.ksh:
Rebuild index or table who need reorganisation
based on optdiag command to retrieve cluster ratio of tables and indexes
You can choose options:
- Size min of table to consider
- Min cluster ratio for table before Rebuild it
- Min cluster ratio for index before Rebuild it
See the detailed help for sqwsyb_RebuildDatabase.ksh
sqwsyb_RunJob.ksh
Script $gvsqw_SybBin/bin/sqwsyb_RunJob.ksh:
Run Sybase scripts and generate log and error file
based on $gvsqw_RootCfg/sqwsyb_Jobs.cfg configuration file
compress and purge oldest log files
See the detailed help for sqwsyb_RunJob.ksh
sqwsyb_StatisticsAllDatabases.ksh
Script $gvsqw_SybBin/bin/sqwsyb_StatisticsAllDatabases.ksh:
Run of sqwsyb_StatisticsDatabase.ksh in parallel mode
You can choose:
- The parallel degree
- Aggressiveness of run (number of seconds between two runs)
- Aggressiveness of check end (number of seconds between two checks of end)
Filters to generate database list (you can mix all off them):
- Include list of database
- Exclude list of database
- Include like clause
- Exclude like clause
- Where clause
See the detailed help for sqwsyb_StatisticsAllDatabases.ksh
sqwsyb_StatisticsDatabase.ksh
Script $gvsqw_SybBin/bin/sqwsyb_StatisticsDatabase.ksh:
update statistics
use the command 'update statistics $Owner.$Table'
compute Statistics only on the firsts indexed columns
See the detailed help for sqwsyb_StatisticsDatabase.ksh
sqwsyb_UpdtStatsAllDatabases.ksh
Script $gvsqw_SybBin/bin/sqwsyb_UpdtStatsAllDatabases.ksh:
Run of sqwsyb_UpdtStatsDatabase.ksh in parallel mode
You can choose:
- The parallel degree
- Aggressiveness of run (number of seconds between two runs)
- Aggressiveness of check end (number of seconds between two checks of end)
Filters to generate database list (you can mix all off them):
- Include list of database
- Exclude list of database
- Include like clause
- Exclude like clause
- Where clause
See the detailed help for sqwsyb_UpdtStatsAllDatabases.ksh
sqwsyb_UpdtStatsDatabase.ksh
Script $gvsqw_SybBin/bin/sqwsyb_UpdtStatsDatabase.ksh:
update index Statistics
use the command 'update index Statistics $lvsqw_Owner.$lvsqw_Table'
compute Statistics on all indexed columns
you can also force delete with 'delete Statistics $lvsqw_Owner.$lvsqw_Table'
dynamically calculates a sample to put option 'with sampling=$lvsqw_SamplePct percent'
See the detailed help for sqwsyb_UpdtStatsDatabase.ksh
etc
sqwsyb_CreDs_Cfg.cfg
Configuration file $gvsqw_SybBin/../etc/sqwsyb_CreDs_Cfg.cfg:
See the detailed help for sqwsyb_CreDs_Cfg.cfg
sqwsyb_CreDs_CrontabRef.cfg
Configuration file $gvsqw_SybBin/../etc/sqwsyb_CreDs_CrontabRef.cfg:
See the detailed help for sqwsyb_CreDs_CrontabRef.cfg
sqwsyb_CreDs_Jobs.cfg
Configuration file $gvsqw_SybBin/../etc/sqwsyb_CreDs_Jobs.cfg:
See the detailed help for sqwsyb_CreDs_Jobs.cfg
sqwsyb_CreDs_RunBs.cfg
Configuration file $gvsqw_SybBin/../etc/sqwsyb_CreDs_RunBs.cfg:
See the detailed help for sqwsyb_CreDs_RunBs.cfg
sqwsyb_CreDs_RunDs.cfg
Configuration file $gvsqw_SybBin/../etc/sqwsyb_CreDs_RunDs.cfg:
See the detailed help for sqwsyb_CreDs_RunDs.cfg
sqwsyb_CrontabRef.cfg
Configuration file $gvsqw_SybBin/../etc/sqwsyb_CrontabRef.cfg:
See the detailed help for sqwsyb_CrontabRef.cfg
sqwsyb_DbRefVar.cfg
Configuration file $gvsqw_SybBin/../etc/sqwsyb_DbRefVar.cfg:
Global var for indicators
It contains the operating variables of SQWareProduction.
See the detailed help for sqwsyb_DbRefVar.cfg
sqwsyb_GlobalVar.cfg
Configuration file $gvsqw_SybBin/../etc/sqwsyb_GlobalVar.cfg:
Global var for Sybase
It contains the operating variables of SQWareProduction.
See the detailed help for sqwsyb_GlobalVar.cfg
sqwsyb_IndicatorsVar.cfg
Configuration file $gvsqw_SybBin/../etc/sqwsyb_IndicatorsVar.cfg:
Global var for indicators scripts
It contains the operating variables of SQWareProduction.
See the detailed help for sqwsyb_IndicatorsVar.cfg
sqwsyb_Jobs.cfg
Configuration file $gvsqw_SybBin/../etc/sqwsyb_Jobs.cfg:
See the detailed help for sqwsyb_Jobs.cfg
sqwsyb_Template.cfg
Configuration file $gvsqw_SybBin/../etc/sqwsyb_Template.cfg:
Template for overLoad default paramaters of 'All' scripts
See the detailed help for sqwsyb_Template.cfg
.profile
Sample file for .profile $gvsqw_SybBin/../etc/.profile:
Sample of lines to add to .profile of sybase users.
See the detailed help for .profile
.profile_confort
File to put aliases $gvsqw_SybBin/../etc/.profile_confort:
Contains confort aliases of SQWareProduction for RDBMS sybase.
See the detailed help for .profile_confort
lib
sqwsyb_CheckIndicators.lib
shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_CheckIndicators.lib:
lib for sqwora_CheckIndicators.ksh
See the detailed help for sqwsyb_CheckIndicators.lib
sqwsyb_CheckIndicators_Overload.lib
shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_CheckIndicators_Overload.lib:
template lib for overload sqwora_CheckIndicators.ksh
See the detailed help for sqwsyb_CheckIndicators_Overload.lib
sqwsyb_DumpDatabase.lib
shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_DumpDatabase.lib:
lib for sqwsyb_DumpDatabase.ksh
See the detailed help for sqwsyb_DumpDatabase.lib
sqwsyb_GatherIndicators.lib
shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_GatherIndicators.lib:
lib for sqwsyb_GatherIndicators.ksh
See the detailed help for sqwsyb_GatherIndicators.lib
sqwsyb_GenerateCreateDataserver.lib
shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_GenerateCreateDataserver.lib:
lib for generate create dataserver
See the detailed help for sqwsyb_GenerateCreateDataserver.lib
sqwsyb_Global.lib
shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_Global.lib:
central lib of generic fonctions for sybase
See the detailed help for sqwsyb_Global.lib
sqwsyb_InsertIndicators.lib
shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_InsertIndicators.lib:
generic fonctions to insert into referential
See the detailed help for sqwsyb_InsertIndicators.lib
sqwsyb_SetEnv.lib
shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_SetEnv.lib:
fonction to set env for $DSQUERY
See the detailed help for sqwsyb_SetEnv.lib
sqwsyb_UpdtStatsDatabase.lib
shell functions librairy $gvsqw_SybBin/../lib/sqwsyb_UpdtStatsDatabase.lib:
lib for sqwsyb_UpdtStatsDatabase.ksh
See the detailed help for sqwsyb_UpdtStatsDatabase.lib
tools
sqwsyb_GenerateCreateDataserver.ksh
Script $gvsqw_SybBin/../tools/sqwsyb_GenerateCreateDataserver.ksh:
Generate create dataserver files
See the detailed help for sqwsyb_GenerateCreateDataserver.ksh
sqwsyb_GetSaPass.ksh
Script $gvsqw_SybBin/../tools/sqwsyb_GetSaPass.ksh:
set env for $DSQUERY
See the detailed help for sqwsyb_GetSaPass.ksh
sqwsyb_SetEnv.ksh
Script $gvsqw_SybBin/../tools/sqwsyb_SetEnv.ksh:
set env for $DSQUERY
See the detailed help for sqwsyb_SetEnv.ksh
sqwsyb_Spm.ksh
Script $gvsqw_SybBin/../tools/sqwsyb_Spm.ksh:
request for sybase
See the detailed help for sqwsyb_Spm.ksh
help
Contains help files for -s option of bin scripts.
spm
SQL query toolkit
See the detailed help for spm