Enhancing Deduplication Performance
If you run Informix version 11.70.xC8 or 12.10.xC2 or higher, you can use the IFX_BAR_USE_DEDUP environment variable. This variable optimizes the deduplication capabilities of the storage manager and enables deduplication support on the Informix side.
Warning
You must run a full backup whenever you change the IFX_BAR_USE_DEDUP environment variable.
If you set the IFX_BAR_USE_DEDUP environment variable, do not perform incremental backups.
If you performed the backup with the IFX_BAR_USE_DEDUP environment variable set, you must have the variable set when you perform the restore.
You can set the IFX_BAR_USE_DEDUP environment variable in the onint environment, You must restart the server after you set the IFX_BAR_USE_DEDUP environment variable .
UNIX
export IFX_BAR_USE_DEDUP=1
Windows
set IFX_BAR_USE_DEDUP=1
Optimizing Log Backups
By default, each on-demand log backup will run a separate job per request. Each log backup job may take 10-15 seconds (for a log size that is less than or equal to 50 MB) to complete with at least one log file.
Use the sPerformanceModeOn additional setting to perform faster log backups. When you set sPerformanceModeOn to Y, the first on-demand log backup will complete within a regular time period (10-15 seconds). Subsequent log backups will take less time to run.
For information on how to configure log optimization, see Optimizing Log Backups.
Automatic Log Backups
You can use the automatic log backup feature when you do not want to monitor the logical log file and automatically start a backup job when the logical log file becomes full. Informix provides the alarmprogram script and log_full script, which are located in the $INFORMIXDIR/etc directory.
Copy and save the log_full.sh script file before you modify the file.
Add the following lines to the log_full.sh script file.
Set the parameters as:
|
Parameter |
Value |
|---|---|
|
N |
The number of full logical logs that you want to retain |
|
CvClientName |
The client that is configured in the CommCell Console |
|
CvInstanceName |
The name of the Informix instance that is configured in the CommCell Console |
################################ # Added the following to only backup logs # when there are N or more logs to be backed up. echo "$3" >> $INFORMIXDIR/Log_Cnt COUNT=`cat $INFORMIXDIR/Log_Cnt |wc -l` if [ $COUNT -ge N ] then export CvClientName= <client_name_as_seen_in_commcell_console> export CvInstanceName=<Instance00x> $BACKUP_CMD 2>&1 > /dev/null #Clear Log_Cnt after backing up logs... cat /dev/null > $INFORMIXDIR/Log_Cnt fi ################################
Example
To trigger the log backup after there are 5 or more full logical logs, set the parameters as:
|
Parameter |
Value |
|---|---|
|
N |
5 |
|
CvClientName |
informix_client |
|
CvInstanceName |
Instance001 |
################################
# Added the following to only backup logs
# when there are 5 or more logs to be backed up.
echo "$3" >> $INFORMIXDIR/Log_Cnt
COUNT=`cat $INFORMIXDIR/Log_Cnt |wc -l`
if [ $COUNT -ge 5 ]
then
export CvClientName= informix_client
export CvInstanceName=Instance001
$BACKUP_CMD 2>&1 > /dev/null
#Clear Log_Cnt after backing up logs...
cat /dev/null > $INFORMIXDIR/Log_Cnt
fi
################################
