hello, i need you help
i have two pc on the network
1.PC - db2 server with databace "CENTRALA"

2. PC is client with unix odbc , i am using db2_v9_linux_db2driver_for_odbc_cli as driver for unix odbc

slavo@bedna:~$ cat /etc/odbc.ini
[CENTRALA]
Driver=DB2
Description=DB2
Database=CENTRALA

slavo@bedna:~$ cat /etc/odbcinst.ini
[DB2]
Description = ODBC for DB2
Driver = /opt/ibm/db2/V9.1/lib32/libdb2.so
FileUsage = 1
DontDLClose = 1

but connection does not work, when i test it from DataManager (included in unixodbc), i always get error code " [08001][unixODBC][IBM][CLI Driver] SQL1013N The database alias name or database name "CENTRALA" could not be found. SQLSTATE=42705"

thak you

Hi,
it looks like there is something wrong with ODBC connection.

1. ucatalog odbc connection:
2. Create ODBC connection:
P.S. I have tested this on Windows box, because I don't have access to Unix box.
Hope this helps,
Grofaty

this command returns this
SQL1297N This command is currently not supported on this platform.

how can i set server hostname or ip ?

Can you connect from the DB2 command line processor?

Try cataloging the database first:

db2 catalog tcpip node myserver remote <server ip or hostname> server <DB2 port number>
db2 catalog database centrala at node myserver

in the client i dont have db2 command ... but on the server connection works locally
sorry i am new to db2, maybe i dont understand what you mean ...
and on the 2.pc i have only unixodbc with cli driver , there is no db2cc or somethik like this ...
but when i want add odbc sources in windows xp i must add it first to db2cc

it works! thank for your help