Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2000121

Re: [PHP-DB] PHP and IBM DB2 on an AS/400 From: Helmut Tessarek (tessus <email protected>)
Date: 12/12/00

Hi,

The protocol specific error code 111 means following:

The connection has been refused. If you are trying to connect to the database,
check that the database manager and TCP/IP protocol support at the server have
been started successfully.

If using SOCKS protocol support, also ensure that TCP/IP protocol support at the
SOCKS server has been started successfully.

So, first of all you will have to check, if the listener process is started on the
AS/400.
(I'm not an AS/400 expert - but on AIX, Linux or NT the DB2 environment variable
DB2COMM has to be set to TCPIP at the instance level. Actually you can set it
globally, though.)

If this still does not help, look at the db2diag.log. There might be other useful
information.
If the information in the db2diag.log is not sufficient, set diaglevel to 4:

db2 update dbm cfg using diaglevel 4

I hope this will help.

Helmut Tessarek

EDV-Zivi wrote:

> I want to get data from an AS/400 with PHP on a Linux machine running RedHat
> 7.0. I found documentation how to do this with IBM DB2 Personal Edition for
> Linux, but when I try to connect, I get an error on the DB2 Personal Edition
> command line:
>
> db2 => connect to php_qgpl user edvzivi
> Enter current password for edvzivi:
> SQL30081N A communication error has been detected. Communication protocol
> being used: "TCP/IP". Communication API being used: "SOCKETS". Location
> where the error was detected: "". Communication function detecting the error:
> "connect". Protocol specific error code(s): "111", "*", "*". SQLSTATE=08001
>
> php_qgpl is the database alias, my username is edvzivi.
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>