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

From Wiki_dbSQWare
Jump to navigation Jump to search
Newer edit →
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 =>


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 .


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:db2:lib:sqwdb2_BackupDatabase.lib&oldid=4066"