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

32 & 64 bit Instance on the Same AIX Box

P: n/a
Can I have a 32 bit & a 64 bit db2 instance on the same AIX box? If so
I do I catalog a databse to use the 32 bit insatnce?

Thanks

Sep 20 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Yes, you can.
same catalog command.

Sep 20 '07 #2

P: n/a
On Sep 20, 3:39 pm, shenan...@gmail.com wrote:
Yes, you can.
same catalog command.
I have done that and when I try to connect I get the following:

CLI connection failed.

SQL30061N The database alias or database name "DSFNTT01 "
was not found at the remote node. SQLSTATE=08004
ODBC connection failed.

[IBM][CLI Driver] SQL30061N The database alias or database name
"DSFNTT01 " was not found at the remote node. SQLSTATE=08004


Sep 20 '07 #3

P: n/a
Ian
Butch wrote:
On Sep 20, 3:39 pm, shenan...@gmail.com wrote:
>Yes, you can.
same catalog command.

I have done that and when I try to connect I get the following:

CLI connection failed.

SQL30061N The database alias or database name "DSFNTT01 "
was not found at the remote node. SQLSTATE=08004
ODBC connection failed.

[IBM][CLI Driver] SQL30061N The database alias or database name
"DSFNTT01 " was not found at the remote node. SQLSTATE=08004
The two instances will be listening on different port numbers. So,
while the commands are syntactically identical, the specifics will
be a little different.

i.e. (on a Windows server, since you're talking about ODBC)

catalog node db2inst32 remote server.domain.com server 50032
catalog database db32 at node db2inst32
catalog system odbc data source db32

catalog node db2inst64 remote server.domain.com server 50064
catalog database db64 at node db2inst64
catalog system odbc data source db64

Ian Bjorhovde
Sep 21 '07 #4

P: n/a
On Sep 20, 10:41 pm, Ian <ianb...@mobileaudio.comwrote:
Butch wrote:
On Sep 20, 3:39 pm, shenan...@gmail.com wrote:
Yes, you can.
same catalog command.
I have done that and when I try to connect I get the following:
CLI connection failed.
SQL30061N The database alias or database name "DSFNTT01 "
was not found at the remote node. SQLSTATE=08004
ODBC connection failed.
[IBM][CLI Driver] SQL30061N The database alias or database name
"DSFNTT01 " was not found at the remote node. SQLSTATE=08004

The two instances will be listening on different port numbers. So,
while the commands are syntactically identical, the specifics will
be a little different.

i.e. (on a Windows server, since you're talking about ODBC)

catalog node db2inst32 remote server.domain.com server 50032
catalog database db32 at node db2inst32
catalog system odbc data source db32

catalog node db2inst64 remote server.domain.com server 50064
catalog database db64 at node db2inst64
catalog system odbc data source db64

Ian Bjorhovde- Hide quoted text -

- Show quoted text -
I believe you have the answer I am looking for!

Thanks, I will post my results!

Sep 21 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.