db2zos (4)

By James Gill


A long time ago (in a galaxy far, far away), I began this series with the intention of blogging about using Jenkins to orchestrate some tasks on z/OS. I did an introduction to Jenkins and one on groovy pipelines


In this blog post, we’re going to look at what we need to do to run a Jenkins node on z/OS. It should be noted that this runs as a process in USS, and we’re going to assume that you’re comfortable there. In many ways, this is a regular Posix Unix environment, albeit with extensions to reflect the fact that we’re running as part of z/OS.

Read the blog in full.



Read more…

In DB2 12 for z/OS, DRDA Applications and Application Compatibility Part Two Gareth Copplestone-Jones provides guidance on the implementation of server-side configuration.

Server-side configuration

When considering how to manage managing Application Compatibility – APPLCOMPAT – for your distributed applications which use the NULLID packages, the main alternative to client-side configuration (discussed in the previous article) is server-side or DB2-side configuration. Although not without its challenges, the advantage of server-side configuration is that much of the necessary configuration is done in one place, using system profiles. Continue reading part two


Read more…


This, the first of two articles on how to manage the Application Compatibility level for DRDA applications, provides an introduction to the subject and considers two of the ways of doing this. In the second article Gareth Copplestone-Jones will concentrate on perhaps the most promising method and discusses its drawbacks.

A very brief history of Application Compatibility

With the release of DB2 11 for z/OS, IBM introduced Application Compatibility, which is intended to make migration from one DB2 release to another less burdensome by separating system migration from application migration, and by allowing you to migrate applications individually once system migration has completed. Application migration is managed using two controls: the APPLCOMPAT BIND option, with a default option provided by the APPLCOMPAT system parameter; and the CURRENT APPLICATION COMPATIBILITY special register.

The original announcement was that DB2 11 would support the SQL DML syntax and behaviour of both DB2 10 and DB2 11, and that DB2 12 would support that of all three. Then along came DB2 12 with Continuous Delivery and Function Levels.

Application Compatibility was extended in DB2 12 in two ways: to support function levels as well as release levels; and to support SQL DDL and DCL as well as DML. It still supports an Application Compatibility setting of V10R1.

One of the big practical issues with Application Compatibility has always been how to manage dynamic SQL packages, and in particular how to manage the NULLID packages used by DRDA clients connecting via DB2 Connect or the IBM data server clients and drivers. That’s what this article is about. Continue reading



Read more…

Triton Consulting, the UK's largest independent information management consultancy, is delighted to announce that two of its Directors have been invited to speak at the prestigious IDUG DB2 Technical Conference in Berlin, Germany, in November this year.

Taking place between the 4th and 9th of November, IDUG is described as 'the foremost independent, user-driven community that provides a direct channel to thousands of professional DB2 users across the globe'. There will be a comprehensive programme of technical education sessions throughout the week: Triton's Julian Stuhler, Director/Head of Solutions Delivery and Paul Stoker, Sales and Marketing Director, will be bringing their respective areas of expertise to the delegates.

Julian Stuhler

On Tuesday 6th November at 2.15pm Julian, a previous IDUG Board Director and Past President, will present 'Memory Management In DB2 10 For z/OS'. He explains that 'with the advent of DB2 10 for z/OS, users are finally freed of the DBM1 virtual storage constraints that have been such a limiting factor for DB2 for z/OS scalability. Now the focus has to move from virtual to real memory management in order to maintain system performance and availability.' Julian will be looking at the major storage-related changes introduced by DB2 10 and providing practical advice on what and how to monitor in a DB2 10 for z/OS environment.

The presentation is aimed at Database Administrators and Systems Programmers with intermediate experience.

Julian is a Principal Consultant with Triton Consulting and has over 24 years' relational database experience. He possesses practical knowledge in many aspects of the IBM Information Management portfolio, including experience in application programming, database administration, technical architecture, performance tuning and systems programming. In 1999, Julian was invited to join the IBM Gold Consultants programme, used to recognise the contributions and influence of the world's 100 leading database consultants. In May 2008, Julian was recognised as one of IBM's inaugural Data Champions - acknowledging individuals with outstanding contributions to the data management community.

Julian is an IBM Redbook author and won the Best Overall Speaker award at the 2000 International DB2 User Group meeting. He has lectured widely on DB2 subjects throughout Europe and the US - his presentation in Berlin should not be missed.

Paul Stoker

On Thursday 8th November at 9.45am Paul will showcase 'Mission Impossible: Improving DB2 Scalability, Availability AND performance While Doubling Workload'. As the lead DB2 DBA for the Digital Banking Division of a large UK-based retail bank, Paul describes that 'in a recent project, the task of dramatically improving scalability and availability of a DB2 z/OS hosted 24 by 7 internet banking application was demanding enough, within a one year timeframe. The additional complexity of a doubling in transaction and customer numbers, whilst maintaining performance, made this an even more challenging assignment.' Paul will be sharing his experience of working on the project, discussing design, strategy and implementation, including Data Sharing, high insert performance and dynamic workload balancing'.

The presentation is aimed at Database Administrators and Systems Programmers at beginner and intermediate levels.

Paul is also a Principal Consultant with Triton Consulting and has worked with DB2, predominantly on the mainframe platform, for over 20 years. Paul's sectors of expertise include banking, insurance, central Government and telecoms. His roles have included Infrastructure Architect, Physical Data Modeller, Development DBA, Performance Tuning Specialist, System Programmer and Product DBA.

Click here for more information on the IDUG DB2 Technical Conference or alternatively, to register as a delegate click here. Triton's homepage can be found at http://www.triton.co.uk where you can find more information about the many areas of DB2 expertise provided by Triton Consulting.

Read more…

astorino_steven: Read my new blog post: Learn how to kickstart your data fabric initiatives with new Express and Quickstart offerings. Address your most pressing pain points first – and expand your data fabric capabilities as and when needed. #DataFabric #IBM #AI

astorino_steven: Our flexible and fast AI-powered #PlanningAnalytics solution forecasts accuracy and consistency allowing businesses real-time insights - without the spreadsheet. IBM Planning Analytics is now available as a Service on AWS. #IBM #BusinessAnalytics #AWS

astorino_steven: #DataGovernance is an important step in any organization’s data strategy. Establishing policies, procedures, and standards for managing data ensures that data is being used in a way that is consistent with the businesses goals and values. #Data #IBM