Hey Guys,

I have a Problem with the federated acces to Informix. You see below my Configuration. DB2 and Informix run on the sam Mashine...
The failure after a passthru:
(iibm02:db2ihett) $db2 "select count(*) from systables" SQL1822N Unexpected error code "-25596" received from data source
"IDS01".
Associated text and tokens are "The INFORMIXSERVER value is not listed in
the sqlhosts fi". SQLSTATE=560BD

Thanks...



My Configuration:
/$INFORMIXDIR/etc/sqlhosts
# ************************************************** **********************
#
# IBM INC.
#
# PROPRIETARY DATA
#
# Licensed Material - Property Of IBM
#
# "Restricted Materials of IBM"
#
# IBM Informix Client SDK
#
# (c) Copyright IBM Corporation 2002. All rights reserved.
#
# Title: sqlhosts.demo
# Description:
# Default sqlhosts file for running demos.
#
#************************************************* *************************

#iibm02 ontlitcp 127.0.0.1 inf_ids

iibm02 onipcshm iibm02.inf.uni-jena.de inf_ids

--------------------------------------------------------------------------

(iibm02:db2ihett) $cat onconfig.iibm02 |grep DBSERVERNAME
DBSERVERNAME iibm02 # Name of default database server

--------------------------------------------------------------------------
(iibm02:db2ihett) $ed db2dj.ini
?db2dj.ini
a
INFORMIXDIR=/usr/opt/informix
INFORMIXSERVER=iibm02
INFORMIXSQLHOSTS=/usr/opt/informix/etc
.
w
93
q
--------------------------------------------------------------------------
Systemvariablen setzen:
(iibm02:db2ihett) $db2set DB2_DJ_INI=/dbhome/db2/db2ihett/sqllib/cfg/db2dj.ini
(iibm02:db2ihett) $db2set DB2_DJ_COMM=libdb2informix.a

--------------------------------------------------------------------------
DBM CFG Federated:
(iibm02:db2ihett) $db2 get dbm cfg |grep FEDERATED
Federated Database System Support (FEDERATED) = NO
(iibm02:db2ihett) $db2 update dbm cfg using federated yes
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed successfully.
--------------------------------------------------------------------------

(iibm02:db2ihett) $db2 "create wrapper informix"

(iibm02:db2ihett) $db2 "create server IDS01 type informix version 9.4 wrapper informix options(node 'iibm02', dbname 'test_db')"
DB20000I The SQL command completed successfully.

(iibm02:db2ihett) $db2 "create user mapping for db2ihett server IDS01 options (remote_authid '*****', remote_password '******')"
DB20000I The SQL command completed successfully.