Re: PHP and IBM DB2 on an AS/400

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. >