Donnerstag, 17 of April of 2014

Category » z/OS

Loading DB2 z/OS data into DB2 LUW in internal format

Loading data of DB2 z/OS internal format into a DB2 Linux/Unix/Windows database became very easy.

  • Either you use DB2 Connect to connect from any DB2 Linux/Unix/Windows to DB2 for z/OS. But this costs you a separate license fee. For a distinct class of DB2 LUW server (e.g. on AIX) IBM supplies the DB2 Connect Enteprise license, which costs even more.
  • Or just use existing infrastructure components: UNLOAD or DSNTIAUL your data at z/OS, transport (e.g. SCP, SFTP ) your data in binary format and LOAD, IMPORT or INGEST data at DB2 for Linux/Unix/Windows. Following sample will show you how it works.

Assume following DB2 structrure of a sample table:

Then unload your DB2 z/OS data using DSNTIAUL. SYSPUNCH will show you the columns locations you will need later:

Then transport SYSRECnn dataset to Linux/Unix/Windows in binary format. Use SCP or SFTP for example.

Then LOAD sample data into your DB2 Linux/Unix/Windows database. Specifiy codepage of origin, e.g. 819 or 237. Also specify optional keywords BINARYNUMERICS and PACKEDDECIMAL to allow loading data in IBM proprietary data formats. If you are using NULL indicators you have to specify as NULLINDCHAR.

Restrictions may exist for CLOB, XML and other ‘advanced’ data types.

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.

“IEB1099I – IEBCOPY is not APF authorized” is issued during execution of stored procedure

Starting in z/OS V1R13, IEBCOPY is no longer APF-authorized. It does not need to be run from an authorized library, and calling programs do not need to be APF-authorized. However, In V1R12 IEBCOPY is APF-authorized.

DB2 9 for z/OS and DB2 10 for z/OS only:
SYSPROC.ADMIN_UPDATE_SYSPARM must run non APF-authorized. However, IEBCOPY prior to z/OS 1.13 is required to be run  from an authorized library, and calling programs need to be APF-authorized.

DB2 10 for z/OS and DB2 11 for z/OS only:
The DB2 subsystem parameters load module must be link-edited with the options AMODE=31 and RMODE=ANY.

APAR number is PM95867 and PTF numbers are …

  • DB2 9: UK98366
  • DB2 10: UK98347
  • DB2 11: UK98365

For more information click here (IBM nov. 5th 2013, IEB1099I IEBCOPY is not APF authorized is issued during execution of stored procedure).

Product Lifecycle for DB2 and IMS Tools

IBM provides “The IBM DB2 and IMS Tools Product Lifecycle matrix” to  display the marketing and support services available over the life of z/OS-based products. You can click the dates that are listed to go directly to the product announcement letter. While every effort is made to provide accurate information, the authoritative source for product information is the IBM announcement letters.

See Product Lifecycle for DB2 and IMS Tools for more details.

For products that are not listed in the Product Lifecycle matrix below or for additional IBM Software product lifecycle information that is licensed under the International Program License Agreement (IPLA), see IBM Software Support Lifecycle.

Documents of the 2012′s BMC DB2 and Mainview User Meeting

Find below the free documents of the annual BMC DB2 and Mainview User Meeting in Munich, June 2012.

The Evolution of the Mainframe: Meeting the Business Requirements of the Future
Nick Pachnos, BMC Software
DB2 Track:
Mainview for DB2 10.1
Peter Plevka, BMC Software
MIPS Aufrüstung vermeiden
Hubertus Beucke, Beucke Unternehmensberatung
DB2 Backup and Recovery – Features you should already be exploiting
Ken McDonald, BMC Software
TRANSFORM your schema changes the fastest way possible
Chris Düllmann, BMC Software
DB2 V 10.1 NFM for z/OS Migration Project 41 Sysplex Groups, 137 Data Sharing Member
Peter Pätsch, Konrath + Pätsch Consultants
Data Surgery and Data Replication by Log Master for DB2
Ken McDonald, BMC Software
Mainview Track:
How to Monitor the z196
Yves Colliard, YCOS
Reduzierung von Spitzenlast MIPS
Peter Plevka, BMC Software
MVSRM – More than Stop-X37
Josef Domes, BMC Software
BMC Mainview Console Management for zEnterprise (aka IOConcepts)
Axel Griepenstroh, BMC Software
Mainview Roadmap
Jürgen Hofmann, BMC Software


CICS and MQ Explorer

IBM CICS Explorer: Common, intuitive, Eclipse-based environment for architects, developers, administrators, system programmers, and operators.  Looking for new ways to accelerate the transfer of knowledge, skills, and best practice to the next generation of technical staff/experts? Need to maintain productivity and protect service-levels? CICS Explorer and System z lead the way to platform simplification.


IBM CICS Explorer Quick Reference

IBM’s MQ Explorer is a free graphical configuration tool built on Eclipse which enables you to remotely explore and configure all WebSphere MQ objects and resources, including Java Message Service (JMS), and publish and subscribe. MQ Explorer can remotely connect to queue managers on any supported platform – enabling your entire messaging backbone to be viewed, explored and altered from one place. MQ Explorer runs on Windows and Linux (x86 and x86_64) systems. It does not need to be deployed with a WebSphere MQ client or server, and can be installed on as many machines as you require.