ISPF Commands

There are far too many ISPF commands available to list. What follows is a brief description of some of the most useful, or the most recently added features that I didn’t have space to include before.
PANELID and MSGID are two features available for many years in ISPF, and are especially useful for anyone doing [...]

Read Full Post »

ISPF Systems Programmers Tips and Tricks

TSO
Here are some more keystroke-saving techniques you can incorporate into your own style of interaction with the mainframe. The TSO command parser is highly efficient and can determine the command you wish to use from a minimum number of characters needed to uniquely identify the command.
Many TSO commands also have short versions as an alternative [...]

Read Full Post »

DB2 for z/OS SQL Query Tuning

Let’s begin with a brief review of the key points from my previous article. Intuitive tuning is driven by the simple concept that, when a query takes more CPU or elapsed time than expected, it’s typically doing more I/O. The focus of query tuning is to minimize I/O by exploiting the DB2* optimizer, which is [...]

Read Full Post »

ISPF Tricks

In my extensive experience working in the mainframe space, I’ve come up with some ISPF tricks over the years that I would like to share. Whether they’re useful to you is, obviously, up to you to decide.
Before going forward, a quick note about using ISPF CMD(xxx) is in order. I’ve found that using CMD(xxx) as [...]

Read Full Post »

IBM WebSphere MQ for z/OS v7

IBM WebSphere MQ for z/OS v7 gives you easier Web connectivity, out-of-the-box support for Web 2.0, more flexible programming options and enhanced performance.
Publish and Subscribe for z/OS
In version 7, publish and subscribe is integrated into the z/OS queue manager and is fully configurable in the graphical MQ Explorer tool, which can be used to view, [...]

Read Full Post »

To address VSAM Get/Put Request Error

PROBLEM DESCRIPTION:
 VSAM GET/PUT requests fail with RC=8RPLFDBK X’21080018′ (media manager error x’00140408′) when accessing a VASM data set and the data set has more than 3 volumes which have been recataloged out of the original extent order.    
PROBLEM CONCLUSION:
For out of sequence volumes, the following 2 errors will no longer be given:
Media Manager ERROR CODES=X’00140408′ Management RPLFDBWD [...]

Read Full Post »