32 & 64 bit Instance on the Same AIX Box

Butch

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

Subscribe Post Reply

5390

shenanwei

Yes, you can.
same catalog command.

Sep 20 '07 #2

Butch

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

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

Butch

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

Similar topics

How to change & to & in string?

by: Rich Wallace | last post by:

All, I receive an xml doc with an element which contains a & in the data. I am attempting to insert the data into a SQL Server database and I want to convert the & to a "&" character before I...

.NET Framework

db2syscs.exe CPU usage 100% & db2empfca failing

by: db2inst2 | last post by:

Hi all, I am using win2K db2 8.1 fixpak 2. lately db2syscs.exe started using 100% CPU. This will be the load on the DB. An application will connect to the machine every 10minutes and do few...

DB2 Database

&& and || Operator precedence enforcement

by: Vivek N | last post by:

Hi Folks, This question may well have been asked and answered before. But, sorry that I couldn't find one from the archives. I typed up this program and compiled it with gcc 3.3.2 main() { int...

C / C++

encoding of "&" vs "&" in url

by: DC Gringo | last post by:

I am having a bear of a time with setting a URL query string as a text value in a dropdownlist and Server.URLEncode does not seem to do its job. theFullLink = theLinkPrefix &...

ASP.NET

Declaring & Initializing Classes & ArrayLists

by: GrandpaB | last post by:

While writing this plea for help, I think I solved my dilemma, but I don't know why the statement that solved the problem is necessary. The inspiration for the statement came from an undocumented...

Visual Basic .NET

Singleton & Interfaces

by: rob | last post by:

I have two different classes singleton1 and singleton2 that both are singletons. Both classes implement the same functions. Therefore, I would like to have an interface containing these functions....

C# / C Sharp

Templates & abstraction question

by: AzizMandar | last post by:

There is probably a better way to do this and if so I'm just as happy to see that way. I have a program where I have factories that each create various objects abstracted from a base class. ...

C / C++

static & instance variables

by: Jordan Marr | last post by:

I have the following class: class ProvisionCollection { ... private int m_VarianceCount; public int VarianceCount { get { return m_VarianceCount; }

C# / C Sharp

Clarification to replace the & symbol to & in xml using XSL

by: radhakrishnanrs | last post by:

Hi all, Here, a xml file is not in proper format. I need to replace the "&" symbol to "&" under the attributes. Find below the sample xml file for glance: <root> <child1> <child2...

XML

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server