473,320 Members | 1,958 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How do i connect UNIX TO UNIX Machines???

Hi friends,

i have a unix machine PC1 where a database is running ( IBM DB2 V8.1 ) .
Then i have another machine PC2 i installed there also ( IBM DB2 V8.1 ). On
PC2 i installed unixODBC. To connect to the database over ODBC on unix i did
this:

on db2 console:
catalog tcpip node archiv remote PC1 server DB2_db2inst1

command successfull
then

catalog database archiv
command successfull
then

connect to archiv
command successfull

then is used the tool isql

isql -v archiv root password
command successfull

Now i am connect but i cant make this commands but there are there it exits
SELECT * FROM TABLE.

I also did this->
db2 => catalog odbc data source archiv
SQL1297N This command is currently not supported on this platform.

I dont know what i can do now to solve my problem.

Please can anyone help me with this.

Cu,

DB2NOOB

Nov 12 '05 #1
3 5719
It looks like you are mixing up UDB and ODBC facilities.

You've attempted to use UDB commands to gain access to PC1 from PC2. The
CATALOG ... NODE... commad, as you coded it, assumes that you have
DB2_db2inst1 defined in the services (usually /etc/services) file on
PC2. (The port number must match that being used on PC1.) CATALOG
DATABASE requires an AT NODE clause when the database is remote. Once
these have been completed successfully; you should be able to access the
remote database as follows (enter the password when prompted):
[]$ db2 connect to archiv user root
[]$ db2 "select count(*) from syscat.tables"
[]$ db2 terminate

If you can't access data in a specific table; root probably doesn't have
access privileges to the data in it.

If you need to access the data using ODBC; you must go into the ODBC
configurator (not part of UDB) and define the UDB database there. You
can define it so that PC2 users use the UDB definition of archiv on PC2
to get to PC1. You could also setup ODBC on PC1 and use an ODBC to ODBC
connection from PC2 to PC1. It may also be possible to make a direct
ODBC connection from PC2 to UDB on PC1 but I'd need to research that to
verify that it's possible.

CATALOG ODBC DATA ..... is a command that is Windows only. That's
explicitly stated in the Command Reference manual.
Phil Sherman

Fabian Knopf wrote:
Hi friends,

i have a unix machine PC1 where a database is running ( IBM DB2 V8.1 ) .
Then i have another machine PC2 i installed there also ( IBM DB2 V8.1 ). On
PC2 i installed unixODBC. To connect to the database over ODBC on unix i did
this:

on db2 console:
catalog tcpip node archiv remote PC1 server DB2_db2inst1

command successfull
then

catalog database archiv
command successfull
then

connect to archiv
command successfull

then is used the tool isql

isql -v archiv root password
command successfull

Now i am connect but i cant make this commands but there are there it exits
SELECT * FROM TABLE.

I also did this->
db2 => catalog odbc data source archiv
SQL1297N This command is currently not supported on this platform.

I dont know what i can do now to solve my problem.

Please can anyone help me with this.

Cu,

DB2NOOB


Nov 12 '05 #2
Hi Fabian

Following on from what Philip suggests, the UDB and ODBC connections
are different mechanisms for accessing your DB2 database.

At OpenLink Software, we provide a Client/Server solution for
accessing DB2 databases. It requires the OpenLink ODBC client
installed on PC1 and Server Components installed on PC2. You simply
configure a configuration file with the DB2 Instance and Directory and
using any ODBC compliant application, you make your connection to your
server. In this instance, you use SQL as the means of communicating
and not UDB commands. If you'd like more information, please respond
here or you can obtain a 30 evaluation copy from
http://www.openlinksw.com

Regards
Emmon Simbo

Philip Sherman <ps******@ameritech.net> wrote in message news:<s_*******************@newssvr33.news.prodigy .com>...
It looks like you are mixing up UDB and ODBC facilities.

You've attempted to use UDB commands to gain access to PC1 from PC2. The
CATALOG ... NODE... commad, as you coded it, assumes that you have
DB2_db2inst1 defined in the services (usually /etc/services) file on
PC2. (The port number must match that being used on PC1.) CATALOG
DATABASE requires an AT NODE clause when the database is remote. Once
these have been completed successfully; you should be able to access the
remote database as follows (enter the password when prompted):
[]$ db2 connect to archiv user root
[]$ db2 "select count(*) from syscat.tables"
[]$ db2 terminate

If you can't access data in a specific table; root probably doesn't have
access privileges to the data in it.

If you need to access the data using ODBC; you must go into the ODBC
configurator (not part of UDB) and define the UDB database there. You
can define it so that PC2 users use the UDB definition of archiv on PC2
to get to PC1. You could also setup ODBC on PC1 and use an ODBC to ODBC
connection from PC2 to PC1. It may also be possible to make a direct
ODBC connection from PC2 to UDB on PC1 but I'd need to research that to
verify that it's possible.

CATALOG ODBC DATA ..... is a command that is Windows only. That's
explicitly stated in the Command Reference manual.
Phil Sherman

Fabian Knopf wrote:
Hi friends,

i have a unix machine PC1 where a database is running ( IBM DB2 V8.1 ) .
Then i have another machine PC2 i installed there also ( IBM DB2 V8.1 ). On
PC2 i installed unixODBC. To connect to the database over ODBC on unix i did
this:

on db2 console:
catalog tcpip node archiv remote PC1 server DB2_db2inst1

command successfull
then

catalog database archiv
command successfull
then

connect to archiv
command successfull

then is used the tool isql

isql -v archiv root password
command successfull

Now i am connect but i cant make this commands but there are there it exits
SELECT * FROM TABLE.

I also did this->
db2 => catalog odbc data source archiv
SQL1297N This command is currently not supported on this platform.

I dont know what i can do now to solve my problem.

Please can anyone help me with this.

Cu,

DB2NOOB

Nov 12 '05 #3
Hi Emmon,

problem solved !
Thx for your help!

Cu,

Fabian
"Emmon Simbo" <es****@openlinksw.co.uk> schrieb im Newsbeitrag
news:2c**************************@posting.google.c om...
Hi Fabian

Following on from what Philip suggests, the UDB and ODBC connections
are different mechanisms for accessing your DB2 database.

At OpenLink Software, we provide a Client/Server solution for
accessing DB2 databases. It requires the OpenLink ODBC client
installed on PC1 and Server Components installed on PC2. You simply
configure a configuration file with the DB2 Instance and Directory and
using any ODBC compliant application, you make your connection to your
server. In this instance, you use SQL as the means of communicating
and not UDB commands. If you'd like more information, please respond
here or you can obtain a 30 evaluation copy from
http://www.openlinksw.com

Regards
Emmon Simbo

Philip Sherman <ps******@ameritech.net> wrote in message

news:<s_*******************@newssvr33.news.prodigy .com>...
It looks like you are mixing up UDB and ODBC facilities.

You've attempted to use UDB commands to gain access to PC1 from PC2. The
CATALOG ... NODE... commad, as you coded it, assumes that you have
DB2_db2inst1 defined in the services (usually /etc/services) file on
PC2. (The port number must match that being used on PC1.) CATALOG
DATABASE requires an AT NODE clause when the database is remote. Once
these have been completed successfully; you should be able to access the
remote database as follows (enter the password when prompted):
[]$ db2 connect to archiv user root
[]$ db2 "select count(*) from syscat.tables"
[]$ db2 terminate

If you can't access data in a specific table; root probably doesn't have
access privileges to the data in it.

If you need to access the data using ODBC; you must go into the ODBC
configurator (not part of UDB) and define the UDB database there. You
can define it so that PC2 users use the UDB definition of archiv on PC2
to get to PC1. You could also setup ODBC on PC1 and use an ODBC to ODBC
connection from PC2 to PC1. It may also be possible to make a direct
ODBC connection from PC2 to UDB on PC1 but I'd need to research that to
verify that it's possible.

CATALOG ODBC DATA ..... is a command that is Windows only. That's
explicitly stated in the Command Reference manual.
Phil Sherman

Fabian Knopf wrote:
Hi friends,

i have a unix machine PC1 where a database is running ( IBM DB2 V8.1 ) .. Then i have another machine PC2 i installed there also ( IBM DB2 V8.1 ). On PC2 i installed unixODBC. To connect to the database over ODBC on unix i did this:

on db2 console:
catalog tcpip node archiv remote PC1 server DB2_db2inst1

command successfull
then

catalog database archiv
command successfull
then

connect to archiv
command successfull

then is used the tool isql

isql -v archiv root password
command successfull

Now i am connect but i cant make this commands but there are there it exits SELECT * FROM TABLE.

I also did this->
db2 => catalog odbc data source archiv
SQL1297N This command is currently not supported on this platform.

I dont know what i can do now to solve my problem.

Please can anyone help me with this.

Cu,

DB2NOOB

Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Tony Baker | last post by:
Hi, being a Windows developer and not having anything to do with UNIX/Solaris, I have a few questions about accessing .Net Web Applications from such environments. If a client has a UNIX/Solaris...
3
by: sumGirl | last post by:
Anyone support a config where you have an unix/linux (AIX here) ODBC client connection to SQL Server database? I am looking for a simple, supportable configuration that does not require me to learn...
8
by: Mary Jane Pronio | last post by:
Any information would be greatly appreciated~~!! Thanks!
0
by: Zorba.GR | last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager...
10
by: Ed Stevens | last post by:
A tale of woe, and a question . . . Last week my boss said to me "we've installed DB2 Connect on this Solaris box. Make it work." Now, I've barely seen DB2 Connect on Windows, having fumbled...
1
by: Tom Andersen | last post by:
Hi all Im trying to install DB2 Connect from a central installation point. and the program installs as it should, on the target machine, Is there a way to implement the databases into the...
4
by: Michael | last post by:
Hi, I'm having difficulty finding any previous discussion on this -- I keep finding people either having problems calling os.exec(lepev), or with using python's exec statement. Neither of...
4
by: Christian Maslen | last post by:
Hi All, I understand in older versions of DB2/UDB this was not possible. The following article explains how I might do this ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.