By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,537 Members | 1,750 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,537 IT Pros & Developers. It's quick & easy.

Problem in configuring DB2 to access INFORMIX

P: n/a
Hi,

We have DB2 v9 FP2 on AIX 5.3 64-bit. We have Informix 7 on another
AIX 5.3. Our requirement is to access Informix tables from within a
DB2 database.

I installed Informix Client SDK 2.9 on DB2 server. I did the following
steps to create a nickname on DB2 server.

1. Configured sqlhosts file.
2. Ran djxlinkInformix - No errors
3. Configured db2dj.ini file in sqllib/cfg directory.
4. Enabled DB2 instance (DBM cfg FEDERATE set to YES).
5. Created database - No errors
6. Created wrapper for Informix - No errors.
7. Created server - No errors
8. Created user mapping - No errors
9. While creating nickname, receiving the error as below.

SQL1822N Unexpected error code "-761" received from data source
"XXXXXXXX".
Associated text and tokens are "INFORMIXSERVER does not match either
DBSERVERNAME or D" SQLSTATE=560BD

I verified that the INFORMIXSERVER value in db2dj.ini is same as
DBSERVER value in sqlhosts (located in /etc/sqlhosts and /usr/informix/
etc/sqlhosts) file.

One mistake I did was I mentioned the version for Informix as 9 (in
step 7 above) whereas we have Informix 7.

Is there anything I am missing?

Thanks for your help,
Prasad

May 10 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.