Difference between revisions of "Template:SQWareProduction sqwdb2 GlobalVar.cfg explanation"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
 
Line 24: Line 24:
 
gvsqw_ReorgStat => for reorgchk CURRENT or UPDATE
 
gvsqw_ReorgStat => for reorgchk CURRENT or UPDATE
 
gvsqw_ReorgTypeTable => type of table to reorg USER ALL SYSTEM
 
gvsqw_ReorgTypeTable => type of table to reorg USER ALL SYSTEM
gvsqw_ReorgRunStatsOption => RUNSTAT option after reorg (Put off to desactivate)
+
gvsqw_ReorgRunStatsOption => RUNSTAT option after reorg (Put off to deactivate)
  
 
#for analyse scripts
 
#for analyse scripts

Latest revision as of 15:16, 26 April 2024


Variables explanation:

#General variables
gvsqw_SqwVersion => SQWare Production version
gvsqw_RootAdmin => admin directory
gvsqw_RootCfg => configuration directory
gvsqw_RootDbf => datafiles directory
gvsqw_NbThread => default number of thread for parallelism
gvsqw_Db2ErrorMsg => format of MySQL errors


#for Dump scripts
gvsqw_NbThreadBackup => default number of thread for parallelism for backup
gvsqw_RootBackup => default backup directory
#Put disable in gvsqw_TraceBackup if you don't want to trace backup execution in SQWareRepository
gvsqw_TraceBackup => to trace backup execution in SQWare repository
gvsqw_BackupRetention => backup retention in days
gvsqw_ToolCommand => Support backup 'USE TSM' 'TO DISK' 'USE XBSA'
gvsqw_Compress => for backup compression

#for reorg scripts
gvsqw_NbThreadReorganize => default number of thread for parallelism for reorg
gvsqw_ReorgStat => for reorgchk CURRENT or UPDATE
gvsqw_ReorgTypeTable => type of table to reorg USER ALL SYSTEM
gvsqw_ReorgRunStatsOption => RUNSTAT option after reorg (Put off to deactivate)

#for analyse scripts
gvsqw_NbThreadRunStats => default number of thread for parallelism for runStatistics
gvsqw_RunStatsOption => RUNSTAT option

##Globaly forcing return code for scripts
gvsqw_ForcedReturnCodeScript_sqwdb2_BackupDatabase => To force return code of sqwdb2_BackupDatabase.ksh

#PK for indicators, if DB2INSTANCE not unique
gvsqw_DbAlias => Database Alias