MC Systems Insight
MC Power Technology Manager
MC RPG Developer
MC Power Developer
MC TNT Tips 'n Techniques
MC AIX Expert
MC Linux Expert
MC Mobile on Power
This Week @ the MC Press Bookstore

August 6, 2008 | Vol 7 Issue 15


In This Issue:

Feature Article - Programming
Working with Data Sets

Let's look back at the various ways we processed data sets using RPG and compare that to the new V6R1 SQL grouping sets capability.

daniel_cruikshank.jpgBy Daniel Cruikshank

Like many midrangers, I began my career as a computer operator, loading card decks into the Multi-Function Card Mangler (MFCM) attached to an IBM System 3 Model 10 utilizing RPG/2. It was my first job after completing school, and I was eager to become a programmer. In school, we were taught Basic Assembler Language (BAL), and the RPG language was merely a footnote. Each day, I pestered management for a chance to write a program. In my spare time, I read RPG manuals.


Feature Article - Programming
Finding SQL Server Mode Connecting Jobs

Now it's much easier to understand QSQSRVR usage and isolate QSQSRVR-related problem domains and origins.

By Scott Forstie

IBM DB2 for i customers are accustomed to seeing SQL server mode job activity, otherwise known as QSQSRVR prestart jobs, in the QSYSWRK subsystem. Over time, customer applications, third-party software, and IBM middleware have increased the use of SQL server mode. A consequence of this broad use is that it has become increasingly difficult to start with a specific QSQSRVR job and find its application owner.


This article describes some recent improvements to V5R4M0 and V6R1M0 that make it downright simple to pinpoint the application job that holds the connection to the QSQSRVR as well as the thread identifier within the application job that was the last user of the SQL server mode connection for the specific QSQSRVR job.


Support MC Press - Visit Our Sponsors


 Popular Forums



   Search Sponsor


 Popular Searches