As much fun as it is to interact with MySQL from a command line, IBM i people expect more. We want convenience. We want ease of use. We want a Graphical User Interface. We want phpMyAdmin. Starting with Zend Server for IBM i version 6.3.0, Zend is packaging a number … Continue reading
One of the nice features of Zend Server for IBM i is that it will start up automatically whenever the IBM i is restarted. To be more specific, it starts whenever subsystem QSYSWRK is started. Zend DBi does not provide for automatic start up of the Zend DBi MySQL server … Continue reading
The MySQL server is a daemon, meaning it is a constantly running process that communicates via TCP/IP. In order to use Zend DBi MySQL, the Zend DBi MySQL server daemon must be running. Prerequisite: Zend DBi must be installed. The following article can help with that: Install MySQL using the … Continue reading
To determine if you need to troubleshoot the Zend DBi MySQL start up, you should first try to: Start the Zend DBi MySQL Daemon job and verify it is running If the ZENDDBID job will not start, you will often see some message (after a bit of digging around) that … Continue reading
This article presents one of the troubleshooting steps for Zend DBi MySQL daemon start ups, found in this article: Troubleshoot Zend DBi MySQL daemon start up failures (mysql.sock) To check this issue, please log on to a 5250 session and enter this command: dspsysval qsyslibl The output will be similar … Continue reading
This article presents one of the troubleshooting steps for Zend DBi MySQL daemon start ups, found in this article: Troubleshoot Zend DBi MySQL daemon start up failures (mysql.sock) One reason MySQL may fail to start is if the default MySQL port 3306 is in use. One way to check … Continue reading
This article presents one of the troubleshooting steps for Zend DBi MySQL daemon start ups, found in this article: Troubleshoot Zend DBi MySQL daemon start up failures (mysql.sock) To check this issue, please log on to a 5250 session as QSECOFR or a *SECOFR class user and enter this command: DSPOBJD … Continue reading
This article presents one of the troubleshooting steps for Zend DBi MySQL daemon start ups, found in this article: Troubleshoot Zend DBi MySQL daemon start up failures (mysql.sock) When the Zend DBi MySQL daemon job, ZENDDBID, will not start, the job log will often show something like this: RNM OBJ(‘/tmp/mysql.sock’) … Continue reading
Most Zend DBi MySQL daemon start up issues can be resolved by reviewing the known issues covered in the troubleshooting article: Troubleshoot Zend DBi MySQL daemon start up failures (mysql.sock) However, there may be a situation where none of the known issues seem to be the problem. Even if one … Continue reading
Most Zend DBi MySQL daemon start up issues can be resolved by reviewing the known issues covered in the troubleshooting article: Troubleshoot Zend DBi MySQL daemon start up failures (mysql.sock) However, there may be a situation where none of the known issues seem to be the problem. In that situation, … Continue reading