Skip to main content
SnapCenter Software 6.0

Back up Db2 databases

Contributors netapp-soumikd netapp-nsriram
PDFs

Backing up a database includes establishing a connection with the SnapCenter Server, adding resources, adding a policy, creating a backup resource group, and backing up.

Before you begin

  • You must have created a backup policy.

  • If you want to back up a resource that has a SnapMirror relationship with a secondary storage, the ONTAP role assigned to the storage user should include the “snapmirror all” privilege. However, if you are using the “vsadmin” role, then the “snapmirror all” privilege is not required.

  • For Snapshot copy-based backup operation, ensure that all the tenant databases are valid and active.

  • For pre and post commands for quiesce, Snapshot, and unquiesce operations, you should check if the commands exist in the command list available on the plug-in host from the following paths:

    • Default location on the Windows host: C:\Program Files\NetApp\SnapCenter\Snapcenter Plug-in Creator\etc\allowed_commands.config

    • Default location on the Linux host: /opt/NetApp/snapcenter/scc/etc/allowed_commands.config

Note If the commands do not exist in the command list, then the operation will fail.
SnapCenter UI
Steps

  1. In the left navigation pane, select Resources, and then select the appropriate plug-in from the list.

  2. In the Resource page, filter resources from the View drop-down list based on resource type.

    Select filter icon, and then select the host name and the resource type to filter the resources. You can then select filter icon to close the filter pane.

  3. Select the resource that you want to back up.

  4. In the Resource page, select Use custom name format for Snapshot copy, and then enter a custom name format that you want to use for the Snapshot name.

    For example, customtext_policy_hostname or resource_hostname. By default, a timestamp is appended to the Snapshot name.

  5. In the Application Settings page, do the following:

    • Select the Backups arrow to set additional backup options:

      Enable consistency group backup, if needed, and perform the following tasks:

      For this field…​ Do this…​

      Afford time to wait for "Consistency Group Snapshot" operation to complete

      Select Urgent, or Medium, or Relaxed to specify the wait time for Snapshot operation to finish. Urgent = 5 seconds, Medium = 7 seconds, and Relaxed = 20 seconds.

      Disable WAFL Sync

      Select this to avoid forcing a WAFL consistency point.

    • Select the Scripts arrow to run pre and post commands for quiesce, Snapshot, and unquiesce operations.

      You can also run pre commands before exiting the backup operation. Prescripts and postscripts are run in the SnapCenter Server.

    • Select the Custom Configurationsarrow, and then enter the custom value pairs required for all jobs using this resource.

    • Select the Snapshot Copy Tool arrow to select the tool to create Snapshots:

      If you want…​ Then…​

      SnapCenter to create a storage-level Snapshot

      Select SnapCenter without File System Consistency.

      SnapCenter to use the plug-in for Windows to put the file system into a consistent state and then create a Snapshot

      Select SnapCenter with File System Consistency.

      To enter the command to create a Snapshot

      Select Other, and then enter the command to create a Snapshot.

      application settings

  6. In the Policies page, perform the following steps:

    1. Select one or more policies from the drop-down list.

      Note You can also create a policy by clicking add policy from resourcegroup.

      In the Configure schedules for selected policies section, the selected policies are listed.

    2. Select add policy from resourcegroup in the Configure Schedules column for the policy for which you want to configure a schedule.

    3. In the Add schedules for policy policy_name dialog box, configure the schedule, and then select OK.

      policy_name is the name of the policy that you selected.

      The configured schedules are listed in the Applied Schedules column.

  7. In the Notification page, from the Email preference drop-down list, select the scenarios in which you want to send the emails.

    You must also specify the sender and receiver email addresses, and the subject of the email. SMTP must also be configured in Settings > Global Settings.

  8. Review the summary, and then select Finish.

    The resources topology page is displayed.

  9. Select Back up Now.

  10. In the Backup page, perform the following steps:

    1. If you applied multiple policies to the resource, from the Policy drop-down list, select the policy that you want to use for backup.

      If the policy selected for the on-demand backup is associated with a backup schedule, the on-demand backups will be retained based on the retention settings specified for the schedule type.

    2. Select Backup.

  11. Monitor the operation progress by clicking Monitor > Jobs.

PowerShell cmdlets
Steps

  1. Initiate a connection session with the SnapCenter Server for a specified user by using the Open-SmConnection cmdlet.

    PS C:\> Open-SmConnection

    The username and password prompt is displayed.

  2. Add manual resources by using the Add-SmResources cmdlet.

    This example shows how to add a IBM Db2 instance:

    PS C:\> Add-SmResource -HostName 10.32.212.13 -PluginCode DB2 -ResourceType Instance -ResourceName db2inst1 -StorageFootPrint (@{"VolumeName"="windb201_data01";"LUNName"="windb201_data01";"StorageSystem"="scsnfssvm"}) -MountPoints "D:\"

    For Db2 Database:

    PS C:\> Add-SmResource -HostName 10.32.212.13 -PluginCode DB2 -ResourceType Database -ResourceName SALESDB -StorageFootPrint (@{"VolumeName"="windb201_data01";"LUNName"="windb201_data01";"StorageSystem"="scsnfssvm"}) -MountPoints "D:\" -Instance DB2

  3. Create a backup policy by using the Add-SmPolicy cmdlet.

  4. Protect the resource or add a new resource group to SnapCenter by using the Add-SmResourceGroup cmdlet.

  5. Initiate a new backup job by using the New-SmBackup cmdlet.

    This example shows how to backup a resource group:

    C:\PS> New-SMBackup -ResourceGroupName 'ResourceGroup_with_Db2_Resources' -Policy db2_policy1

    This example backs up a Db2 instance:

    C:\PS> New-SMBackup -Resources @{"Host"="10.32.212.13";"Uid"="DB2INST1";"PluginName"="DB2"} -Policy db2_policy

    This example backs up a Db2 database:

    C:\PS> New-SMBackup -Resources @{"Host"="10.32.212.13";"Uid"="DB2INST1\WINARCDB";"PluginName"="DB2"} -Policy db2_policy

  6. Monitor the job status (running, completed, or failed) by using the Get-smJobSummaryReport cmdlet.

    PS C:\> Get-SmJobSummaryReport -JobId 467

SmJobId            : 467
JobCreatedDateTime :
JobStartDateTime   : 27-Jun-24 01:40:09
JobEndDateTime     : 27-Jun-24 01:41:15
JobDuration        : 00:01:06.7013330
JobName            : Backup of Resource Group 'SCDB201WIN_RAVIR1_OPENLAB_NETAPP_LOCAL_DB2_DB2_WINCIR' with policy 'snapshot-based-db2'
JobDescription     :
Status             : Completed
IsScheduled        : False
JobError           :
JobType            : Backup
PolicyName         : db2_policy
JobResultData      :

  7. Monitor the backup job details like backup ID, backup name to perform restore or clone operation by using the Get-SmBackupReport cmdlet.

    PS C:\> Get-SmBackupReport -JobId 467

BackedUpObjects           : {WINCIR}
FailedObjects             : {}
IsScheduled               : False
HasMetadata               : False
SmBackupId                : 84
SmJobId                   : 467
StartDateTime             : 27-Jun-24 01:40:09
EndDateTime               : 27-Jun-24 01:41:15
Duration                  : 00:01:06.7013330
CreatedDateTime           : 27-Jun-24 18:39:45
Status                    : Completed
ProtectionGroupName       : HOSTFQDN_DB2_DB2_WINCIR
SmProtectionGroupId       : 23
PolicyName                : db2_policy
SmPolicyId                : 13
BackupName                : HOSTFQDN _DB2_DB2_WINCIR_HOST_06-27-2024_01.40.09.7397
VerificationStatus        : NotApplicable
VerificationStatuses      :
SmJobError                :
BackupType                : SCC_BACKUP
CatalogingStatus          : NotApplicable
CatalogingStatuses        :
ReportDataCreatedDateTime :
PluginCode                : SCC
PluginName                : DB2
PluginDisplayName         : IBM DB2
JobTypeId                 :
JobHost                   : HOSTFQDN

The information regarding the parameters that can be used with the cmdlet and their descriptions can be obtained by running Get-Help command_name. Alternatively, you can also refer to the SnapCenter Software Cmdlet Reference Guide.