Configuring the DB2 Agent on Windows computers

Before you back up or restore DB2 databases, use the Remote Agent Utility or the Remote Agent Utility command line to do the following:

If you enable DB2-log archiving , you must configure additional information for the following:

The information that you configure for an instance applies to all of the databases that are contained in that instance.

Whenever DB2 instance information changes, you must update the Remote Agent Utility. If credential information is not updated or is incorrect, the error "Unable to attach to a resource..." may appear when you run a backup job.

To configure the DB2 Agent on Windows computers with the Remote Agent Utility

  1. On the computer on which the Remote Agent is installed, on the taskbar, click Start > All Programs > Symantec Backup Exec for Windows Servers > Backup Exec Remote Agent Utility.

    When the Remote Agent Utility is running, an icon appears in the system tray. You can double-click this icon to view the utility.

  2. Click the DB2 tab.

  3. Do one of the following:

    To add a DB2 instance

    • Click New.

    • Go to step 4.

    To change an existing DB2 instance

    • Select the instance that you want to edit.

    • Click Edit.

    • Go to step 4.

    To delete a DB2 instance

    • Select the instance that you want to delete, and then click Delete.

    • Go to step 5.

  4. Complete the appropriate options as follows:

    Local instance name

    To add an instance, enter the name of the DB2 instance. If you are editing an instance, you cannot change the instance name.

    User name

    Type the user name for the DB2 instance. The user name must have the following:

    • A valid authorization ID, or the CONNECT privilege to all the databases that reside in this DB2 instance.

    • The correct authority levels and privileges.

      Correct authority levels may include SYSADM, SYSCTRL, SYSMAINT, and DBADM.

      If the credentials are incorrect, the error "Unable to attach to a resource..." may appear when you run a backup job.

    If the credentials for the DB2 instance change, you must update the credentials in this field.

    You must add this computer name and logon account to the list of authentication credentials for DB2 servers.

    See Configuring database access on the media server for DB2 operations.

    Password

    Type the password for the DB2 instance user name.

    Confirm password

    Type the password again to confirm it.

    Media server

    Type the name or IP address of the Backup Exec media server where you want to process the operations.

    You must use the same form of name resolution for all operations. For example, if you use the IP address of this computer for backup operations, you must also use the IP address for restore operations. If you use the full computer name for backup operations, you must also use the full computer name for restore operations.

    Job template name

    Type the name of the Backup Exec job template that you want the DBA-initiated job to use for backup and restore operations. You create the job template on the DBA-initiated Job Settings dialog box on the Backup Exec media server. If you do not specify a job template, the default job template is used.

    For databases that have archive logging enabled, enter a separate archive logs template name in the Archive logs template name field.

    See Configuring DBA-initiated job settings for DB2.

    Archive logs template name

    Type the name of the Backup Exec archive logs job template that uses the user exit or VENDOR method. These methods are specified for a database on the DB2 Control Center or command line processor. If you use an incorrect job template name, then log files cannot be archived correctly.

    If you use the user exit or VENDOR method for a database, you must create a Backup Exec job template specifically for archiving logs. The archive logs job template should specify destination devices that are different than the devices that are specified in the job template for database backups.

    If the same device is used for both jobs, then the archive log backup must wait until the database backup completes. However, the database backup cannot complete until the archive log backup completes. If this situation occurs when the device is a backup-to-disk folder, increase the number of concurrent operations that are allowed on the backup-to-disk folder.

    See Configuring DBA-initiated job settings for DB2.

    See Using the DB2 database archive logging methods.

  5. Click OK.

To configure database access for DB2 operations on Windows computers

  1. On the computer on which the Remote Agent is installed, on the taskbar, click Start > All Programs > Symantec Backup Exec for Windows Servers > Backup Exec Remote Agent Utility.

    When the Remote Agent Utility is running, an icon appears in the system tray. You can double-click this icon to view the utility.

  2. Click the Database Access tab.

  3. Complete the appropriate options as follows:

    Enable media server authentication for Oracle and DB2 operations

    Check Enable media server authentication for Oracle and DB2 operations to enter the credentials for the media server to use for all operations on the DB2 server, including DBA-initiated operations. The media server also uses these credentials for authentication of the DB2 server.

    You must check this option to enable DB2 operations between the media server and this computer.

    User name

    Type a user name that has administrative rights to this computer. This logon account is what the media server uses when it connects to this computer.

    If you specify an IP address or a fully qualified computer name as part of the user name, the Remote Agent Utility may not be able to verify the user account. If the credentials are incorrect, the error "Unable to attach to a resource..." may appear when you run a backup or restore job.

    You must add this computer name and logon account to the list of authentication credentials for DB2 servers.

    See Configuring database access on the media server for DB2 operations.

    If the authentication fails when the DB2 resources are backed up, the backup job fails. If the authentication fails when you browse the backup sets for a restore job, then the backup sets become unavailable, and you must run a DBA-initiated restore job to restore data.

    Password

    Type the password for this logon account, and then confirm it.

    For security reasons, the logon credentials are not stored on the remote computer.

    Use the full computer name or IP address for Oracle and DB2 operations

    Check Use the full computer name or IP address for Oracle and DB2 operations to use either the full computer name or IP address for operations between the remote computer and the media server. You must use the same form of name resolution for all DB2 operations.

    For example, if you use the IP address of this computer for backup operations, you must also use the IP address for restore operations. If you use the full computer name for backup operations, you must also use the full computer name for restore operations.

    Name or IP address

    Type the full computer name or IP address for this computer.For full computer names, the following rules apply:

    • The maximum number of characters for each label (the text between the dots) is 63

    • The maximum total number of characters is 254, including the dots, but excluding the \\

    • The name cannot include the following characters: * | < > ?

    Use a custom port to connect to the media server during Oracle and DB2 operations

    Check Use a custom port to connect to the media server during Oracle and DB2 operations to change the port that is used for communications between this computer and the media server during DB2 operations. By default, port 5633 is used.

    If you change the port number on this computer, you must also change it on the media server. Then, restart the Backup Exec Job Engine Service on the media server.

    See Setting default backup network and security options.

    Port number

    Type the port number to use for the operation requests that are sent to the media server.

  4. Click OK.

  5. On the media server, add the following to the media server's list of authentication credentials:

    • Name of the DB2 server

    • The user name that you entered on the Database Access tab

More Information

The Remote Agent Utility for Windows Systems

About the Remote Agent Utility Command Line Applet

Configuring database access on the media server for DB2 operations

Using the DB2 database archive logging methods

Backing up DB2 resources

Configuring DBA-initiated job settings for DB2

Setting application defaults for DB2