Difference between revisions of "SQWareProduction:db2:lib:sqwdb2 BackupDatabase.lib"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
 
m (Updated by BatchUser)
Line 7: Line 7:
 
lfsqw_BackupDatabase =>  
 
lfsqw_BackupDatabase =>  
 
lfsqw_CheckReturn =>  
 
lfsqw_CheckReturn =>  
lfsqw_CheckReturn "db2 ACTIVATE DB ${lvsqw_DbName}"
+
lfsqw_CheckReturn "db2 ACTIVATE DB ${lvsqw_InstanceParam}"
 
lfsqw_CheckReturn "db2 CONNECT RESET"
 
lfsqw_CheckReturn "db2 CONNECT RESET"
lfsqw_CheckReturn "db2 connect to ${lvsqw_DbName}"
+
lfsqw_CheckReturn "db2 connect to ${lvsqw_InstanceParam}"
lfsqw_CheckReturn "db2 connect to ${lvsqw_DbName} for activate => "
+
lfsqw_CheckReturn "db2 connect to ${lvsqw_InstanceParam} for activate => "
lfsqw_CheckReturn "db2 connect to ${lvsqw_DbName} for desactivate => "
+
lfsqw_CheckReturn "db2 connect to ${lvsqw_InstanceParam} for desactivate => "
 
lfsqw_CheckReturn "db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS"
 
lfsqw_CheckReturn "db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS"
 
lfsqw_CheckReturn "db2 UNQUIESCE DATABASE"
 
lfsqw_CheckReturn "db2 UNQUIESCE DATABASE"
Line 18: Line 18:
 
lfsqw_DeactivateDB =>  
 
lfsqw_DeactivateDB =>  
 
lfsqw_InsertMonitoringBackup =>  
 
lfsqw_InsertMonitoringBackup =>  
lfsqw_PosMaxFile=$grep -n "${lvsqw_DbName}_[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]_full_" $gvsqw_TmpFile|tail -1|awk -F: '{print $1}' =>  
+
lfsqw_PosMaxFile=$grep -n "${lvsqw_InstanceParam}_[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]_full_" $gvsqw_TmpFile|tail -1|awk -F: '{print $1}' =>  
lfsqw_PosMaxFile=$grep -n "${lvsqw_DbName}_${lvsqw_MinDatePurge}_xxx" $gvsqw_TmpFile.bis|awk -F: '{print $1}' =>  
+
lfsqw_PosMaxFile=$grep -n "${lvsqw_InstanceParam}_${lvsqw_MinDatePurge}_xxx" $gvsqw_TmpFile.bis|awk -F: '{print $1}' =>  
 
lfsqw_PurgeHisto_DISK =>  
 
lfsqw_PurgeHisto_DISK =>  
 
lfsqw_PurgeHisto_TSM =>  
 
lfsqw_PurgeHisto_TSM =>  

Revision as of 18:33, 5 April 2014

shell functions library $gvsqw_D2db2Bin/../lib/sqwdb2_BackupDatabase.lib:
lib for sqwdb2_BackupDatabase.ksh
Functions explanation:

lfsqw_ActivateDB => 
lfsqw_BackupDatabase => 
lfsqw_CheckReturn => 
lfsqw_CheckReturn "db2 ACTIVATE DB ${lvsqw_InstanceParam}"
lfsqw_CheckReturn "db2 CONNECT RESET"
lfsqw_CheckReturn "db2 connect to ${lvsqw_InstanceParam}"
lfsqw_CheckReturn "db2 connect to ${lvsqw_InstanceParam} for activate => "
lfsqw_CheckReturn "db2 connect to ${lvsqw_InstanceParam} for desactivate => "
lfsqw_CheckReturn "db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS"
lfsqw_CheckReturn "db2 UNQUIESCE DATABASE"
lfsqw_CommandFormat
lfsqw_CommandFormat => 
lfsqw_DeactivateDB => 
lfsqw_InsertMonitoringBackup => 
lfsqw_PosMaxFile=$grep -n "${lvsqw_InstanceParam}_[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]_full_" $gvsqw_TmpFile|tail -1|awk -F: '{print $1}' => 
lfsqw_PosMaxFile=$grep -n "${lvsqw_InstanceParam}_${lvsqw_MinDatePurge}_xxx" $gvsqw_TmpFile.bis|awk -F: '{print $1}' => 
lfsqw_PurgeHisto_DISK => 
lfsqw_PurgeHisto_TSM => 
lfsqw_PurgeHisto_XBSA => 
lfsqw_SaveConfig => 


Nuvola apps information.png
Note:
You can overload functions contained in $gvsqw_D2db2Bin/../lib/sqwdb2_BackupDatabase.lib

by function with same name in $gvsqw_D2db2Bin/../lib_cust/sqwdb2_BackupDatabase.lib for all your environnement
or by $HOME/sqwConfig/sqwdb2_BackupDatabase.lib specifically for this user .