About using DB2 to run DBA-initiated jobs

Backup Exec supports DBA-initiated backup, restore, redirected restore, and recovery of DB2 databases. When you run a DBA-initiated DB2 job, you configure and start the job by using DB2 – not Backup Exec. After the DBA-initiated job starts, you can monitor the job by using Backup Exec. All DBA-initiated jobs appear in the Backup Exec Job Monitor tab.

The following table describes the files that are installed on the Backup Exec media server during the DB2 Agent installation:

Table: Files that are installed on the media server with the DB2 Agent

File

Description

The vendor dll file db2sqluv.dll and the user exit program db2uext2.exe

Installed in the Windows System Directory. The Windows System Directory may have a pathname such as:

C:\winnt\system32 or D:\windows\system32.

You can use a vendor library or a user exit program from the DB2 Control Center as a method for archiving log files. However, doing so causes db2sqluv.dll and db2uext2.exe to be used by default.

See About using the DB2 database archive logging methods.

A configuration file named db2.conf

Includes specifications for redirected restore jobs and roll forward operations. The Backup Exec vendor dll file and user exit program use the information in this file.

The db2.conf file is installed to the following location on the media server:

\Program Files\Symantec\Backup Exec\db2.conf

The db2.conf file is installed to the following location on the remote DB2 server:

\Program Files\Symantec\Backup Exec\RAWS\db2.conf

See About the db2.conf file.

Example scripts for backup and restore operations

Available for you to run at the DB2 command-line processor.

These scripts are installed to the following location:

\Program Files\Symantec\Backup Exec\scripts\DB2

Review the following notes before you run DBA-initiated jobs for DB2:

  • Complete all of the preparations for installing and configuring the DB2 Agent.

    See Requirements for the DB2 Agent.

  • If you use a domain administrator logon account to browse DB2 databases on a DB2 server, you may not be able to expand or select databases for operations from Backup Exec. If this situation occurs, add the domain administrator account to the DB2ADMNS group.

  • On the media server, the logon account that you use to back up the DB2 resources should have backup operator or administrator rights.

  • With DBA-initiated jobs in a CASO environment, the destination device that you select in the DBA-initiated job template must be locally attached to the central administration server. This includes DBA-initiated DB2 archive log jobs.

    If the destination device includes a device pool, all devices in the pool must be locally attached to the central administration server.

More Information

Troubleshooting DB2

About using the DB2 database archive logging methods

About using DB2 to run DBA-initiated jobs