Monthly Archives: May 2015

Thinking of upgrading Apache on IBMi from 2.2 to 2.4? Here’s some sites to look at

Well it’ll probably be useful to set your LogLevels to debug mode and view the apache log file after the upgrade:

http://httpd.apache.org/docs/2.4/mod/core.html#loglevel

Also look over these websites:

IBM HTTP Server Upgrading to Apache 2.4

Apache Upgrading to 2.4 from 2.2

There’s a lot of exciting new modules and changes to existing modules to check out in Apache 2.4

New features

Gotchas

Also look out for issues on Include directive thanks to @ChukShirley .  You might have to change those to IncludeOptional.

How to change the library list before calling an external RPG program in a DB2 SQL stored procedure on IBMi

Below is how you can create a SQL stored procedure that calls the CL command ADDLIBLE to change the library list before calling an external RPG program that may require that Library in the Library List to run properlyWe also handle the error scenario where you might add a library that already exists (which would crash your SQL stored proc).  Let me know if this is helpful by commenting below or tweeting a reply to @php_dave