Technote (FAQ)
Question
This information describes how to configure your DB2 Version 7 warehouse agent that is running on an AIX system to access DB2 Version 5 data. No special configuration is needed to access DB2 Version 6 and DB2 Version 7 data.
Answer
To access DB2 Version 5 data with the DB2 Version 7 warehouse agent that is running on an AIX system, you must configure the warehouse agent with a DB2 Version 6.1 instance. Follow these steps:
- Install the DB2 Version 6.1 run-time client on your AIX system. You can obtain the DB2 Version 6.1 run-time client for AIX by selecting DB2 Universal Database, Clients and DB2 Connect Workstation Downloads at the following Web site:
http://www.ibm.com/software/data/db2/udb/support
- Update the warehouse agent configuration file iwh.environment so that the environment variable db2instance points to a DB2 Version 6.1 instance.
- Catalog all databases that the warehouse agent is to access in this DB2 Version 6.1 instance.
- Stop the agent daemon process by issuing the kill command with the agent daemon process ID. The agent daemon will then restart automatically. You need root authority to issue the AIX kill command.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.