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 http://www.microsoft.com/mainframe .


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)
      BALPUTLV 06/20/00 16.49PUT LEVEL GOES HERE ===> PUT1202B <=== PUT LEVEL GOES HERE
  • 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 xmpMail.pl to send mails via sendmail

The following script references “Perl module xmpPerl.pm – 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
And DB2 UDB LUW

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

manufacturer

product

supported platforms

link

IBM

DB2 Universal Database

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

http://www.ibm.com/software/db2/data

Oracle

Oracle

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

http://www.oracle.de

Sybase

Adaptive Server

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

http://www.sybase.de

Borland

Interbase

Linux, Sun/Solaris, Windows

http://www.interbase.com

CA Computer Associates

Ingres/OpenROAD

Unix, OpenVMS, Linux, WIndows

http://www.ca.com

Microsoft

SQL Server

Windows NT/2000/XP

http://www.microsoft.de

object-oriented database systems

manufacturer

product

supported platforms

link

CA Computer Associates

Jasmine

on request

http://www.ca.com

Object Design

ObjectStore

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

http://www.objectstore.com

Versant

Versant VDS

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

http://www.versant.de

post-relationale database systems

manufacturer

products

supported platforms

link

InterSystems

Caché

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

http://www.intersystems.de

Poet Software

FastObjects

HP-UX, Linux, Sun/Solaris, Windows

http://www.fastobjects.de

Mapping Tools

manufacturer

products

supported platforms

link

Thought

CocoBase
Enterprise O/R

n/a

http://www.thoughtinc.com

Poet Software

FastObjects SQL
Object Factory

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

http://www.fastobjects.de

Sun Microsystems

Jaba Blend

n/a

http://www.sun.de

Software Tree

JDX

n/a

http://www.softwaretree.com

ONTOS

ObjectSpark

n/a

http://www.objectspark.com

Rogue Wave Software

SourcePro DB

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

http://www.roguewave.com

This table requires a revision.