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)
 
(2 intermediate revisions by the same user not shown)
Line 4: Line 4:
 
Functions explanation:
 
Functions explanation:
 
<pre>
 
<pre>
 +
gfsqw_BeginningCom
 
lfsqw_ActivateDB =>  
 
lfsqw_ActivateDB =>  
 +
lfsqw_BackupDatabase
 
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 20:
 
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_Main =>  
lfsqw_PosMaxFile=$grep -n "${lvsqw_DbName}_${lvsqw_MinDatePurge}_xxx" $gvsqw_TmpFile.bis|awk -F: '{print $1}' =>
+
lfsqw_PurgeHisto_$lvsqw_ToolType
 
lfsqw_PurgeHisto_DISK =>  
 
lfsqw_PurgeHisto_DISK =>  
 
lfsqw_PurgeHisto_TSM =>  
 
lfsqw_PurgeHisto_TSM =>  
 
lfsqw_PurgeHisto_XBSA =>  
 
lfsqw_PurgeHisto_XBSA =>  
 
lfsqw_SaveConfig =>  
 
lfsqw_SaveConfig =>  
 +
lfsqw_Summary
 +
lfsqw_Summary =>
 
</pre>
 
</pre>
 
<br>
 
<br>
 
{{SQWareProductionSurchargeLib|db2|D2db2|sqwdb2_BackupDatabase.lib}}
 
{{SQWareProductionSurchargeLib|db2|D2db2|sqwdb2_BackupDatabase.lib}}
 
<br>
 
<br>

Latest revision as of 18:20, 24 January 2023

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

gfsqw_BeginningCom
lfsqw_ActivateDB => 
lfsqw_BackupDatabase
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_Main => 
lfsqw_PurgeHisto_$lvsqw_ToolType
lfsqw_PurgeHisto_DISK => 
lfsqw_PurgeHisto_TSM => 
lfsqw_PurgeHisto_XBSA => 
lfsqw_SaveConfig => 
lfsqw_Summary
lfsqw_Summary => 


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 .