SAP on DB2

Table of Contents

Overview

Pre-requisites

SAP DB13 Workflow

How to perform SAP on DB2 backup

Configure the DB2 iDataAgent

Initiate Backup from DB13

View Job Details

Overview

There are few organizations that use the SAP application with DB2 databases to manage their business operations. In such environments, in order to provide an effective data management strategy, the SAP Internal Planner (DB13) interacts with the DB2 iDataAgent to ensure secured data protection of SAP applications on DB2 databases.

Pre-Requisites

Make sure that your DB2 version is supported by the DB2 iDataAgent. Refer the System Requirements to know the compatibility of your DB2 version.

SAP DB13 Workflow

Make sure to install and configure the DB2 iDataAgent before performing backup operations of SAP on DB2 databases. Once you have configured the DB2 iDataAgent from the CommCell Console, you can now initiate the backup operation from the DB13 interface.

DB13 is the SAP internal task planner that allows you to plan tasks, such as database reorganization jobs, backup operations, CLP (Command Line processor) script executions, etc. The DB13 uses the vendor library to initiate/schedule the backup operation with the DB2 iDataAgent.

The diagram on the right describes the basic workflow of a DB13 initiated SAP/DB2 backup operation:

The vendor library is the DB2 interface (API) called libDb2Sbt.so which is located in the DB2 iDataAgent's <software installation path>/Base64 directory on an IBM AIX 64-bit computer. The DB13 will call the shared object from the local DB2 lib directory which points to the DB2 idataAgent's installation path via symbolic link.

As soon as backup job is initiated, DB13 will create a dmdb6bkp (SAP binary) command based on the options selected above. For detailed information on the dmdb6bkp command, refer dmdb6bkp - Database Backup Tool under SAP Tools section in SAP on IBM DB2 for Linux, UNIX, and Windows Database Administration Guide.

Example:

dmdb6bkp BACKUP DATABASE DW1 ON DBPARTITIONNUM ( 0 ) ONLINE LOAD “/db2/db2dw1/db2_software/lib64/libDb2Sbt.so” OPEN 1 SESSIONS COMPRESS INCLUDE LOGS

The dmdb6bkp command will in turn call the db2 backup command.

Example:

db2 backup database DW1 online load “/db2/db2dw1/db2_software/lib64/libDb2Sbt.so” open 1 sessions compress include logs

How to Perform SAP on DB2 backup

In order to perform a SAP on DB2 backup from the DB13 interface using our DB2 iDataAgent, do the following:

Configure the DB2 iDataAgent

The following configurations are performed from the CommCell Console:

  1. From the CommCell Browse, create the instance and backupset for the DB2 iDataAgent.

    For example, in the diagram

    Instance - db2dw1

    Backupset - DW1

  2. Configure the DB2 Instance as shown in the diagram.

  3. Specify the storage policy for command line backup.

  4. Specify the Storage Policy for all Log File backups in the backupset properties.

  5. Configure the subclient.

    The diagram shows the subclient configuration for an online full backup will logs.

Initiate Backup from DB13

In order to initiate a backup, provide the following details:

DB13 does not allow scheduling archive log backups. It requires at least a block level database incremental backup which will include the logs after the database incremental has completed. Logs only backups are not possible via DB13.

After initiating the backup job, you can view the status of the backup job from the DB13 interface as well as from the CommCell Console.

Viewing Job Details

In addition to job status, you can also view the details of the backup job from the CommCell Console. To view the job details, right click the job in the job controller window and select Details. You can also view the progress and number of streams used by the  backup job from the Job Details window.

Once the job has completed successfully, it will be highlighted in green in the SAP DBA Planning Calendar.

 

Back to Top