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.
By 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 wasmerely a footnote. Each day, I pestered management for a chance to write a program. In my spare time, I read RPG manuals.
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.