Featured Posts (113)

Sort by

By Mark Gillis

In his new blog, Mark Gillis explores how to modify queries on the fly using Jupyter Notebook, widgets and interactive SQL.  

 

OK, fair enough, that does sound a bit specialised and will maybe put some people off. Nothing like a good blast of technobabble to send us scurrying to the coffee machine.

What this is getting at is the ability to modify queries on the fly. It’s one of the reasons I’m quite taken with Jupyter Notebooks; the ability to provide some SQL and to run it, take a look at the result set and then tweak the original SQL and re-run it until you get the output you want.

Read the blog, Jupyter Notebooks, Widgets and Interactive SQL in full. 

 

10817154679?profile=RESIZE_710x

 

Read more…

Announcing hands-on tutorials for the IBM data fabric use cases

Do you wonder how you can reap the benefits of the IBM data fabric? Are you curious about how a data fabric approach resolves typical data analysis challenges? We’ve got you covered! You can get hands-on experience with the IBM data fabric by completing a series of tutorials. These new tutorials provide step-by-step instructions, helpful videos, and sample projects and assets for key data fabric use cases.

10758425053?profile=RESIZE_710x

The data fabric tutorials guide you through a scenario for a fictitious mortgage lender named Golden Bank. Golden Bank implements a data fabric to produce the best results from their data. The integrated data assets and services in the tutorials provide the following benefits:

The data fabric tutorials are beginner level with no-code or low-code requirements. They can be completed in any order. You can complete all of them or just those that interest you. Set aside a few hours to gain hands-on experience with the powerful IBM data fabric tools!

Choose Learn by example on the Cloud Pak for Data as a Service home page to select a data fabric tutorial.

10758425676?profile=RESIZE_400x

 

10758425477?profile=RESIZE_710x
You can sign up for a data fabric trial to work with the use cases for free on Cloud Pak for Data as a Service. For instructions on how to sign up for the data fabric trials and auto-provision the required services, see Signing up for the data fabric trials. New users need to create an IBM Cloud account. Existing IBM Cloud account holders can log in with their IBMid.

For more information about the IBM data fabric approach, see https://www.ibm.com/analytics/data-fabric. 

 

Read more…

The North America Db2 for z/OS Master Class is fast approaching and is scheduled for Monday, September 19, 2022, to Friday September 23, 2022, at the IBM Db2 Silicon Valley Lab. Don’t miss out on the opportunity for a week-long in-person interactive technical learning experienced conducted by the IBM Db2 for z/OS SWAT Team. The course will focus on exploiting the full power of Db2 for z/OS and IBM mainframes, proven best practices, and will share worldwide real customer experiences including the best ways in conquering prevalent challenges. The Db2 SWAT Team will discuss the most common issues related to continuous availability, speed of recovery in Db2 for z/OS environments and provide a deep dive on how to monitor and tune Db2 for z/OS system and transactions for efficient performance. The technical information that will be shared in the course will provide valuable best practices that attendees can implement at their site to help provide the most optimal Db2 experience.

The small class size intimate environment and learning experience will allow attendees to have full access and personal mentoring from the Db2 for z/OS development SWAT Team. In addition, various Db2 developers and management will participate and interact during the week-long course. Attendees will be able to network and develop relationships with other Db2 Master Class participants.

Customer Quote             

“I have been a Db2 DBA for about 20 years, some of the information was absolutely amazing and an absolute eye opener. It was a wonderful experience (although intense :)) and I have learned so much from the massive list of ideas. Having access and interacting with Db2 for z/OS development and management as well as networking with other customers was such a wonderful positive experience.”  

John Campbell Quote 

“I have always wanted to have the Db2 Master Class to be the best Db2 class a customer can attend. Take advantage of this deep learning experience to help run your Db2 installation more efficiently and to achieve higher level of availability.”

For additional information and registration details please see the following blog:

https://community.ibm.com/community/user/hybriddatamanagement/blogs/paul-mcwilliams1/2022/02/03/master-class-2022

 

Sincerely,

Anthony Ciabattoni, IBM Db2 for z/OS Development SWAT Team

Read more…

Congratulations to John Campbell, Db2 for z/OS DE, on his Retirement! Living Db2 Legend!

John Campbell IBM DE for Db2 for z/OS will be retiring from IBM on the 5th of August 2022 after four decades working on IBM Db2 for z/OS. He has been the face of “World of Db2” for decades and I know he will be greatly missed by all of us. 

John started working on Db2 for z/OS Version 1 in the 80's, here is a brief summary of John's career with Db2 for z/OS.  John has worked with many, many Db2 customers, business partners and IBMers over the decades, this is an opportunity for everyone to say goodbye to John before he leaves IBM.

John is a living legend of the Db2 community, especially a familiar face at conferences, World of Db2, IBM and IDUG Events, supported Db2 for z/OS books, Redbooks, whitepapers etc. He will greatly be missed at events, conferences, panels etc 

John has attended and presented at nearly 60 IDUG conferences in North America, EMEA, Australia, South America and India.  He has been voted regularly as the “Top 10 Speaker" on majority of these conferences and been voted “Best "Presenter” at least 3 times and entered the IDUG Speaker Hall of Fame. He has presented many, many Db2 for z/OS webcasts over his career, I have personally worked with John for the past ten years and his webcasts have always achieved up to 1000+ registrations and which is a record for webcasts. 

He has also supported many, many Db2 regional User Groups all over the world.

I know John really wanted an opportunity to meet many of his customers, partners and Db2 family before his retirement and say "goodbye". However, with "Covid Pandemic” it does not look like it is possible, so we have arranged a virtual party.

Check out some of the highlights and memories of the last four decades Click Here

If you have any photos that you would like please upload to this community. Please send your wishes and memories, I will try and print and share in his retirement card. 

10673342488?profile=RESIZE_710x

John started working on Db2 in the 80's as started his career as IBM Systems Engineer. - here is a brief backgrpound of JC's career. JC's words 

  • Technical branch system engineer helping the early customers migrate and exploit Db2 V1R1 thru Db2 V2R3. Helped design and implement major operational and decision support systems.
  • Top system engineer in his IBM System Engineering School.
  • Lead subject matter expert for Db2 in IBM UK Country Technical Support. Major contributor to IBM Redbook projects, and UK and Intentional Conference.
  • Assignment to Db2 Lab in San Jose working as a performance analyst for Db2 V3 and V4. Technical leader in Performance Team for the design and development of Data Sharing and Type 2 Index Manager.
  • Appointed IBM Distinguished Engineer and entry to the IBM Academy of Technology in 2003.
  • Several major IBM Outstanding Technical Achievement Awards including for data sharing.
  • Technical leader of the Db2 Worldwide SWAT Team since 1999.
  • Voted best speaker at multiple major IDUG Conferences around the world, and member of the IDUG Speaker Hall of fame.
  • I hope I will be remembered for my deep technical knowledge, my enthusiasm, customer handling skills, inspiring others, and being generous with my knowledge and time in helping colleagues and customers. Most importantly as the voice of the customer and the voice of reason within Db2 Development.

 

Read more…

Join the IBM team at the IDUG North America 2022 Db2 Tech Conference in Boston on Monday July 11th for a complimentary, action-packed day created by developers, for developers. You'll have the opportunity to learn about Db2's app development and experience hands-on Db2. 

REGISTER FOR DEVELOPER DAY HERE

Date: Monday, July 11th 

10:00 AM - 3:00 PM EST

Where: In person only, Sheraton Boston 39 Dalton Street, The Fens - 5th Floor
Boston Massachusetts

 10628825881?profile=RESIZE_584x

During this time, you'll learn:

  • Training on Db2 platform
  • How to build and deploy a music recognition iOS app with Db2 Warehouse
  • How to build a movie recommendation engine with Db2 ML
  • And much more!

Agenda: 

10:00am: Why Db2
10:15am: How to download, set up, and install Db2
10:45am: Db2 Architecture Overview
11:15am: Building and deploying a music recognition iOS app with Db2 Warehouse
1:00pm: Building a move recommendation engine with Db2 ML

We are looking forward to a wicked awesome time at the IDUG NA22 in Boston, so sign up today to join us!
If you have any questions regarding this course, please email Donna Milano

Read more…

IBM Db2 13 for z/OS – AI Enriched

 

Enriched AI helps to improve operational efficiency and reduce costs.

REGISTER NOW FOR THE LAUNCH WEBCAST

10264629054?profile=RESIZE_710x

As organizations embark on their AI journeys, they face increasingly complex data management challenges – rapid data growth, rising operational costs, spreading siloes of duplicated data, demands for the most current data, faster and more accurate decision making, infusion of AI into their applications and transactions, growing regulatory requirements – all while reducing their security exposures wherever and however their data is stored.

As part of a data and AI solution, organizations are recognizing the value of a data fabric as a data management architecture that can help optimize access to data and intelligently curate and orchestrate it for self-service delivery to data consumers.  A data fabric can help provide faster, trusted AI outcomes by connecting the right data, at the right time, to the right people, from anywhere it’s needed.

Db2 for z/OS has a rich heritage of delivering the necessary qualities of service to address these pains points through its capabilities to:

  • Host and manage the world’s most business critical and up-to-date data.
  • Deliver the highest qualities of service to support modern mission critical AI and hybrid cloud applications.
  • Drive technical and cost efficiencies designed to address the unprecedented demand for secure, reliable, direct access to systems of record data.
  • Revolutionize Db2 management through new simplified experiences, powered by AI.
  • Simplify accessibility to mission critical data without moving or copying data.

 

Announcing IBM Db2 13 and Db2 AI for z/OS (Version 1.5)

Today, IBM announced the general availability of Db2 13 and Db2 AI for z/OS. Db2 13 for z/OS (Db2 13) delivers leading-edge AI innovations and enhancements, reinforcing it as the foundation for enterprise computing within the hybrid cloud and digital world - and a key component within an enterprise’s data fabric.

IBM Db2 delivers significant innovations and capabilities:

  • An innovative integrated approach to developing and deploying AI insights within applications
  • Infusing AI to help improve operational efficiency and reduce costs
  • Enhanced resiliency, efficiency, and application stability for unparalleled availability
  • Synergy with IBM z16 for enhanced efficiency and differentiating business value
  • Simplified database management and upgrades to help accelerate feature adoption and time to value

Db2 AI for z/OS helps organizations infuse AI throughout operations, transactions and applications for improved efficiency and better business outcomes. Here are a few examples:

  • Uses ML and AI to help improve operational performance and maintain the health of Db2 systems
  • Revolutionizes Db2 management through new simplified experiences, providing self-tuning / self-managing capabilities to Db2 for z/OS powered by AI
  • Provides better operational control over Db2 AI for z/OS processing
  • Addresses enterprise security and audit requirements with multifactor authentication
  • Applies intelligent insights using AI to predict and troubleshoot database performance

 SQL AI-Driven Data Insights

Competitive advantage hidden in data relationships can be difficult to identify which can result in missed opportunities for monetization. Traditional machine learning approaches can be effective, but require the right skills to draw out this valuable information and as such these relationships and insights could be completely overlooked unless done properly. Machine learning and data science approaches are often perceived as highly tailored processes requiring customized extract, transform, and model building processes along with additional infrastructure and software, requiring highly specialized data science skills.

IBM software is designed to help automate many of these complex challenges by applying machine learning throughout an organization’s AI journey involving the collection, organization, analysis of data and infusing AI into business processes and applications.

The Db2 for z/OS SQL Data Insights feature simplifies the data science process, helps reduce the time necessary to take advantage of AI, and identifies valuable hidden insight within enterprise data. It offers an innovative integrated approach to developing large-scale AI insights within a relational database for better business decisions. SQL Data Insights extracts exceptional business insight from Db2 for z/OS data through embedded, self-service AI functionality.

Db2 for z/OS provides automated neural network-powered semantic reasoning to identify similarities and correlations between Db2 for z/OS data points and relationships and extrapolate from one concept to another. With SQL Data Insights, customers can incorporate AI functionality within Db2 for z/OS applications and business intelligence (BI) tools to reduce infrastructure complexity, simplify application development, and deliver faster AI time to value.

Some of the key capabilities of SQL Data Insights are:

  • Uncovers data relationships and implicit insights hidden within customers' Db2 for z/OS data through SQL Data Insights AI-enhanced SQL
  • Enables any application, such as customer service and mobile applications, that can access Db2 for z/OS data to use SQL to benefit from AI insights
  • Uses Natural Language Processing to build Artificial Neural Network models on existing Db2 data without requiring data scientist skills
  • Delivers model-based explain capability
  • Exploits IBM z16 optimization to speed up training and query

Readily integrating AI within applications helps identify and monetize hidden insights within the data using SQL Data Insights that would otherwise be overlooked.

Learn More - Check out the Db2 SQL Data Insight Product Demo

AI infused in Db2 for z/OS for improved performance

Db2 for z/OS infused AI helps reduce staff costs and enhances application performance. It learns the patterns from the collected data from workloads in customers' unique operating environments and determines the optimal paths for SQL statements entering Db2 for z/OS. Infused AI technology reduces the need for data scientist support.

These AI capabilities help to better serve business and technical insights with improved support for application growth and performance with smarter insert processing, reducing the need for DBA performance-tuning expertise. Additionally, Db2 13 is designed to deliver the following features in these key areas:

  • Reduced CPU and index maintenance costs that help enterprises grow workloads.
  • Improved insert performance for PBG tablespaces.
  • With Db2 13, APREUSE offers the option to manage a more granular level access path reuse and reduce error or warning cases from rewritten queries.
  • Help reduce downtime for implementing application changes.
  • Enhanced sort optimization, which helps improve the performance of certain operations without changing how Db2 for z/OS is used.
  • Fast index traversal (FTB) support for larger index keys.
  • Reduced overhead for replication of subsets and data partitions.

Infusing AI helps to improve operational efficiency, reduce costs, and increase database administrator (DBA) productivity. Customers can experience improved application performance and business resiliency by exploiting AI and Machine Learning (ML) technology because it helps support application growth and performance with smarter insert processing. It can also help reduce CPU utilization through improved index maintenance, smarter sort optimization, and improved concurrency while minimizing any downtime when implementing application changes.

 

Enhanced Scalability, Security, and Compliance

Businesses need to be able to rapidly and dynamically adapt and react to changes in the marketplace. They should be able to expand their systems quickly and easily to meet the needs of the business, both for the long term or short term – including temporary seasonal changes or peak periods, without impacting availability. Db2 13 supports new and growing workloads without having to enact deep changes to the Db2 for z/OS environment.  It offers improved storage conditions, higher concurrent threads, and increased concurrent data sets for other Db2 activities. The Db2 installation and process for customizing the amount of private storage has been enhanced. There is also enhanced Disks Data Format (DDF) storage relief, which provides the means for customers to grow while helping to reduce outages. Organizations can also benefit from  the enhanced scalability and improved serviceability.

With each new release, Db2 for z/OS gets faster and more securable. In database environments security is critical. Continual monitoring for compliance with standards improves security.  To this end, Db2 for z/OS adds automated compliance evidence data collection that enables the IBM Security and Compliance Center solution to provide Db2 for z/OS customers with the compliance posture of application and infrastructure running in a Db2 for z/OS environment. This simplifies the regulatory controls validation for audits. And DBAs can create routine packages within the trusted context of Db2 for z/OS, which can result in significant productivity gains.

 

Db2 13 and IBM z16 – Better Together

Sometimes, things are just meant to be.  Downtime is the enemy of a business. It costs both time and money and can have grave consequences for organizations that are not sufficiently prepared, sometimes resulting in irreparable brand damage, public confidence, and trust. Analyst reports demonstrate that downtime costs $5,600 per minute on average. This results in average costs between $140,000 and $540,000 per hour, depending on the organization. Db2 13 increases resiliency with the exploitation of system recovery boost, which helps improve restart performance and minimize downtime. Db2 can exploit the IBM z16 hardware as follows:

  • New System Recovery Boost (SRB) in IBM z16 can help improve Db2 for z/OS restart performance, thereby minimizing downtime
  • Better insights to tune Db2 performance in data sharing environments with the exploitation of IBM z16
  • Expanded SORTL instruction usage based on machine learning on the amount of storage and the number of records being sorted, requires IBM z15 or higher
  • Exploits IBM z16 optimization to speed up training and query

 All this adds up to enhanced efficiency and differentiating business value for organizations.

Database Management and Upgrades - Simpler and Easier than ever Before

With all the benefits and capabilities, Db2 13 can help improve an organization’s time to value, enabling organizations to exploit new features and functions designed to avoid impacting availability, security, or performance. Organizations can enjoy the simplified process to upgrade to Db2 13 in a single phase. There is improved ability for Independent Software Vendor (ISV) products to better support data replication environments through the ability to write decompression dictionaries to the Db2 log – along with improved performance through enhanced REORG INDEX and the collection of real-time and historical information regarding utility executions.

 

Your Next Steps

This blog highlights just some of the key capabilities, benefits, and features of what IBM Db2 13 for z/OS has to offer organizations as part of their Journey to AI. It should hopefully remove any doubts as to why to upgrade from earlier versions.

If you need help with any aspect of your Db2 installation, implementation or upgrading, IBM provides help in the form of its many services offerings such as IBM Systems Lab Services, IBM Consulting, IBM Technology Support Services, IBM Expert Labs, IBM Security Expert Labs.

 

If you’re interested in learning more about Db2 13 for z/OS and its many benefits, please visit:

 

Steven Astorino,

VP of Development, Data and AI, and Canada Lab Director

Read more…

IDUG North America 2022 | Boston, MA | July 11-14  REGISTER NOW

 

  10214507269?profile=RESIZE_710x

 

Registration is Open Now!

IDUG's 2022 North America Db2 Tech Conference will be held at the Sheraton Boston on July 11-14, 2022 [some optional pre-conference events could occur on July 10, 2022]. 

This year’s North America event is a hybrid conference: you can register to attend on-site or to participate online. Register now for the conference, then (if you will be participating on-site) reserve your lodging at the Sheraton Boston!

Conference Sponsorships Available... 

Connect with your customers at IDUG 2022 NA! Click here for the sponsor prospectus that explains exhibit and marketing opportunities to share your expertise with our audience. IDUG will be bringing together the global Db2 community for four days of in-person exploration and collaboration in July. Reach out to us at cyndi@teamycc.com to learn about all our opportunities.

Schedule & Speakers Announcements Coming Soon...

IDUG’s North America Conference Planning Committee (CPC) is finalizing the schedule and speakers for IDUG 2022 NA. If you have any questions about the schedule and speakers, please reach out to CPC member Chris Muncan at chris.muncan@gmail.com

 

Read more…

Tablespaces: where exactly is my data?

By Mark Gillis

This should be pretty straight-forward: you can look in the TABLES System Catalogue and find references for the data (TBSPACE), Indexes (INDEX_TBSPACE) and Large Objects (LONG_TBSPACE). But DB2 throws a few curved balls here; partitioned tables (where the data, indexes and LOBs can be in multiple tablespaces), particular types of index that don’t seem to be in the catalogues at first glance, etc. Let’s see if we can put something together that shows the complete picture.

 

Overview

I’ve got a little database with all sorts of weird and wacky objects. It’s tiny, in terms of volume, but includes row and column-organized tables, range-partitioned tables, MQTs and a bunch of other stuff. Some tables have the full “INDEX IN … LONG IN ….” Tablespace definitions but don’t actually use them, some don’t have any or all the tablespace directives. I want to be able to see the full picture, so how do I go about that?

Click here to find out. 

 10164642078?profile=RESIZE_710x

 

Read more…

This is the third article of a four-part series addressing Db2 for z/OS and modern development utilizing an Agile methodology and DevOps processes. To read the first two articles please follow these links:

https://community.ibm.com/community/user/hybriddatamanagement/blogs/daniel-luksetich/2021/06/21/traditional-db2-development-vs-modern-development

https://community.ibm.com/community/user/hybriddatamanagement/blogs/daniel-luksetich/2021/08/09/devops-and-modern-it-defined

There has undoubtedly been substantial confusion concerning the various IBM software products that provide mainframe connectivity for web applications, what they do, what they cost, and what needs are they trying to serve. These include, but are not limited to; z/OSMF, z/OS Connect, Zowe (not IBM software, but open-source software that runs on z/OS), CICS Transaction Gateway, and now The IBM Unified Management Server for z/OS. Are all these servers related? No, they are not! Can some of the functionality of these servers overlap? Perhaps, but that is not the focus here. The question to be answered is what is the IBM Unified Management Server (UMS) and what benefits can be derived from installing it on a z/OS system?

To read the entire article follow this link:

https://community.ibm.com/community/user/hybriddatamanagement/blogs/daniel-luksetich/2021/09/14/the-ibm-unified-management-server-and-db2-for-zos

 

Read more…

This is the fourth in a four-part series of articles addressing Db2 for z/OS and modern development utilizing an Agile methodology and DevOps processes. To read the first three articles please follow these links:

https://community.ibm.com/community/user/hybriddatamanagement/blogs/daniel-luksetich/2021/06/21/traditional-db2-development-vs-modern-development

https://community.ibm.com/community/user/hybriddatamanagement/blogs/daniel-luksetich/2021/08/09/devops-and-modern-it-defined

https://community.ibm.com/community/user/hybriddatamanagement/blogs/daniel-luksetich/2021/09/14/the-ibm-unified-management-server-and-db2-for-zos

In this article we address the critical needs of the Db2 for z/OS professional and the way these needs are met with the IBM Db2 DevOps Experience for z/OS. In addition, it will look at the needs of the modern Application Developer and the enterprise advantage to keeping your systems of engagement and innovation close to your system of record.

To read the entire article follow this link:

https://community.ibm.com/community/user/hybriddatamanagement/blogs/daniel-luksetich/2021/11/03/ibm-db2-devops-experience-for-zos

Read more…

By Mark Gillis

There are easily accessible means of checking what your Stored Procedure needs in the way of dependent objects (SYSCAT.ROUTINEDEP, basically). So, what if you find a, or a number of, Stored Procs that are marked as needing a REBIND and then, when you do that rebind, you get an SQL0440 indicating that “something” is missing. How do you go about checking that situation out? Find out here

9756322693?profile=RESIZE_584x

Read more…

In-Database AI Client Experiences with Db2 for z/OS + Demo 

Don't  miss this live webcast on 2nd November 2021 - 11:00AM EST
Tom Ramey will highlight some of the key challenges facing Db2 for z/OS clients and how AI is a breakthrough technology, that when applied to Db2 for z/OS performance management and resiliency can have a major impact. Tom will be joined by Benny Van Straten from Rabobank and Tom Beavin from IBM.  Tom Beavin will share Db2 AI use cases and host a live Db2 AI demo.Rabobank is a Dutch multinational banking and financial services company; Benny will share first-hand experiences and lessons learnt around Db2 AI for z/OS and the power of in-database AI.

 What will you learn by attending this webcast?

  • Hear first-hand client feedback and experiences
  • Learn how Db2 AI improves SQL performance using machine learning based on unique patterns found when executing the queries in a production environment. 
  • Learn how Db2 AI automatically detects SQL access path performance regressions and automatically restores the performance back to its optimal level
  • Learn how Db2 AI automatically stabilizes dynamic queries with their optimal access path, reducing prepare overhead

    9739408684?profile=RESIZE_400x

Tom Ramey IBM WW Director, Data and AI on IBM Z

Benny van Straten IT Specialist/DB2 Rabobank

Akiko Hoshikawa IBM Distinguished Engineer

Tom Beavin IBM Db2 AI for z/OS Development Machine Learning and Optimization

 

Read more…

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

9712629474?profile=RESIZE_710x

 

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.
 
9712621054?profile=RESIZE_710x
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.
 
9712599073?profile=RESIZE_710x9712580674?profile=RESIZE_710x
 
 
Select and add tables from source to target
The next step is to select the tables to synchronize data from source to target.
 
9712580064?profile=RESIZE_710x
 
Db2 Data Gate dashboard
Overview of status and activities associated with the provisioned Db2 Data Gate instance.
 
9712578895?profile=RESIZE_710x 
 
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
https://ibm.biz/BdfanX
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. 

9644149095?profile=original
#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

9644149272?profile=original

Read more…

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

Learn More

9524610073?profile=original

Abstract

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:
https://www.db2expert.com/db2expert/introduction-to-db2-for-z-os-json-sql-support/

This is a direct link to the IDUG article, but you need an IDUG login account (which is free).
https://www.db2expert.com/db2expert/introduction-to-db2-for-z-os-json-sql-support/

Read more…

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

9524609878?profile=original

HURRY SIGN UP TIME IS HURRYING OUT

Summary

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…