I’m writing in response to your article Let’s Start Over from the Beginning. Neither specifying CLOSQLCSR(*ENDMOD) nor running your program in a activation group *NEW (which is not even possible if your procedure is located in a service program and repeatedly called) is a good solution.

In both situations the open data path (ODP) will be deleted after execution and cannot be reused. That means each time you execute your query, the system performs a full open, which is a time-consuming process.

A full open is always necessary the first and second time a query is executed within the

In the Pink Panther movies, Chief Inspector Dreyfus dreaded to hear the name Clouseau. Just the mention of that name was enough to cause Dreyfus to lose control of himself, and even landed him several stays in psychiatric hospitals. In the same way, there are certain words I hate to hear when I’m at work.

In my day job, the words I hate to hear are “There’s a message on QSYSOPR.” A message on the QSYSOPR message queue is rarely good news. It means I’ve got to stop what I’m doing and deal with a problem. (I am proud to

On December 8, 2009, IBM made a little noticed announcement that opens up its 4.7 GHz two- and four-core Power i 520 systems to additional organizations and users. When originally announced, these servers were only available with i 6.1 support. Now organizations running the i5/OS V5R4 operating system can take advantage of these lower cost/higher capability machines. Here’s what happened and why it could be significant for your upgrade plans.

What IBM Announced

As originally released, IBM’s Power i 8203-E4A 520 two-core and four-core 4.7 GHz servers were limited to only running the i 6.1 operating system. They were not