Re: Can someone give me a non-marketing explanation of DB2 Connect?

On Tue, Nov 10, 2015 at 10:51 AM Buck Calabro <kc2hiz@xxxxxxxxx> wrote:

There isn't one, single DB2. There are three of them:
DB2 for z (mainframe)
DB2 for LUW (Linux, Unix, Windows)
DB2 for i (that's us!)

Each one needs a different ODBC driver. The ODBC driver for DB2 for i
comes with IBM Access for Windows, and there's an equivalent in the
Access Client Solutions package as well.

Ok, but PHP is absracting this away. There is one ibm_db2 driver with one
db2_connect call for all the DB2 flavors and apache derby.

And so: What's your entire
connexion string? Are you using the DB2 LUW driver to try to talk to
IBM i? That might work, but DB2 for i has a different port. 446 if
memory serves.

DATABASE=;HOSTNAME=hostname;UID=username;PWD=password;

My Current puzzle is if I'm running process monitor on php, even if the
AS/400 uses a different port number, I should see a failed TCP connection
if I change the hostname of a working connection string from localhost to
another hostname.