DB2 Connect EE on AIX?

Thank you all for your feedbacks. Those are very valuable information to us.
I
very much appreciate everybody's input on this topic.

Regards,

Jon Zhang


Get your FREE web-based e-mail and newsgroup access at:
#

Create a new mailbox, or access your existing IMAP4 or
POP3 mailbox from anywhere with just a web browser.

We almost always recommend TCP/IP over SNA for this reason: you could have the
same problems setting up SNA on NT as well.

MVS / AIX shop (RS/6000 SP2).
3 AIX "system programmers" (MVS terminology for "experienced administrator")
worked on it (not including me).
Also 2 IBM-recommended consultants from IBM's local RS/6000 SP2 business
partner. IBM themselves were not prepared to send in their own staff,
claiming that these consultants gave excellent AIX support (neither of them
had any experience with SNA on AIX).

Admittedly SNA was main problem, plus security issues with OS/390. The team
also opened two PMRs with IBM, and received fixes for both. Project dragged
on for months without getting to the desired results. When I gave up they
were able to do RUOW with OS/390 password (CONNECT USING) from local AIX
logon (not from NT client). Under NT we run single-signon and DUOW over NT
clients.

I admit to limited AIX experience, and substantially greater NT experience,
this probably assisted when it came to my one-man NT install and configure
job. I also knew where to look on OS/390. It is likely that there was
limited SNA experience on the AIX team, despite one of the staff's having
years of OS/390 (CICS / DB2) experience.

I won't deny that with the proper support and knowledge, it could have been
made to work. But if somebody is starting fresh on the problem, NT is, in my
experience, a much easier road to travel, and reliability (see my original
post) is excellent.

...

Hi Mark,

I don't mean to challenge your experience in any way. But ... when you did the
original install, were you working with an experienced UNIX admin? Is your shop
primarily NT? Did you or the UNIX admin go for DB2 training of any kind, or was
any experienced DB2 consulting help onhand?

You may have covered all these bases, however ... I'm merely making the point
that UNIX is not NT, and that to be fair, you can't necessarily expect to just
pick up a UNIX product and be able to install it successfully with little or no
experience. I've installed DB2 on AIX many times successfully, and also had some
trials/tribulations ... but a different path through the install panels (btw ...
using "db2setup" is the way to go as opposed to db2install) ... can make a world
of difference.

I went absolutely crazy trying to get DB2 COnnect EE to work on AIX.

In utter desparation I got hold of an NT Server box, installed the whole lot
(IBM Comms Server, and DB2 Connect), and had it working within one day.

The AIX team then spent two weeks trying to reproduce my result (I refused
to invest any more time), before finally giving up in hopeless despair too.

We later set up the real production system (took 3 hours) and it has been
running reliably on NT4 for over a year at 24*6+23.

"I knew AIX is a far better system than NT". Not in my experience!

- Mark Yudkin

...

Thanks again for the tip, Larry.

Jon Zhang


Get your FREE web-based e-mail and newsgroup access at:
#

Create a new mailbox, or access your existing IMAP4 or
POP3 mailbox from anywhere with just a web browser.

Jon,

I don't have numbers, but I can tell you for sure that there is a very prevalent
DB2 Connect user install base on UNIX. You would need to contact your local IBM
Data Management rep to explore this for you if you need references.

Hi Larry,

Thank you very much for your reply.

I guess it's not very easy to put all my questions in a very specific
fashion.
Since we are currently running DB2 Connect on NT, we wonder if the
implementation on AIX is more stable than on NT. For example: DB2 Connect
used
to cause Dr. Watsons on NT platform. Did anyone every report such kind of
system failure caused by DB2 Connect on AIX?

We are interested on the impression from the user communities that DB2 on
AIX
implementation is "stable". It's a vague question, but we are interested
non-the-less.

Additionally, we are concerned that migrating from NT to AIX would put us at
risk for newly discovered bugs, because our feeling is that the user
installed
base is predominantly NT. If you could provide us some information or ideas
on
proportion of DB2 Connect implementation that is AIX versus NT would be very
much appreciated.

Once again, thank you for your prompt response.

Jon Zhang
Z


Get your FREE web-based e-mail and newsgroup access at:
#

Create a new mailbox, or access your existing IMAP4 or
POP3 mailbox from anywhere with just a web browser.

Jon, it seems to me like you're asking a pretty vague question... can you
please be more specific?

--
Larry Menard
IBM Workstation Database (DB2) Performance Team
Defender of Geese and of all things Natural