469,085 Members | 1,039 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,085 developers. It's quick & easy.

Problem in configuring DB2 to access INFORMIX

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
0 1475

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Christian Eriksson | last post: by
1 post views Thread by Christian Eriksson | last post: by
10 posts views Thread by Joachim Banzhaf | last post: by
6 posts views Thread by hedrew3 | last post: by
3 posts views Thread by Javier Rojas Goņi/ Parse Software | last post: by
14 posts views Thread by Khan | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.