Creating a db2.conf file for use with the user exit program

The NetBackup for DB2 configuration file, db2.conf, consists of a series of keywords and values. This file defines how to back up the database and the archive logs. It must be created on each NetBackup for DB2 client.

The installation package installed a file named db2.conf that you can customize. The following procedures show you how to customize this file. Follow the instructions in this section if you use the user exit program to perform backups.

To create a db2.conf file for use with the user exit program

Before you create the db2.conf file, you need to create the policies to back up the archive logs and the configuration files.
Log on to a client computer.
Copy the sample db2.conf file from its location in the sample directory to its active location.
Its location in the sample directory is as follows:
Windows: install_path\NetBackup\dbext\db2\samples
UNIX: /usr/openv/netbackup/ext/db_ext/db2/scripts
The active location for the db2.conf file is as follows:
Windows: install_path\NetBackup\dbext\db2\db2.conf
UNIX: $DB2_Instance_Home/db2.conf
In the db2.conf file, create an object identifier for backing up the database.
This object identifier starts with the following keyword lines:
```
DATABASE SAMPLE
OBJECTTYPE DATABASE
...
```
In the db2.conf file, create an object identifier for backing up the archive logs.
The form depends on how the archive logs are backed up, as follows:
- If you use ARCFUNC SAVE:
```
DATABASE SAMPLE
OBJECTTYPE ARCHIVE
```
```
POLICY WIN_TYPE_POL_LOGPOL # an MS-Windows-NT type policy
```
```
POLICY STD_TYPE_POL_LOGPOL # a standard UNIX type policy
```
```
SCHEDULE USER_BACKUP_SCHED_LOGSCHED
```
  In the POLICY line, specify the name of the MS- Windows or Standard policy for backing up the archive logs.
  In the SCHEDULE line, specify the User Backup schedule that you created earlier for backing up the archive logs.
- If you use ARCFUNC COPY:
```
DATABASE SAMPLE
OBJECTTYPE ARCHIVE
```
```
Windows: ARCDIR C:\MyLogs\arcdir\
RETDIR C:\MyLogs\arcdir\
```
```
UNIX: ARCDIR /home/db2inst1/arcdir
RETDIR /home/db2inst1/arcdir
```
  In the ARCDIR line, specify the full path to the location of the archive logs.
  In the RETDIR line, specify the full path to the location from which the archive logs are retrieved. Typically, the RETDIR location is the same as the ARCDIR location.
You may need to add other entries to the db2.conf file.
Save and close the db2.conf file.
Repeat this procedure on each client computer.

More Information

Configuring a policy to back up the archive logs

Configuring a policy to archive the archive logs

Configuring a policy to back up the configuration files

Example db2.conf file using ARCFUNC SAVE

Example db2.conf file using ARCFUNC COPY

Keywords for the db2.conf file

NetBackup for DB2 backup types

About backing up archive log files with the user exit program

Creating a db2.conf file (vendor method)

Configuring the logon account for the NetBackup Client Service for NetBackup for DB2

Creating a db2.conf file for use with the user exit program

Feedback

Feedback