Before you back up or restore DB2 databases, use the Remote Agent Utility or the Remote Agent Utility command line to do 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
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.
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:
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. |
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. |
To configure database access for DB2 operations on Windows computers
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.
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:
|
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. |
Port number |
Type the port number to use for the operation requests that are sent to the media server. |
On the media server, add the following to the media server's list of authentication credentials:
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