Featured Posts (99)

Sort by

By Sowmya Kameswaran and Jens Müller


As we all know, Db2 for z/OS has one of the largest footprints in the enterprise database world. Your organization may have all or most of its' business critical data on Db2 for z/OS (you are not alone and we wouldn't recommend you to change a thing about that!). We realize though that many organizations are experimenting with or, rearchitecting and extending their infrastructure to take advantage of hybrid cloud.
With the changing environment and importance of hybrid cloud, cloud-based applications need easy, secure access to this data for modern applications. IBM Db2 Data Gate for z/OS makes data from Db2 for z/OS readily accessible on the IBM Cloud Pak for Data platform for business users and application developers.
As-is scenario
We have embarked on an exciting era of compelling modern application development. There is a surge in both reporting applications requiring read-only access to transactional data as well as data-intensive analytics applications requiring access to historical data. Organizations are developing new compelling applications for differentiating services delivered to their customers. Since much of this data originates in Db2 for z/OS, many organizations have built custom ETL (extract, transform, load) jobs to extract and load this data into other databases to support their application needs. While this approach may work in the short term, some of the problems with this approach are:
  1. Expensive to create and maintain over the course of time (due to complexity, and the costs of synchronizing source and target databases, and ensuring transactional consistency if necessary)
  2. Data security concerns once data is moved from where it originates
  3. Increased operational processes and cost on IBM Z
Why Db2 Data Gate
  • It is an integrated solution to securely access data from Db2 for z/OS on the cloud without the need for direct access to Db2 for z/OS.
  • Avoids significant investment in building and maintaining custom ETL solutions to move Db2 for z/OS data.
  • Provides better data currency via the Integrated Synchronization feature that replicates data from Db2 for z/OS to IBM Cloud Pak for Data.
  • Significantly reduces (operation) cost of data replication on mainframe since 96 % of the underlying data synchronization technology is zIIP eligible.
  • Enables modernization and transformation in your enterprise's Journey to Cloud.
  • With Integrated Synchronization, the data availability for applications accessing data from the source is not affected (source tables are fully online for reading and writing) while data is replicated to the target.
  • HA/DR is built directly into IBM Cloud Pak for Data 


Architecture highlights



Db2 Data Gate is based on Db2 (row store) or Db2 Warehouse (column store) as the target databases within IBM Cloud Pak for Data. This model makes it suitable for supporting  applications that require row level access  as well as analytical applications that benefit from column based data store. Only one Db2 for z/OS database can be used as the data source. The key aspect of the architecture is the Integrated Synchronization feature which is optimized to replicate data from Db2 for z/OS to Db2 running under IBM Cloud Pak for Data.
With Db2 Data Gate and the target database running on the IBM Cloud Pak for Data platform, the solution works wherever the platform is able to run – private, public or hybrid cloud implementations, thus making relevant data readily available to application developers and business users where they need it.
Lab performance benchmarks
Db2 Data Gate boasts unrivaled performance when compared to any other data synchronization tool synchronizing data from Db2 for z/OS to Db2 (Warehouse).
With IBM Cloud Pak for Data and Db2 Data Gate installed on Linux on IBM Z, using Db2 Warehouse as the target database using hostPath data storage:
  • Peak load performance (for making initial copy): 2.1 TB/h
  • Peak synchronization performance: 200k rows/sec at 1.2 secs peak latency
Db2 Data Gate does not:
  • Replace traditional transactional systems since it only provides read-only data access to source data
  • Serve as a replacement for other data replication technologies because it supports only one source and one target and also does not support bidirectional replication or data transformation
  • Support data versioning and hence is not an operational data store
  • Guarantee data currency for high-volume transactional workloads. It is not a carbon copy of source data. Meaning, applications requiring absolute currency should access data at its point of origin.
User Interface snapshots
Db2 Data Gate provisioning
Select the target database type and deployment, resource allocation and network routing to proceed with creation of the Db2 Data Gate instance.
Setting up source
Once the instance is created, the first step is to point the Db2 Data Gate instance to the Db2 for z/OS subsystem to be used as data source.
Select and add tables from source to target
The next step is to select the tables to synchronize data from source to target.
Db2 Data Gate dashboard
Overview of status and activities associated with the provisioned Db2 Data Gate instance.
Db2 Data Gate in action
The video below demonstrates the Db2 Data Gate end user experience. One of the key aspects to note is that when the source tables are added, loaded and setup for synchronization with Db2 Data Gate, there is no impact to concurrent workloads executing on the source tables. The source tables are fully online for reading and writing while Db2 Data Gate makes the copy and starts synchronizing.
Our next blog ...
Next time we will look at Db2 for z/OS Data Gate and Watson Knowledge Catalog integration.
Read more…

REGISTER NOW starting at 11am EST 4pm UK
Live Webcast 21st September 11:00 AM EST live Q&A panel
Title: Get ready for Vnext - become AI enterprise!

Get a sneak preview into what around the corner in the World of Db2, and get a head-start for planning your migration to Db2 VNext. This is an event you do not want to miss. 
IBM Db2 for z/OS is investing for leadership in the AI, cloud, and analytics era, extending our Z platform heritage of 24x7 availability, security, scalability & performance, while simplifying & modernizing to maintain Db2 as a top choice for next-gen IT professionals without requiring deep Z skills. This webcast will provide guidance on how to ensure that you get a head-start and are ready to upgrade to Db2 Vnext 

Cris Molaro - IBM Gold Consultant will be giving an independent user view regarding challenges clients are facing during the current technological industry trends. 

#db2z #ai #scalability #cloud #security #analytics #IDUG #Db212#machinelearning #agile #automation #ibm #IBMZ #innovation #event

Read more…

DB2 on Apple Silicon

By James Cockayne

Apple’s Macs have been a popular development platform for many years now, but IBM have never really committed to supporting DB2 servers on macOS it seems.  There was a version of DB2 Express-c v9.7 made available some years ago, but it was lacking features and is obviously way too far out of date to consider these days.  A useful solution was to run Docker containers, or full virtual machines with Linux or Windows to make DB2 available locally, but the switch to the new Apple Silicon processors, or the M1 chip, means the Mac now uses the ARM64 instruction set rather than sharing the Intel/AMD x86-64 processors common to Windows and Linux platforms – and there is no option to download a copy of DB2 that runs on this processor.

So is that the end of having DB2 installed locally?  Not quite.

Click to continue reading


Read more…

Check out this new "Complimentary" Db2 AI for z/OS Version 1.4 Red paper Installation and Configuration

Learn More



Artificial intelligence (AI) enables computers and machines to mimic the perception, learning, problem-solving, and decision-making capabilities of the human mind. AI development is made possible by the availability of large amounts of data and the corresponding development and wide availability of computer systems that can process all that data faster and more accurately than humans can.

What happens if you infuse AI with a world-class database management system, such as IBM Db2®? IBM® has done just that with Db2 AI for z/OS (Db2ZAI).
Db2ZAI is built to infuse AI and data science to assist businesses in the use of AI to develop applications more easily. With Db2ZAI, the following benefits are realized:

  • Data science functionality
  • Better built applications
  • Improved database performance (and DBA’s time and efforts are saved) through simplification and automation of error reporting and routine tasks
  • Machine learning (ML) optimizer to improve query access paths and reduce the need for manual tuning and query optimization
  • Integrated data access that makes data available from various vendors including private cloud providers.

This IBM Redpaper® publication helps to simplify your installation by tailoring and configuration of Db2 AI for z/OS®. It was written for system programmers, system administrators, and database administrators.

Table of contents

Chapter 1. Architectural overview
Chapter 2. Road map for planning to installing
Chapter 3. Planning
Chapter 4. Security and configuration considerations
Chapter 5. Installation, customization, and configuration
Chapter 6. Administration and maintenance

Read more…

Db2 for z/OS and JSON

I wrote a very short story about using the JSON/SQL support in Db2 for z/OS. I also wrote an introduction to JSON support in Db2 for z/OS article for IDUG.

The story and link to the IDUG article is here:

This is a direct link to the IDUG article, but you need an IDUG login account (which is free).

Read more…

Live Db2 12 Client Panel 30th June 2021 - Sign Up today!




Db2 for z/OS is the strategic enterprise database that has evolved and adapted to meet client needs for over 35 years. John Campbell IBM Distinguished Engineer has been one of key developers from IBM Silicon Valley Lab that has been extremely influential in driving some of the innovation around the core strengths and business value of Db2 for z/OS.

We are bringing together some of our Db2 for z/OS clients so that they can share some of their "use cases" and experiences around Db2 12 upgrade journey and discuss how they are exploiting, planning to exploit the new technology to leverage  their Db2 for z/OS data to gain data insights and drive competitive business advantages.

Register Now to join this Db2 for z/OS client panel where John will host a live interaction panel with some of our clients that have traveled this journey with IBM.

Read more…

IBM Watson Machine Learning for z/OS 2.3 and IBM Db2 AI for z/OS 1.4 enhancements boost functionality, performance, usability, and simplify deployment

IBM Extends Industry-Leading Enterprise AI

Announcing Watson Machine Learning for z/OS 2.3 and Db2 AI for z/OS 1.4


IBM Z continues to deliver AI innovation to help customers take the greatest advantage of their mainframe application infrastructure and data with enhancements to Watson Machine Learning for z/OS and Db2 AI for z/OS.


Read the Announcement Letter  


IBM Watson Machine Learning for z/OS 2.3

IBM Watson Machine Learning for z/OS (WMLz) 2.3 is the enterprise machine learning platform on IBM Z. It enables organizations to build, deploy, and operationalize machine learning models for in-transaction AI and real-time insights.


The latest release, WMLz 2.3, is designed to significantly improve online scoring service performance for various types of machine learning models, especially for deep learning models in Open Neural Network Exchange (ONNX) format. It also includes enhancements for integration with IBM Cloud Pak for Data, installation, configuration simplification, and usability of WMLz base services, and a WMLz model Integrated Development Environment.


Also, look for the new IBM WMLz 2.3 Online Scoring Community Edition coming soon -- a lightweight version that provides a no-charge option for clients to try out the streamlined up-and-running WMLz model inferencing, in-transaction approach.


Learn more about Watson Machine Learning for z/OS


IBM Db2 AI for z/O 1.4

IBM is also announcing IBM Db2 AI for z/O 1.4 (Db2ZAI), a separately licensed product, that uses machine learning to improve the operational performance of Db2 for z/OS systems. It is built on the services that are provided by IBM WMLz to help optimize performance. Db2ZAI 1.4 includes the following enhancements:


  • Enterprise readiness, including simplified migration and high-availability management
  • System Assessment graph drill-down, which provides correlation from System Assessment exceptions to potential candidate SQL
  • Enhanced Distributed Connection Control visualization for historical trend analysis and improved profile management
  • SQL Optimization Value Dashboard, which provides a progress report that demonstrates the value provided by Db2 AI for z/OS SQL Optimization


Learn more about Db2 AI for z/OS

Join the Launch Webcast: What’s new in Db2 AI for z/OS and Watson Machine Learning for z/OS

Register at https://ibm.biz/BdffvM  This live webcast will take place on June 1, 2021 from 11:00 am–12:00 pm ET with a panel of IBM experts that will share the latest on the new releases of  IBM Watson Machine Learning for z/OS and IBM Db2 AI for z/OS.


Speakers include :


Erika Adkins

Db2 for z/OS Program Director, IBM Silicon Valley Lab

Catherine Wu

Head of Development, Data and AI,  IBM China Lab

Eberhard Hechler

Executive Architect, Data and AI, IBM Germany R&D Lab


Read more…

The IBM Enterprise Data & AI Virtual Symposium is HERE

REGISTER NOW  https://ibm.biz/DTS27thApril2021 

Join the live client panel and hear directly from our customers, see how data originating on IBM Z is accelerating the "AI Journey" for enterprises.

#IBMZ #Mainframe #AI #DATA #Analytics #cloudadoption  #machinelearning#deeplearning #dataanalytics #event #ibmcloud #digitaltransformation#artificialintelligence #ml #bigdata #Db2z #Db212 #deeplearning



Read more…
When:  Apr 27, 2021 from 10:00 AM to 12:00 PM (ET)


Successful digital transformation demands integration between your AI and hybrid cloud strategy – with data at the core. This symposium will feature Tom Davenport who will share his insight on the role of AI and the new mandate to drive return on investment. 

IBM technology helps drive intelligent, efficient data serving for modern applications, real-time analytics from data at the point of origin and AI embedded transactions for insight when milli-seconds matter. This will be an event you do not want to miss! 

Keynote Tom Davenport - Return on AI:  The New Necessity 

Tom Davenport is an American academic and world’s top selling author specializing in analytics, business process innovation, knowledge management, and artificial intelligence. He has also been named one of the top three business/technology analysts in the world and one of the 100 most influential people in the IT industry. He earned his Ph D from Harvard University and has taught at the Harvard Business School, MIT and the University of Chicago, the Tuck School of Business.


Infuse Data, AI and ML into your core business processes for actionable insight - Sam Buhler, IBM Director, Offering Management

Keeping pace today requires that IT organizations think differently about how to leverage and modernize existing resources to drive change and innovation. With all the hype around new technology, cloud platforms and development approaches, you might be wondering how IBM Z and the transactional data that resides on it fit into this changing landscape. The optimal position for today’s IT organization is to be a full-fledged partner with lines of business to drive revenue and deliver on an organization’s strategy but IT organizations need to modernize. 

Client Experiences on Data, AI, Analytics & Db2 for z/OS - Tom Ramey, IBM Director, Data & AI            

Tom will lead a discussion around key use cases involving Db2 for z/OS data.  This will cover how IBM clients are leveraging data, AI, Analytics, Machine Learning, DevOps Hybrid Cloud and more to drive a competitive advantage. 

Followed by Live Q&A with all our presenters

This will be an event you do not want to miss! 

Read more…

Register Now for this double Db2 for z/OS webcast which will be hosted by John Campbell and Frances Villafuerte


Title: Achieving Optimal Availability, Usability and Performance with Universal Table Space - Part 1 & PART 2 

Date: Tuesday, May 11, 2021  and Wednesday, May 12, 2021

Time: 11:00 AM Eastern Daylight Time

Duration: 1 hour, 15 minutes

Achieving Optimal Availability, Usability and Performance with Universal Table Space  -  Part 1 & 2 
In this two part webcast, John Campbell and Frances Villafuerte will introduce and discuss the various types of Universal Table Space type, and provide various hints and tips on how to best use and exploit Universal Table Space. In the second part of this webcast, John and Frances will discuss specifically discuss the performance impact of Universal Table Space, a case study on common PBG UTS INSERT performance issues and possible solutions, the insert space search algorithm for INSERT,  INSERT with APPEND, INSERT Algorithm 2 and index performance using FTB.


Read more…

Business and Technical Value of Top Ten Features in Db2 12 for z/OS Continuous Delivery
Register NOW

Date: Tuesday, March 23, 2021

Time: 11:00 AM Eastern Daylight Time

Duration: 1 hour, 15 minutes


One of the most valuable resources for modern businesses is business critical data.  Data can be used to provide insight into every facet of the business from operations to market trends. Powerful data enables effective and efficient business decision making and your enterprise  data is only as powerful as your ability to harness it. Storing, analyzing, and managing data in today's world is a enormous undertaking as the amount of data continues to explode.  

Everyone knows that Db2 12 introduced a continuous delivery model so that we can be more responsive to our clients' needs. As a result we have delivered over 100 new enhancements in the maintenance stream to date including many features that increase availability, scalability and performance, and address the future of mobile and cloud computing.

Now with the prospect of Apollo on the horizon, Haakon Roberts, IBM Distinguished Engineer,  and Sowmya Kameswaran, Db2 Technical Lead,  will take a look at what has been achieved and what are generally considered to be some of the most important new features delivered in this timeframe and why they should matter to you.

Objective of Webcast

The objective of this webcast is to ensure Db2 for z/OS users are :-

  • Aware of the new Db212 features and functions since General Availability
  • Understand how they are addressing  the changing needs of enterprise clients
Haakon Roberts
IBM Distinguished Engineer, Db2 for z/OS Development.

Haakon Roberts has nearly 30 years' experience working with DB2 on the mainframe platform covering various aspects of systems programming, database administration, software support and development. He is a Distinguished Engineer at the IBM Silicon Valley Laboratory in San Jose, California, the chief technical architect for DB2 for z/OS Utilities and Tools, and a leading expert in data integrity, availability and problem resolution. He is a regular speaker on these and other topics.

Sowmya Kameswaran
Db2 technical lead for user experience and transformation

Sowmya Kameswaran works at the IBM Silicon Valley Labs in San Jose California and leads the User Experience modernization for Db2z platform and ecosystem. Understanding the way users interact with the system and building interfaces to provide the best user experience is what she enjoys to do. Being hands-on into software development helps her go end to end from understanding the kind of experience customers need to getting it built.

Read more…

Check out IBM Db2 for z/OS 2021 Complimentary Webcasts.
One click Registration

Register Now and gain complimentary access to all replays and webcast resources available for 12 months.

Title: Db2 12 delivering business agility and transforming enterprises

Date: Tuesday, March 16, 2021   Time: 11:00 AM Eastern Daylight Time

Speakers: Julian Stuhler  IBM Gold Consultant  Triton Consulting   and  Sueli Almeida  IBM Db2 for z/OS Development

9524611469?profile=originalREGISTER NOW

Title: Business & Technical Value of Top Ten Features in Db2 12 for z/OS Continuous Delivery

Date: Tuesday, March 23, 2021  Time: 11:00 AM Eastern Daylight Time

Speakers : Haakon Roberts  IBM Distinguished Engineer, Sowmya Kameswaran  IBM Db2 technical lead for user experience and transformation



Title: Achieving Optimal Availability, Usability and Performance with Universal Table Space - Part 1 & PART 2 

Date: Tuesday, May 11 and 12 2021   Time: 11:00 AM Eastern Daylight Time

Speakers: John Campbell  IBM Distinguished Engineer   

Frances Villafuerte  Senior Software Engineer  



Check out Webcast Portal

Read more…

Learn How Db2 12 is delivering business agility and transforming enterprises in the digital era!

Date: 16th March 2021

Time 11:00 AM Eastern Time Zone

PS: This will be available on replay however you must register to secure your access to the replay. Click Here


Db2 for z/OS: The Evolution Engine - Julian Stuhler

For over 35 years, Db2 for z/OS has been the engine at the heart of many of the critical applications that run the world around us. From internet banking transactions to airline reservations and insurance quotations, Db2 for z/OS continues to power a huge array of today’s high volume, mission-critical enterprise applications. But how has Db2 remained so relevant given the huge technology changes that we’ve seen in the past 4 decades? This presentation will show how Db2 continues to evolve to meet the challenges of today’s (and tomorrow’s) applications, while the product’s core strengths of efficiency, resilience and openness remain as critical today as they have always been.

Following Julian, Maria Sueli from the IBM Development Lab will share with you how you can remove barriers that are holding your Db2 enterprise data captive in outdated methods and processes.  She will demonstrate how Db2 for z/OS application developers can create, change and destroy a development/test sandbox using self-service facilities. She will also demonstrate how through exploitation of APIs; application developers can be empowered with self-service capabilities that adhere to and follow established business rules set by the Db2 Database Administrator.

Objective of Webcast 

This is a great opportunity to learn how Db2 12 is evolving and responding to client's needs when it comes to changing data management requirements. 

Target Audience:
IT Decision Makers, DBA, App Dev, IT Architects, IT Engineers

Julian Stuhler  IBM Gold Consultant Triton Consulting

Julian has over 30 years of Db2 for z/OS experience in application programming, database administration, technical architecture, performance tuning and systems programming. More recently, he has specialised in the implementation of DevOps practices within enterprise mainframe customers. He is an IBM Redbook author and regularly produces White Papers and other IBM publications covering new Db2 releases. In 1999 Julian was invited to join the IBM Gold Consultants program, 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 – a program to recognise individuals for outstanding contributions to the data management community. He has been re-nominated each year since then.

Sueli Almeida  IBM Db2 for z/OS Development

M. Sueli Almeida is an IBM Certified Thought Leader and member of Db2 for z/OS development located at the IBM Silicon Valley Lab in San Jose, California. She has extensive experience with DB2, including database administration and systems programming. She has worked on DB2 for z/OS advanced technology and solution integration, such as Java support, its integration with WebSphere product family. Currently working on Db2 for z/OS support for Cloud provisioning Database-as-a-Services for sysprogs, DBAs and application developers/architects.

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…

Get a head start by registering for this *NEW* Db2 12 Technical workshop, Hosted by John Campbell - IBM DE and Anthony Ciabattoni from the IBM Db2 SWAT Team.

Secure your seats today http://ibm.biz/Db212TechnicalWorkshop

Feb 9th and 10th 2021

#db212  #Db2 #AI #Data #Analytics #ML #Hybrid

John Campbell and Anthony Ciabattoni

John Campbell    and  Anthony Ciabatton9524610056?profile=original



Read more…

With all the hype around new technology, cloud platforms and development approaches, you might be wondering how IBM Z and the transactional data that resides on it fit into this changing landscape. Read the new IBM Z e-Book

The optimal position for today’s IT organization is to be a full-fledged partner with lines of business to drive revenue and deliver on an organization’s strategy. IT organizations need to modernize. This means there is an opportunity for your organization to bring IBM Z into your broader hybrid cloud approach.

Many organizations say they want to modernize and transform. To transform requires agility and agility is a continuous process. You need technology that can continuously adapt to new business requirements and IT methodology. 


IBM Z has proven to be adaptable throughout its history and continues to introduce new capabilities to support your most critical engagement, analytics and AI applications. That includes support for your hybrid cloud infrastructure.  New capabilities demonstrate that, just like you, IBM is continuing to invest in IBM Z  -- a vibrant, adaptable platform that you can depend on to differentiate your organization.


IBM Z is the most resilient platform available for your core transactional systems and now offers integration with IBM Cloud Pak for Data™, IBM’s strategic platform for Data and AI. This integration means you can readily take advantage of your IBM Z data and resources as part of an integrated data and AI platform to modernize the way you collect, organize and analyze data and infuse AI throughout your organization.


Your IBM Z infrastructure investment holds significant value and can help your organization deliver continued business differentiation. Some may say that IBM Z and hybrid cloud is an unconventional combination. However, to paraphrase John Maynard Keynes, to succeed, sometimes it is necessary to do so unconventionally rather than be like everyone else and perform conventionally. IBM understands this and offers the differentiated organization a differentiated set of platforms.


I welcome you to read a new e-Book:  Leveraging IBM Z for a hybrid cloud world to learn how IBM Z IBM Z and IBM Cloud Pak for Data can complement and extend your existing and future hybrid cloud environment.


Read more…

Register for DB2 for z/OS technical sessions at Data & AI on IBM Z Technical Symposium

IBM will be hosting this complimentary virtual event to learn how you can use IBM Z data for modern engagement, analytics and AI applications to become truly insights-driven. We have 3 great Db2 for z/OS sessions. Register Now




Read more…

By Dorothy Lin and Paul McWilliams.

Db2 for z/OS development is now offering two Db2 for z/OS Advanced Class sessions for 2020—previously scheduled  at IBM Hursely and IBM Silicon Valley Laboratory—as virtual courses. Update: Due to the impact of the global pandemic and resulting travel restrictions, the cost for this course is reduced to $2000.

As before, the invitation-only virtual Db2 Advanced Class sessions are
led by IBM Distinguished Engineer John Campbell, for clients who are advanced Db2 for z/OS system or database administrators with the following certifications or equivalent experience:
  • IBM Certified System Administrator - Db2 for z/OS
  • IBM Certified Database Administrator - Db2 for z/OS

John will share proven best practices to exploit the full power of Db2 for z/OS and IBM Z mainframes, and he will provide a deep dive on how to monitor and tune Db2 for z/OS system and transaction performance using Db2 Statistics and Accounting traces. For more details of the subjects covered in the course, see the curriculum section below.

Clients who take part in this Db2 Advanced Class will be able to participate in the following:

  • Small virtual class size - for a more intimate learning experience
  • Virtual interactions with the Db2 for z/OS Development SWAT team - partner with SWAT team members in smaller, personal groups
  • Networking - build lasting relationships with other clients who understand the power of Db2 for z/OS

Schedule: Just two sessions are offered for 2020:

  • Monday, June 22, 2020, (9 am GMT+1) to Friday, June 26, 2020, (2:30 pm)
  • Monday, September 28, 2020, (8:30 am GMT-7) to Friday, October 2, 2020 (2:30 pm)

Cost: $2000 USD per client participant

If you are a client who is interested in attending this class, fill in and submit the application form. Applications will be reviewed and acceptance notices will be emailed. A registration link with payment instructions will be included in the invitation.

For more details and the full curriculum list, see our Db2 for z/OS News from the Lab blog entry.

To always get the latest news about Db2 for z/OS from the IBM lab, sign in and subscribe at: http://ibm.biz/db2znews-subscribe

Read more…

Extending the Value of Mainframe Data

 The vast majority of Fortune 500 companies hold large amounts of critical business data on the mainframe.  Much of this may be stored in relational structures on Db2 for z/OS.  However, there is also a wealth of data stored on non-relational mainframe data sources such as Adabas, IMS, IDMS, VSAM,  and flat files.   Take as an example a bank ATM application, or airline reservation system which may be IMS based.  IMS being a hierarchical vs. relational data store.  This data can be extremely valuable for doing customer analytics.  It has proven to be a challenge to combine all these different data sources using traditional mainframe applications.  Now, add to this the plethora of new data sources being structured, non-structured, on premises, cloud, etc and the challenge can become exponential.  In the past companies have attempted to build data warehouses combining all this data into a single location.  However, the tremendous volumes of data being generated today make the traditional ETL processes too costly and slow.  In order for companies today to gain a competitive advantage they must be able to leverage all these disparate data sources for real-time analysis.  Things like modern business analytics, 360 customer views, and mobile apps cannot afford to have potentially stale data.

Modern applications such as online-shopping, banking, etc are primarily API based.  Leveraging mainframe data in these new applications has been a challenge due to the incompatible formats.  It typically requires costly ETL processes in order to get the data into a recognizable format.  Add to this, the typical programmer today has little or no experience with mainframe can make this an insurmountable task.

Virtualization can be the solution

IBM’s Data Virtualization Manager for z/OS is the only data virtualization tool that runs on the mainframe.  Data Virtualization can make mainframe data much more consumable by providing an abstraction layer that provides real-time read-write access to non-relational mainframe data sources without requiring any mainframe skills.  DVM supports modern APIs such as web services, REST, HTTP, and SOAP allowing developers to easily access mainframe data and join it with other data sources.


IBM Data Virtualization Manager for z/OS architecture

View this short video for a more in-depth understanding of DVM architecture.

Data Virtualization Studio

DVM provides an Eclipse based UI called Data Virtualization Studio.  This interface allows both main-frame and non-framers to easily create virtual tables from non-relational data sources. 


It will also allow the developers to generate code snippets in a broad range of APIs and interfaces:


Easily build virtual views which can join your z/OS data sources with other non-mainframe data sources such as Hadoop, Mongo, Oracle, Db2 LUW, Informix plus much more. 

Click this link for a walkthrough of the Data Virtualization Studio.  you will get experience with the following features:

  • Learn how to define virtual tables
  • Learn how to query virtual tables
  • Learn how to embed virtual tables in application code
  • Learn how to use virtual tables with web services
  • Create views using virtual tables


Extending IBM Cloud Pak for Data to the Mainframe

Cloud Pak for Data provides data virtualization for many data sources both relational and non-relational.  Cloud Pak for data runs on a Red Hat OpenShift cluster either on-premise or in the cloud of your choice (IBM Cloud, AWS, Microsft Azure, or Google Cloud). 

Until recently Cloud Pak for Data’s mainframe data was limited to Db2 for z/OS.  DVM is now integrated into Cloud Pak for Data, opening the door to all the other mainframe data sources.  This was a missing link for doing deep analytics that can leverage all this valuable business data.  Developers now have transparent access to non-relational z/OS data sources with the added benefit of Cloud Pak’s collaboration and governance capabilities.  View this video for a brief overview of CP4D’s data virtualization capabilities.

Read more…