Freitag, 18 of April of 2014

Category » miscellaneous

Job Scheduling on Windows – White Paper

The purpose of the white paper is to compare mainframe-based and distributed-based job schedulers and to assess the readiness of Microsoft Windows-based job scheduling technology to manage workloads at the enterprise level. The paper can also help IT organizations that plan to migrate mainframe workloads to the Windows Server platform as part of a legacy modernization initiative.

This paper opens with a review of the market for job scheduling, followed by a brief outline of its growth path. Detailed comparisons of a selection of both mainframe-based and distributed-based job scheduling products provide the basis for analyzing job scheduling capabilities on each type of platform. It also looks at two products on the market that offer JCL emulation on the Windows Server platform. It concludes with a glimpse at what Microsoft is doing with scripting and task scheduling.

Custom Research Note, Dr. Mike Gilbert, Legacy Directions
Technical Review: Michael Dee Hester, Microsoft
Published: December 2006

Read Word DOC here.

For the latest information, please see .

Automated STROBE measurement reports and alerts

Project Title: Automated STROBE batch measurement reports and alerts

Subject: Instead of ad-hoc or permanent monitoring, an individual solution based on Compuware’s STROBE will periodically monitor distinct address spaces at distinct time and duration. Measurement reports will be created automatically from STROBE sample datasets. A REXX procedure will then analyse measurement reports. In case of breaking threshold values, a recipient list will receive e-mails showing indication to specific performance indicators.

Solution: Compuware STROBE, JCL, REXX procedure, job scheduler (e.g. TWS).


Part I – initialization, creation of STROBE measurement tasks


Part II – plan/initiate STROBE daily measurement, executed 2 times a day

Replace variable variable &TWSDSLVL. by an adequate high index level. Replace &OYMD1 by current (julian or ISO) date. Replace &CDATE by current date. Expect a sample dataset for every addresse space and for every measurement (e.g. at 9:30 am and  3:00  pm).

Once the online component of STROBE has executed a measurement request, it creates a STROBE sample dataset with a unique dataset name. STROBE option SAMDSN=&TWSDSLVL..STROBE.D&OYMD1 results in &TWSDSLVL..STROBE.D&OYMD1..MYCICS1.S001D001 for the first request for “MYCICS1″. Users will need to specify this output dataset name within the next step.


Part III – creation of a STROBE measurement from sample datasets

This job consists of mainly 3 steps: Create and format an STROBE measurement report using an STROBE sample dataset. It uses the STROBE batch utilities STROBEDT and STROBEDS. Then next step then executes the REXX procedure XMPSTRCK to check specific areas of the report for threshold violations. In case of a finding it ends with RC=4. The next step will then send the REXX report as an email to a recipient list.

To individualize the reports a bit, users may change the report name using the option REPNAME=’PLX1 MYCICS1 &CYYYY-&CMM-&CDD’. (PLX1=LPAR in this example, MYCICS1=address space invastigated, other variables for example result in 2013-12-05).

The first sample started at 09:30 will be reported into dataset &TWSDSLVL..STROBE.D&OYMD1..MYCICS1.REPORTAM. The second sample started at 15:00 (3 pm) creates a sample dataset ending with S002D001. Users need to run a second job to create a report which dataset name ends REPORTPM.


Part IV - houskeeping – delete obsolete datasets

The job determines and deletes STROBE sample and report datasets older than 45 days.


Report examples





How to determine PUT level of BMC products

Do you want to determine the maintenance level of you BMC software products?

BMC Software updates all mainframe deliverables at regular intervals. The Program Update Tape (PUT) system makes available the latest service and maintenance for BMC Software products that are installed with the Installation System.

Some suggestions easy to apply.

  • BMC tools with TSO/ISPF front-end, e.g. DB2 Catatalog Manager for DB2 for z/OS:
    1. start the ISPF front-end
    2. execute TSO command <TSO ISRDDN>, locate DD-name BBLINK or dataset, which contains *.BMCLINK.* or similar as part of the dataset name.
    3. browse this library, you should have read-access automatically
    4. locate member BALPUTLV and browse this member, you will find … (or similar)
  • BMC Mainview z/OS or CICS or DB2 or other monitor:
    1. start the <ABOUT> view. The view started will show …
      About customer info              
      MAINVIEW Infrastructure Level (6.1.00)      
      Last installed PUT Level (PUT1202B)      

If you have sufficient access authority you could also try to locate an executing BMC monitor via SDSF and DA command. Look for CAS or PAS or similar. The JCL and JES output of the started task will tell you some interesting information.

For more information about BMC’s PUT maintenance delivery schedule click here.

Shell to send mails via sendmail

The following script references “Perl module – function package used by DBA Perl scripts”

The following very simple script is just a small frame for sending mail via network from command level or as a service for other scripts.

For more information how to send emails via sendmail (on AIX) see here: “Fun with Sendmail on AIX” (IBM developerWorks 2010, PDF).


SQL to retrieve DB2 subsystem information – update for DB2 10 z/OS


How to retrieve JCC version

You need to check the version of your Java Combined Client (JCC) installed? Try this way:

All DB2 JDBC Driver versions, see here!

More information on DB2, Java, JDBC and JCC.

Comparing the architectural differences between DB2 for z/OS and DB2 for LUW

“Breaking the DB2 Platform Barrier”
Comparing the Architectural
Differences Between DB2 UDB for z/OS

Quest Software, Inc.

Published in 2009 but one of the best overviews for DB2 “newbies” and staff working on both platforms!

Read more!


Data Aging Tools

Data Aging Tools are usually instrument of development or test environments to change the age of test data, to make them younger or older. In particular, data are systematically adjusted to a desired point on the timeline concerning their chronology.  Those tools has an ultimate high point of interest with Y2K or the Year 2000 changeover, where structural changes had to be tested on a complete cover of the calendar. But also in these days, those tools are still interesting when transitions, e.g. new month or new year processing, has to be tested.  Actually, these are truly no new processes, but occasionally the one or other application or database management system has to be migrated. And then Data Aging Tools are immanent.

Some major software products as an execeprt of an still emerging market of Data Aging Tools:

NLS and unicode support


Ermittlung der Codepage-Einstellungen mit dem DB2 Command “db2 -a connect to ….”.

FOR BIT DATA werden wie Daten mit Codepage=0 verschlüsselt verarbeitet.

Beachte: The IBM DB2 Driver for JDBC and SQLJ returns data from a ResultSet.getString call for a CHAR FOR BIT DATA or VARCHAR FOR BIT DATA column as a lowercase hexadecimal string.

Displaying/selecting [VAR]CHAR FOR BIT DATA table columns:

What ist the codepage of a table column – querying the DB2 catalog:
(FOR BIT DATA columns are shown with CODEPAGE=0)

Overview relational und object-oriented database systems

Overview relational and object-oriented database systems

relationale database system with OO extensions



supported platforms



DB2 Universal Database

AIX, HP-UX, Linux, (0S/2), (OS/390), Sun/Solaris, Windows, z/OS



AIX, Linux, (OS/390), True64, Sun/Solaris, Windows, z/OS


Adaptive Server

AIX, HP-UX, Irix, Linux, Sun/Solaris, True64, Windows



Linux, Sun/Solaris, Windows

CA Computer Associates


Unix, OpenVMS, Linux, WIndows


SQL Server

Windows NT/2000/XP

object-oriented database systems



supported platforms


CA Computer Associates


on request

Object Design


AIX, HP-UX, Irix, True64, Sun/Solaris, Windows


Versant VDS

AIX, HP-UX, Irix, Sun/Solaris, Linux, Windows

post-relationale database systems



supported platforms




Win 95/95/ME/NT/2000/XP, Linux, Compaq OpenVMS, Linux, AIX, HP-UX, True64, Sun/Solaris

Poet Software


HP-UX, Linux, Sun/Solaris, Windows

Mapping Tools



supported platforms



Enterprise O/R


Poet Software

FastObjects SQL
Object Factory

Win 2000/NT/XP/ME, Sun/Solaris

Sun Microsystems

Jaba Blend


Software Tree






Rogue Wave Software

SourcePro DB

AIX, AS/400, Windows, Sun/Solaris, HP-UX, (OS/390), True64, Red Hat Linux, z/OS

This table requires a revision.