CA Technologies IBM R12.5 User Manual
CA ARCserve® Backup for
Windows
Agent for IBM Informix Guide
r12.5
This documentation and any related computer software help programs (hereinafter referred to as the
“Documentation”) is for the end user’s informational purposes only and is subject to change or withdrawal by CA at
any time.
This Documentation may not be copied, transferred, reproduced, disclosed, modified or duplicated, in whole or in
part, without the prior written consent of CA. This Documentation is confidential and proprietary information of CA
and protected by the copyright laws of the United States and international treaties.
Notwithstanding the foregoing, licensed users may print a reasonable number of copies of the Documentation for
their own internal use, and may make one copy of the related software as reasonably required for back-up and
disaster recovery purposes, provided that all CA copyright notices and legends are affixed to each reproduced copy.
Only authorized employees, consultants, or agents of the user who are bound by the provisions of the license for
the Product are permitted to have access to such copies.
The right to print copies of the Documentation and to make a copy of the related software is limited to the period
during which the applicable license for the Product remains in full force and effect. Should the license terminate for
any reason, it shall be the user’s responsibility to certify in writing to CA that all copies and partial copies of the
Documentation have been returned to CA or destroyed.
EXCEPT AS OTHERWISE STATED IN THE APPLICABLE LICENSE AGREEMENT, TO THE EXTENT PERMITTED BY
APPLICABLE LAW, CA PROVIDES THIS DOCUMENTATION “AS IS” WITHOUT WARRANTY OF ANY KIND, INCLUDING
WITHOUT LIMITATION, ANY IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE
OR NONINFRINGEMENT. IN NO EVENT WILL CA BE LIABLE TO THE END USER OR ANY THIRD PARTY FOR ANY
LOSS OR DAMAGE, DIRECT OR INDIRECT, FROM THE USE OF THIS DOCUMENTATION, INCLUDING WITHOUT
LIMITATION, LOST PROFITS, BUSINESS INTERRUPTION, GOODWILL, OR LOST DATA, EVEN IF CA IS EXPRESSLY
ADVISED OF SUCH LOSS OR DAMAGE.
The use of any product referenced in the Documentation is governed by the end user’s applicable license
agreement.
The manufacturer of this Documentation is CA.
Provided with “Restricted Rights.” Use, duplication or disclosure by the United States Government is subject to the
restrictions set forth in FAR Sections 12.212, 52.227-14, and 52.227-19(c)(1) - (2) and DFARS Section 252.2277014(b)(3), as applicable, or their successors.
All trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.
Copyright © 2009 CA. All rights reserved.
CA Product References
This documentation set references the following CA products:
■
BrightStor® ARCserve® Backup for Laptops and Desktops
■
BrightStor® CA-Dynam®/TLMS Tape Management
■
BrightStor® CA-Vtape™ Virtual Tape System
■
BrightStor® Enterprise Backup
■
BrightStor® High Availability
■
BrightStor® Storage Resource Manager
■
CA Antivirus
■
CA ARCserve® Backup Agent for Advantage™ Ingres®
■
CA ARCserve® Backup Agent for Novell Open Enterprise Server for Linux
■
CA ARCserve® Backup Agent for Open Files on NetWare
■
CA ARCserve® Backup Agent for Open Files on Windows
■
CA ARCserve® Backup Client Agent for FreeBSD
■
CA ARCserve® Backup Client Agent for Linux
■
CA ARCserve® Backup Client Agent for Mainframe Linux
■
CA ARCserve® Backup Client Agent for NetWare
■
CA ARCserve® Backup Client Agent for UNIX
■
CA ARCserve® Backup Client Agent for Windows
■
CA ARCserve® Backup Enterprise Option for AS/400
■
CA ARCserve
■
CA ARCserve
■
CA ARCserve® Backup for Windows
■
CA ARCserve® Backup for Windows Agent for IBM Informix
■
CA ARCserve® Backup for Windows Agent for Lotus Domino
■
CA ARCserve® Backup for Windows Agent for Microsoft Exchange
■
CA ARCserve® Backup for Windows Agent for Microsoft SharePoint
■
CA ARCserve® Backup for Windows Agent for Microsoft SQL Server
■
CA ARCserve® Backup for Windows Agent for Oracle
■
CA ARCserve® Backup for Windows Agent for Sybase
■
CA ARCserve® Backup for Windows Agent for Virtual Machines
®
Backup Enterprise Option for Open VMS
®
Backup for Microsoft Windows Essential Business Server
■
CA ARCserve® Backup for Windows Disaster Recovery Option
■
CA ARCserve® Backup for Windows Disk to Disk to Tape Option
■
CA ARCserve® Backup for Windows Enterprise Module
■
CA ARCserve® Backup for Windows Enterprise Option for IBM 3494
■
CA ARCserve® Backup for Windows Enterprise Option for SAP R/3 for
Oracle
■
CA ARCserve
ACSLS
■
CA ARCserve® Backup for Windows Image Option
■
CA ARCserve® Backup for Windows Microsoft Volume Shadow Copy
®
Backup for Windows Enterprise Option for StorageTek
Service
■
CA ARCserve
■
CA ARCserve® Backup for Windows Serverless Backup Option
■
CA ARCserve® Backup for Windows Storage Area Network (SAN) Option
■
CA ARCserve® Backup for Windows Tape Library Option
■
CA Dynam®/B Backup for z/VM
■
CA VM:Tape for z/VM
■
CA XOsoft™ Assured Recovery™
®
Backup for Windows NDMP NAS Option
■
CA XOsoft™
■
CA 1® Tape Management
■
Common Services™
■
eTrust® Firewall
■
Unicenter® Network and Systems Management
■
Unicenter® Software Delivery
■
Unicenter® VM:Operator®
Contact CA
Contact Technical Support
For your convenience, CA provides one site where you can access the
information you need for your Home Office, Small Business, and Enterprise CA
products. At http://ca.com/support
■
Online and telephone contact information for technical assistance and
customer services
■
Information about user communities and forums
■
Product and documentation downloads
■
CA Support policies and guidelines
■
Other helpful resources appropriate for your product
Provide Feedback
If you have comments or questions about CA product documentation, you can
send a message to techpubs@ca.com.
If you would like to provide feedback about CA product documentation,
complete our short customer survey, which is also available on the CA support
website, found at http://ca.com/support
, you can access the following:
.
Contents
Chapter 1: Introducing the Agent for IBM Informix 9
How the Agent for IBM Informix Works .......................................................... 9
Remote Procedure Call Service ............................................................ 10
Agent Parameters ......................................................................... 10
Full Offline Backups ....................................................................... 11
Access Control Lists ....................................................................... 11
Chapter 2: Installing the Agent for IBM Informix 13
Installation Prerequisites ...................................................................... 13
Preinstallation Tasks .......................................................................... 14
Modify the Windows Environment for ISM Systems on IDS Versions .......................... 14
Install the Agent for IBM Informix ............................................................. 15
Post-Installation Tasks ........................................................................ 15
Set the IDS ONCONFIG File ................................................................ 16
Communication with ON-Bar ............................................................... 17
Prepare the Agent for Operation ........................................................... 18
Uninstall the Agent ........................................................................... 18
Chapter 3: Using the Agent 19
Recommendations for Backing Up IDS Database ................................................ 19
Back Up an IDS Database ..................................................................... 20
Unsupported Backup Functions ................................................................ 26
Recommendations for Restoring an IDS Database .............................................. 27
Restore an IDS Database ..................................................................... 28
Media Rotation Precautions .................................................................... 31
Unsupported Restore Functions ................................................................ 31
Perform Disaster Recovery .................................................................... 32
Verify IDS Status ............................................................................. 33
Appendix A: Troubleshooting 35
Help on Incomplete Job Information ........................................................... 35
Enable Debug Mode ........................................................................... 36
Verify the Backup File Location ................................................................ 36
Problems and Solutions ....................................................................... 37
A backup job was reported as successful but nothing happens ............................... 37
Contents 7
Cannot find the Backup Agent home subdirectory \TAPEINFO from the CA ARCserve
Backup Restore Manager Tree View ........................................................ 37
A restore job from CA ARCserve Backup failed but BAR_<INFORMIX SERVER>.LOG on the
Informix Server indicated it as successful ................................................... 38
A rescheduled backup or restore job stops responding ....................................... 38
A job from the Informix Backup or Restore Utility is in the job queue, but nothing is
happening ................................................................................ 39
During an Informix restore, CA ARCserve Backup prompts for media that no longer exists ..... 39
A backup and restore job is submitted from the ON-Bar utility of Informix, but nothing
happens .................................................................................. 40
A backup job is submitted, but the job has stopped running ................................. 40
Error Messages ............................................................................... 40
Index 53
8 Agent for IBM Informix Guide
Chapter 1: Introducing the Agent for IBM
Informix
CA ARCserve Backup is a comprehensive, distributed storage solution for
applications, databases, distributed servers, and file systems. It provides
backup and restore capabilities for databases, business-critical applications,
and network clients.
The CA ARCserve Backup Agent for IBM Informix provides backup and restore
capabilities for the IBM Informix Dynamic Server (IDS). The types of data that
can be backed up include both critical and non-critical dbspaces (primarily
chunks, or specific regions of disk space); blobspaces (binary large object
spaces); and logical logs (transaction records).
This section contains the following topics:
How the
Agent for IBM Informix Works (see page 9)
How the Agent for IBM Informix Works
The Agent for IBM Informix works with ON-Bar, which is the backup and
recovery utility for IDS. The primary job of the agent is to issue requests for
the Informix ON-Bar utility on behalf of the Informix Manager. Options set
through the Backup Manager interface are translated into the ON-Bar
command line options, to provide an integrated environment. You can also
work from the ON-Bar command line to submit jobs directly to the Backup
Manager.
The agent connects CA ARCserve Backup and IDS by communicating between
the two applications, enabling data to be passed back and forth. The agent
resides on the same system as IDS.
To backup a database, the CA ARCserve Backup Manager converts user entries
into one or more requests, and sends the requests to the agent on the IDS
system. The agent communicates this request to ON-Bar, which executes
backup and restore requests for IDS. The agent retrieves the specified data
objects from IDS and sends them to the Backup Manager, which copies the
data to your storage media.
You can manage the backup and restore operations better with the following
options.
Chapter 1: Introducing the Agent for IBM Informix 9
How the Agent for IBM Informix Works
Remote Procedure Call Service
With Remote Procedure Call (RPC) enabled, the agent operates as a Windows
service and can be configured to start automatically through standard
Windows setup or through the Services feature of the Control Panel. This
configuration lets you run the agent without logging in.
Agent Parameters
You can customize the agent by modifying settings in the Windows registry,
using the Windows REGEDT32 utility. Agent settings are listed in the
HKEY_LOCAL_MACHINE window under the following key:
SOFTWARE\ComputerAssociates\CA ARCserve Backup\DSAgent\Current
Version\agent\dbaifmx@ServerName
In this example, ServerName identifies the IDS instance name.
The following optional settings are provided for the agent under the dbaifmx
key:
CriticalFileBackupDelay
Specifies the current delay, in minutes, to back up critical IDS files located
in the Informix\etc directory.
dll
Specifies the location of the agent files.
debug
Enables debug trace files for the agent. The default value is 0 (FALSE).
You should enable this setting (change the default) only when requested to
do so by CA Customer Support.
Note: The agent includes Activity Logs that provide information about
backup or restore jobs and their status. These logs are located in the
agent home directory, and are named dbaifmx.log, dbabatch.log, and
xbsa.log. The home directory may also contain files called trace logs,
which are created and updated only when debug is enabled. These logs
are called dbaifmx.trc, dbabatch.trc, and xbsa.trc. If required during a
debug session, you may be asked to check these Job Logs to help
determine the cause of the problem.
10 Agent for IBM Informix Guide
Full Offline Backups
You should keep at least one recent offline backup of your IDS databases.
When performing a full offline backup, you must select the appropriate
directories (in particular, the Informix home directory and Informix data files)
from the Backup Manager window.
Access Control Lists
Access Control Lists (ACLs) let you to specify the CA ARCserve Backup servers
permitted to back up the IDS database.
In a Windows environment, you can create and edit Informix ACLs from the
CA\Agent Admin navigation tab.
For more information about ACLs, see the Client Agents Guide or Online Help.
How the Agent for IBM Informix Works
Chapter 1: Introducing the Agent for IBM Informix 11
Chapter 2: Installing the Agent for IBM
Informix
This chapter describes how you can install and configure the Agent for IBM
Informix. The chapter also explains the post-installation tasks you must
perform before performing the first backup and restore operation.
This section contains the following topics:
Installation Prerequisites
Preinstallation Tasks
Install the
Post-Installation Tasks
Uninstall the Agent
Agent for IBM Informix (see page 15)
Installation Prerequisites
Before installing the CA ARCserve Backup Agent for IBM Informix, verify the
following:
■
Your system meets the software requirements needed to install the Agent
for IBM Informix. For a list of requirements, see the readme file.
■
You have installed CA ARCserve Backup and it works properly.
Note: You can install the Agent for IBM Informix on the same computer as
CA ARCserve Backup (the local computer) or on a separate computer (a
remote computer).
■
You have installed IBM Informix-Connect and it works properly.
■
You have installed Informix Storage Manager (ISM).
Note: ISM is an optional component in IBM Informix.
■
You have administrator privileges or any other equal privileges to install
software on the computers where you will be installing the product.
(see page 13)
(see page 14)
(see page 15)
(see page 18)
Note: Contact your administrator to obtain the proper rights if you do not
have them.
■
You know the installation path. (You may use the default installation path.)
■
You have completed the modifications to the Windows environment as
described in Preinstallation Tasks
(see page 14).
Chapter 2: Installing the Agent for IBM Informix 13
Preinstallation Tasks
Preinstallation Tasks
Before installing the agent on computers running IDS, modify the Windows
Modify the Windows Environment for ISM Systems on IDS Versions
environment as described in the following sections.
You must modify the Windows environment for computers running Informix
Storage Manager (ISM) with IDS Versions 9.40, 10.0, and 11.10.
To modify the Windows environment
1. Select System in the Control Panel.
The System Properties dialog opens.
2. Select the Advanced tab, and click Environment Variables.
3. Modify the Path variable to include the location of the ISM directory path,
as shown in the following sample:
C:\ism\ver#\bin
4. Click OK.
5. Click OK to close the Environment Variables dialog.
Note: The remaining steps are performed when you install the agent. If
this procedure is skipped, perform the following steps.
6. Locate the sm_versions.std file
Note: The sm_versions.std file is a template for setting up the
sm_versions file with information about the Storage Manager.
For more information about the sm_versions file, see the Informix user
documentation.
7. Rename the existing sm_versions file to exclude the extension .std, as
defined in your IDS release notes and as shown in the following example:
Informixdir\etc\sm_versions.std
to:
Informixdir\etc\sm_versions
8. Open the sm_versions file using Notepad to make sure it contains the
following string:
1|1.0.1|ism|1|
If the string is not present, add it at the end of the file and save the file.
9. Close the file.
14 Agent for IBM Informix Guide
Install the Agent for IBM Informix
The Agent for IBM Informix follows the standard installation procedure for CA
ARCserve Backup system components, agents, and options.
For detailed procedures about how to install CA ARCserve Backup, see the
Implementation Guide.
Note: After you complete the installation procedure, restart your computer
when prompted.
Post-Installation Tasks
After you install the agent, you must complete some tasks before you can
begin operating CA ARCserve Backup with the agent. These procedures are
described in the following sections.
Install the Agent for IBM Informix
Chapter 2: Installing the Agent for IBM Informix 15
Post-Installation Tasks
Set the IDS ONCONFIG File
The installation program updates the ONCONFIG file in the IBM Informixdir\etc
directory so that the agent can operate properly.
Note: If you do not update the ONCONFIG file during installation, you must
use a text editor to manually enter the changes in the ONCONFIG file before
you install and deploy the agent in your network.
Skip this procedure if you modified the ONCONFIG file during installation.
To manually modify the ONCONFIG file
1. Open the ONCONFIG file using Notepad or any text editor.
2. For IDS Versions 9.40, 10.0, and 11.10, insert the following lines in the
ONCONFIG file:
BAR_MAX_BACKUP 1 # Informix Backup Agent
BAR_BSALIB_PATH AGENT_HOME\libbsa.dll #Informix Backup Agent XBSA DLL
where AGENT_HOME is the home directory path of the agent.
Important! For IDS Versions 9.40, 10.0 and 11.10, if your agent home
directory path contains space characters (for example, C:\Program
Files\Informix), you must enter the MS-DOS shortened name when you
specify the path (for example, C:\progra~1\ Informix). To determine the
shortened form of a path name, view the path in an MS DOS command
prompt window.
3. For IDS Versions 9.40, 10.0 and 11.10, replace the following line:
LTAPEDEV NULL #Log tape device_path
with this line:
LTAPEDEV \\.\TAPE1 #Log tape device_path
4. Save the file.
5. Stop and restart all IDS instances to apply the changes to the ONCONFIG
file.
Note: An IDS instance means the concurrent operation of shared memory,
processors, databases, and physical devices allocated to IDS, all of which
can be monitored by the ONSTAT -p (profile) command.
16 Agent for IBM Informix Guide
Communication with ON-Bar
CA ARCserve Backup lets you configure batch jobs. Using CA ARCserve
Backup, you can configure one IDS instance at a time. You can use the
Informix Agent Batch Job Configuration dialog to submit backup and restore
jobs using the ON-Bar command line on the IDS. However, if the agent server
is hosting multiple instances of IDS, you must reconfigure the batch job
configuration for each backup or restore job submitted through the ON-Bar
command line.
Note: If you use CA ARCserve Backup and Restore Managers tools as your
methods for initiating backup or restore jobs, the batch job configuration
process is unnecessary.
You can also use the Informix Agent Configuration dialog to submit backup
Configure the Agent for ON-Bar Interaction
and restore jobs using the ON-Bar utility.
You can configure the agent to support the backup or restore operations of
IDS instances, which are performed using the Informix ON-Bar utility.
Post-Installation Tasks
To configure the agent
1. Log in as the Windows administrator to the server where IDS is running.
2. Click Start, Programs, CA, ARCserve Backup Agents, and Informix Agent
configuration.
The Backup Agent for Informix Configuration window opens.
Chapter 2: Installing the Agent for IBM Informix 17
Loading...