Central Canada Db2 Users Group


Next Meeting: April 12-13, 2021


CONFERENCE SESSION GRID

Monday April 12 | Tuesday April 13


SPEAKERS & ABSTRACTS

z/OS | LUW | IMS


Central Canada DB2 Users Group - 2021 Event
M O N D A Y  April 12
Db2 for z/OS - Room 1 IBM IMS - Room 2
9:30 -10:00 CCDUG Introduction & Welcome in Room 1
10:00 - 10:50 Db2 for z/OS Trends & Directions

Jim Pickel, IBM



Details
IMS Kickoff and Strategic Roadmap

Betty Patterson Bucci, Chief IMS Architect, IBM



Details
Break
11:00 - 11:50 Db2 for z/OS Development SWAT team - expect the unexpected - "Murphy's Law – What can go wrong will go wrong"

Anthony Ciabattoni, IBM



Details
IBM Nuts and Bolts of IMS Lock Management

Kevin Stewart, IMS Support/Client Advocate


Details
Lunch
12:30 - 1:20 Stop REBINDing!

Terry Purcell, IBM



Details
IMS Tools Update

Tracy Dean, IMS Tools Offering Manager


Details
Break
1:30 - 2:20 Optimization Hints Grow Up

Chad Reiber, BMC



Details
IMS and the Relational Database

Robert Recknagel, Senior Architect, Finanz Informatik Technologie Service

Deepak Kohli, IMS Offering Manager - Database Management


Details
Break
2:30 - 3:20 SQL and SQL PL in Db2 12 - Including Function Levels

Chris Crone, Distinguished Engineer - Database Technology, Broadcom



Details
DevOps and IMS

Haley Fung, IMS Offering Manager - API, Java and DevOps, IBM


Details
Break
3:30 - 4:20 Db2 trivia and reasoning - It is all so obvious in hindsight

Brian Laube



Details
DevOps and IMS: Creating, Updating, and Testing IMS Artifacts with Your IMS Application Changes

Tracy Dean, IMS Tools Offering Manager

Ron Bisceglia, Distinguished Engineer, Rocket Software



Details

 

 

 

 

 

 

T U E S D A Y  April 13
Db2 for z/OS - Room 1 Db2 for LUW - Room 2
9:30 -10:00 CCDUG Introduction & Welcome in Room 1
10:00 - 10:50 Space Troopers enter the ZOWE world - Db2 mission control for the next generation

Roy Boxwell / Ulf Heinrich, SEGUS



Details
Db2 Latest News

Piotr Mierzejewski, Executive Director of Development for IBM Db2



Details
Break
11:00 - 11:50 Integrate Db2 for z/OS database changes in your enterprise DevOps pipeline

Maryela Weihrauch, IBM DE, IBM Z Data and AI

Kendrick Ren, IBM Db2 for z/OS Development



Details
Db2 Query Optimization 101

John Hornibrook, IBM



Details
Lunch
12:30 - 1:20 Transform Developer Experience for Db2 for z/OS

Kendrick Ren, IBM Db2 for z/OS Development



Details
Db2 11.5 from GA to What's Coming

Keri Romanufa, IBM STSM & Chief Db2 Architect



Details
Break
1:30 - 2:20 Help! I'm overwhelmed with all these metrics in my Db2 monitor.

Robert Andresen, Broadcom



Details
Migrating Db2 from P-Series to X86

Dale McInnis, IBM



Details
Break
2:30 - 3:20 Mass Db2 Recovery with Db2 12 updates .... The Nightmare of a Db2 Professional

Anthony Ciabattoni, IBM



Details
Adaptive Workload Management: Best Practices + What's New

David Kalmuk, IBM STSM & Master Inventor



Details
Break
3:30 - 4:20 Continuous Delivery and the very latest new functionality

Mark Rader, IBM Db2 for z/OS Specialist



Details
Table Space Odyssey

Pavel Sustr, IBM Db2 LUW Development, Db2 and PD SME, Data & AI



Details


SPEAKERS & ABSTRACTS

z/OS | LUW | IMS


z / O S
Speaker Title / Abstract
Jim Pickel
IBM
Db2 for z/OS Trends & Directions

This session will cover the latest news on how Db2 for z/OS addresses the challenges you are facing to optimize your enterprise data. We will share the latest Db2 12 technological innovations for both transactional and analytical workloads. We'll also highlight recent announcements around Db2 AI for z/OS that can improve application performance as well as reduce time and cost. This session will also discuss Db2 Apollo, which will provide embedded AI capabilities to serve insights and provide deeper integration & learning.
Anthony Ciabattoni
IBM
Db2 for z/OS Development SWAT team - expect the unexpected - "Murphy's Law – What can go wrong will go wrong"

The session will discuss various unexpected, unplanned scenarios and events that customers have experienced. The discussion will explain the details of the events, how the customer was impacted and illustrate how to take preventative measures. The risk of experiencing the unexpected may be small, but when Murphy strikes the impact to the organizations can be costly. This session will also include new hot customer interests and challenges.


Speaker Bio

Anthony Ciabattoni is an IBM Senior Certified IT specialist and a current member of the Db2 for z/OS Development SWAT team based out of the Silicon Valley Lab with over 27 years of working directly with Db2 for z/OS. His experience includes be a customer lead Db2 architect as well as working in the Db2 for z/OS Tools development lab. He is a recognized Db2 for z/OS SME, 12+ years a member of the IBM Db2 for z/SO Customer Advisory Council and elected 9 straight years as an IBM Information Champion before joining IBM. In Anthony’s current role as a Senior technical advocate for Db2 for z/OS Development Lab he conducts consulting and educational workshops, Db2 health checks, and 360 Continuous Availability studies for worldwide Db2 for z/OS customers as well as a lab advocate to some of IBM’s largest North American customers. He has also presented Db2 topics at IBM worldwide conferences, IDUG (NA, SA, EMEA) and SHARE Conferences (US). Participated in authoring numerous Db2 for z/OS red books and white papers.

Terry Purcell
IBM
Stop REBINDing!

Stop REBINDing (static SQL)! Or stop PREPAREing (dynamic SQL)! This presentation will highlight available features to reduce the occurrence of access path changes.
This session covers "rebind/prepare avoidance" strategies - including RUNSTATS with new V12 default INVALIDATECACHE NO,
REBIND APREUSE options, Dynamic Plan Stability (DPS) and recent enhancements in Continuous Delivery.


Speaker Bio

Terry Purcell is a Senior Technical Staff Member with the IBM Silicon Valley Lab ; where he is lead designer for the DB2 for z/OS Optimizer. Terry has 25 years of experience with DB2 in SQL Performance and optimization as a customer ; consultant and DB2 developer. Terry is an IBM Master Inventor with more than 25 U.S. patents for database search technology.

Chad Reiber
BMC
Optimization Hints Grow Up

Back in 2000, I wrote an article for the IDUG Journal titled the Seedy Underworld of Db2. It discussed the new feature in DB2 Version 6 where our world class Db2 Optimizer could be influenced by the deal making backroom of the optimization hints. It was controversial the time but over the different DB2 releases and twenty years, IBM has given us several ways to influence the access paths, fallback to older access paths and just recently to use AI to help with access path determination. In this presentation, I will highlight where we have been and where we are now with getting the access path we want and need.

Many times, DBAs and Db2 Performance people are asked to improve performance without the benefit of the applications being able to make SQL changes. This is just another bunch of features/functions, that come with Db2 z/OS, individuals can used to make a difference to the end user.


Speaker Bio

In 1983 Chad Reiber started in IT with AT&T as a developer of data generator software. From there he moved into the database arena as a database administrator for IMS, IDMS, and Db2. Chad has been working with Db2 since 1987. Chad began working for BMC Software in 1997 as a Software Consultant and primarily supports all aspects of BMC’s Mainframe products for the Northeast Db2 community.

Chris Crone
Distinguished Engineer - Database Technology, Broadcom
SQL and SQL PL in Db2 12 - Including Function Levels

Db2 12 has been in the marketplace for 5 years and in additional to base Db2 12, Db2 has shipped 9 function levels that have provided significant enhancements. This session will cover all the items you need to know about in order to exploit Db2 12 SQL and SQL PL capabilities.


Speaker Bio

Chris is a Distinguished Engineer at Broadcom where he works with customer and the Broadcom development teams on improving the mainframe experience. He has extensive experience working with Db2 and IBM z Systems. Prior to joining Broadcom, Chris worked with the Db2 for z/OS development team for more than 30 years. He has worked extensively with customers on new development projects, prioritizing requirements, and advising on how to best use Db2 to achieve their goals.

Brian Laube
Manulife
Db2 trivia and reasoning – It is all so obvious in hindsight

Db2 involves many terms and phrases which are not obviously defined in hindsight. People say things and you think you know but then it takes a surprising long time to really catch-on to the full meaning. This presentation will go over many terms and definitions that I always try to keep clear with my end-users and new users to Db2.

Come to my presentation and see if we are on the same page!

Topics to be covered include subsystem, instance, database environment and application. Package and DBRM and BIND and REBIND (stop saying REBIND when you mean BIND).

I will review the very basics of IBM Support and CASE and PMR and APAR and PTF and RSU. I will clarify the difference between a problem and a short-coming or opportunity for enhancement (which leads to RFE and AHA)

Finally, and most fun, I will review my top 15 SQL coding standards and opinions, from over-use of DSINTCT, to absent ORDER BY, to under-utilization of MERGE and how to call a procedure from DSNTEP2!


Speaker Bio

Brian Laube is an application DBA at Manulife Financial.

He has presented user presentation at several recent IDUG. He is also a member of the IDUG content committee and is a regular blog contributor.


Roy Boxwell / Ulf Heinrich
SEGUS
Space Troopers enter the ZOWE world - Db2 mission control for the next generation

Space is infinite, but that doesn't mean there are no limits. Space Troopers in the galaxy of Db2 z/OS want to see the bad guys coming before the production spacecraft gets exhausted. Sneak into the ZOWEs space mission control on a journey into the future.
There has always been a variety of mission critical limits in Db2. Thankfully, IBM does a great job with their resource constraint relieve efforts to relax them where they can. However, we all know -or learned it the hard way- there are still lots of them a there are even new ones every once in a while.
Old space management isn't designed for warp speed production space crafts, but ZOWE empowers state-of-the-art mission control to guarantee the maximum range for your journey.
Get on-board and learn where the limits are and how to monitor them in real-time using the latest and greatest front-end technology of the z platform


Speaker Bio - Roy

Roy Boxwell has more than 33 years of experience in MVS, OS/390, and z/OS environments – 30 of those in DB2. He specializes in installation, migration, and performance monitoring and tuning. Roy leads the SEG development team responsible for the real time database maintenance solutions. He is also an active participant and contributor on the IDUG DB2 Listserve and sends out a monthly DB2 newsletter.

Speaker Bio - Ulf

Ulf Heinrich is the Director of Solutions Delivery at SEGUS Inc. He specializes in Db2 operations and performance tuning, focusing on the growing requirement for cost reduction and 24×7 operations. As a consultant at large customer sites, he has implemented database maintenance procedures and recovery strategies, and also experienced the pitfalls of recovery scenarios under realworld recovery pressure. His activities cover EMEA, as well as North America. As a member of SOFTWARE ENGINEERINGs Request Board he’s working closely with customers and the development labs.

Maryela Weihrauch
IBM DE
IBM Z Data and AI

Kendrick Ren
Db2 for z/OS Development
Integrate Db2 for z/OS database changes in your enterprise DevOps pipeline

Typically, the first focus for a Development team is implementing a DevOps pipeline for application changes, whereas, in practice, many application changes also require Db2 z/OS database changes.
That introduces a dependency on DBAs to deploy code with multiple hand-offs between DBA, application developer, and Data Modeler, which in turn creates unnecessary bottlenecks and deployment delays.


Speaker Bio

Maryela Weihrauch is an IBM Distinguish Engineer and z Systems Analytics world-wide technical sales and client champion. She has extensive experience with Db2 regarding systems; application; and database design. Maryela is very engaged in enterprises world-wide; driving the adoption of new analytical technologies. Her most recent role in DB2 for z/OS Development has involved determining DB2 z/OS strategy for HTAP (Hybrid Transaction and Analytics Processing). This includes IDAA strategy and implementation; as well as DB2's application enablement strategy. Maryela is a member of the IBM Academy of Technology and frequently shares her experience at conferences.

Kendrick Ren
Db2 for z/OS Development
Transform Developer Experience for Db2 for z/OS

Stop switching among different integrated development environments (IDEs) and tools for your daily work! Work with Db2 for z/OS using different languages (SQL, Cobol, Java, Node.js, Python, JCL, etc) without leaving the workspace to perform various front end activities, like executing SQLs, developing/debugging applications, submitting JCLs, navigating and editing z/OS artifacts like datasets, issuing MVS commands, working on Docker/Jenkins, exploiting RESTful APIs, etc. This session presents you a unified and productive developer experience across mainframe and distributed platforms.


Speaker Bio

Kendrick Ren is the technical lead of DevOps solution for Db2 for z/OS. He has been leading the effort of transforming Db2 application developer and query performance tuning experience. He was the architect of Optim Query Workload Tuner before that and had been working in query tuning area for many years.

Robert Andresen
Broadcom
Help! I'm overwhelmed with all these metrics in my Db2 monitor.

You want to improve Db2 performance, but what do I look for? There are many different monitors and tools hundreds of screens and over 1500 of metrics. It can be overwhelming, especially if you are not familiar with the application or new to Db2 or the mainframe. This presentation will cover:
  1. What are the causes of performance problems
  2. How do you detect they are happening
  3. What can you do to prevent them
  4. Use what-if predictive analysis to see what effects a change might have before actually making the change


Speaker Bio

Robert Andresen is a Principal Consultant with Broadcom. He has been working in performance management and monitoring for several software companies since 1997 and has been supporting mainframe systems since 1976 in various capacities including being a zOS/CICS/DB2 Systems Programmer. He is a co-author of the IBM Redbook: Linux on IBM @server zSeries and S/390: System Management. He has presented at IDUG, CMG, SHARE, the IBM zOS Conference and LinuxWorld as well as many local and regional user groups. He holds a degree in Mathematics from the Illinois Institute of Technology. He is certified as an IBM Certified Database Administrator, DB2 10 and 11 for z/OS, an IBM Certified SOA Associate and also is ITIL Foundation Certified. At CA he has been supporting their suite of Db2 for z/OS. His areas of expertise include z/OS, DB2, CICS, UNIX/Linux, Windows, and R.

Anthony Ciabattoni
IBM
Mass Db2 Recovery with Db2 12 updates .... The Nightmare of a Db2 Professional

The challenge of mass Db2 recovery is overwhelming and challenging but rarely is tested. Disaster Recovery testing often occurs multiple times a calendar year but local recovery testing especially mass application recovery rarely is tested. Statistically speaking mass Db2 recovery will happen more frequently than an actual disaster but most organizations are not properly prepared to execute a mass local recovery. This session will go through the process of planning, preparing and executing a mass Db2 recovery. The ultimate goal is to plan, prepare and be proactive rather than being non-prepared reactive when a mass Db2 recovery is needed to be executed.


Speaker Bio

Anthony Ciabattoni is an IBM Senior Certified IT specialist and a current member of the Db2 for z/OS Development SWAT team based out of the Silicon Valley Lab with over 27 years of working directly with Db2 for z/OS. His experience includes be a customer lead Db2 architect as well as working in the Db2 for z/OS Tools development lab. He is a recognized Db2 for z/OS SME, 12+ years a member of the IBM Db2 for z/SO Customer Advisory Council and elected 9 straight years as an IBM Information Champion before joining IBM. In Anthony’s current role as a Senior technical advocate for Db2 for z/OS Development Lab he conducts consulting and educational workshops, Db2 health checks, and 360 Continuous Availability studies for worldwide Db2 for z/OS customers as well as a lab advocate to some of IBM’s largest North American customers. He has also presented Db2 topics at IBM worldwide conferences, IDUG (NA, SA, EMEA) and SHARE Conferences (US). Participated in authoring numerous Db2 for z/OS red books and white papers.

Mark Rader
IBM
Continuous Delivery and the very latest new functionality

Db2 12 for z/OS continuous delivery means new capabilities are added to your Db2 environment as you apply maintenance. There is a lot of flexibility in how you manage the introduction of some of those capabilities to your applications. "A lot of flexibility" also means a lot of choices.

This session starts with a review of how continuous delivery gives you control over these choices, then goes on to discuss the key features that have been introduced in the various function levels. In addition, this session will touch on 'infrastructure' changes provide through continuous delivery that are not controlled by function level.



Speaker Bio

Mark Rader is a Db2 for z/OS specialist in the IBM Washington Systems Center. He has over 37 years of technical experience with IBM, and over 30 years with Db2 for z/OS. He has led many Db2 data sharing implementations and has presented a variety of topics at conferences, including IDUG, SHARE, IBM Technical University and at regional Db2 user group meetings. He has worked closely with Db2 development in delivering the Early Support Programs for Db2 10, Db2 11, and Db2 12. He is an author of redbooks on Parallel Sysplex application considerations, Db2 data sharing, and Db2 for z/OS distributed function.

 

LUW
Speaker Title / Abstract
Piotr Mierzejewski
Executive Director of Development for IBM Db2
Db2 Latest News

Evolution of Hybrid Cloud, Containers, Kubernetes, AI/ML and explosion of new data formats like JSON or Graph has left CIOs with search of Polyglot or Universal Databases that satisfy their enterprise needs.

Driven by this demand IBM Db2 LUW has evolved into Universal Database providing wide range of deployment patters and advanced capabilities that satisfy modern age requirements.

Join us for this exciting session filled with latest news on Db2 v11.5 features and capabilities


Speaker Bio

Piotr is the Executive Director of Development for IBM Db2, Db2 Big Sql and Data Virtualization Data & AI. Piotr began his career at IBM in 2009 at IBM’s Center for Advanced Studies as a Prototype Developer concentrating on graph theory and linked data applications. Over years Piotr took roles in DB2 SQL compiler development and DB2 Build team. Over the last 3 years Piotr lead development of Watson Studio Local an AI/ML Platform for IBM Advanced Analytics group and most recently took role of Executive Director of Development for IBM Db2, Db2 Big Sql and Data Virtualization Data & AI

John Hornibrook
STSM IBM Toronto Lab
Db2 Query Optimization 101

Optimal query access plans are essential for good data server performance and it is the Db2 query optimizer's job to choose the best access plan. The optimizer is a very sophisticated component of the data server, tasked with the challenging job of choosing good access paths for the variety of features and table organizations supported by Db2. The optimizer can automatically rewrite complex SQL resulting in huge performance improvements. It models various aspects of Db2 runtime so that it can choose the best access plan out of hundreds of thousands of possible options. Attend this session to get an overview of how the optimizer works and to get some tips on how to understand its decisions and control its behavior.


Speaker Bio

John is a Senior Technical Staff Member responsible for relational database query optimization on IBM's distributed platforms. This technology is part of Db2 for Linux, UNIX and Windows, Db2 Warehouse, Db2 on Cloud, IBM Integrated Analytics System (IIAS) and Db2 Big SQL. John also works closely with users to help them fully realize the benefits of IBM's relational DB technology products.

Keri Romanufa
IBM STSM & Chief Db2 Architect
Db2 11.5 from GA to What's Coming
Topics will include:
  • A quick review of V11.5 GA and Mod 4
  • review of 11.5.5 with a Deep Dive into a few highlighted features
  • Whats coming next in 11.5 stream


Speaker Bio

Keri Romanufa is an STSM and the Chief Architect for the Db2. She has been a member of the Db2 team for 28+ years. She has had a variety of roles in System Test and Performance Teams, but as spend the majority of her career in Development. She has contributed to many of Db2's advances including the initial release of DB2 pureScale, driving technologies such as space reclaim for objects and storage (DMS and later automatic) and focusing on performance especially in the buffer pool area. In doing so, Keri has achieved 23 patents.

Dale McInnis
STSM IBM Toronto Lab
Migrating Db2 from P-Series to X86

In this presentation we will examine the options available to DBAs when moving a Db2 deployment from AIX on P-series to Linux on an X86 environment. Several approaches will be examined, detailing how each works and what would be the impact to the application of the move.


Speaker Bio

Dale McInnis is a Senior Technical Staff Member (STSM) at the IBM Toronto Canada lab. He has a B.Sc.(CS) from the University of New Brunswick and a Masters of Engineering(M.Eng) from the University of Toronto. Dale joined IBM in 1988, and worked in the DB2 development team from 1992 - 2014. Dale's area of expertise includes DB2 for Linux, UNIX and Windows Kernel development, where he led teams that designed the current backup and recovery architecture and other key high availability and disaster recovery technologies. He has obtained eleven (11) patents in the area of database resiliency. Dale is a popular speaker at the International DB2 Users Groups (IDUG) conferences worldwide, as well as DB2 Regional users groups and IBM's Information On Demand (IOD) conference. His expertise in the area DB2 availability area is well known in the information technology industry. Dale spent 10 months as the IBM Cloud Data Services Chief Availability Architect, and now Dale is now on the North American Hybrid Data Management Technical Sales team.

David Kalmuk
IBM STSM & Master Inventor
Adaptive Workload Management: Best Practices + What's New

Abstract


Speaker Bio

David Kalmuk is a Senior Technical Staff Member & Master Inventor with responsibility for the MPP scale-out, Workload Management, and Monitoring areas of the Db2 family products. David has contributed to the development of numerous technologies in Db2 over the years including BLU Acceleration, Workload Management, Monitoring, as well as much of Db2’s Processing and Communications architecture. He is currently leading efforts focused on evolving Db2's Data Warehousing Architecture.

Pavel Sustr
Db2 LUW Development, Db2 and PD SME, Data & AI
Table Space Odyssey

Db2 storage de-mystified. DMS, SMS, Automatic Storage table space internals. Default table space types across different Db2 editions and versions. Best practices. Container structure, naming conventions, internal architecture. Buffer pool considerations. Storage paths, auto-extend mechanisms, automatic striping. Parallelism vs. performance discussions. Common high watermark issues, reclaimable (object-relative) vs. non-reclaimable (pool-relative). Explanation on current deprecation statements, upgrade paths and considerations. Common tooling and tricks to deep dive into the storage components (db2dart, db2pd, and others).


Speaker Bio

Senior Software Engineer with IBM Db2 LUW kernel development. Always thrilled to work on hard-to-crack puzzles. Expertise in Db2 kernel architecture, configuration and administration, advanced problem determination, memory architecture, memory leak troubleshooting, and the assembly language. Hands-on development experience with buffer pool management, storage, prefetching, page cleaning, transaction logging, recovery, monitoring, and problem determination. As a member of the Db2 team, Pavel spent years in Db2 L2/L3 advanced support (over 1,500 resolved cases), then transitioned to Db2 kernel development where he became Senior Software Engineer and later Development Manager for multiple core Db2 kernel components. In his past life Pavel was an application developer mostly using C++, SQL, .NET, Oracle, MS-SQL, and Informix on Windows, Linux, Solaris, and HP-UX.

 

IMS
Speaker Title / Abstract
Betty Patterson Bucci
Chief IMS Architect, IBM
IMS Kickoff and Strategic Roadmap

This session will kick off the IMS track of the Central Canada Db2 User Group event. Chief IMS Architect, Betty Bucci, will talk about recent enhancements to IMS, new offerings on the IBM Z Application platform, as well as what is on the horizon for IMS. What will the development experience for IMS look like in the future and what does the hybrid cloud have to do with it? Get these questions answered, and more!

Speaker Bio

Betty Patterson Bucci is an IBM Distinguished Engineer and Chief Architect for IMS responsible for strategy and architecture. Betty has driven innovations into the product to make it easier to manage IMS and has expanded the flexibility in configuring the product for availability; including the areas of system management, parallel sysplex and shared message queues. Betty is currently focused on IMS education and moving IMS into the world of containers.

Robert Recknagel
Senior Architect, Finanz Informatik Technologie Service

Deepak Kohli
IMS Offering Manager - Database Management, IBM
IMS and the Relational Database

Even though IMS is a hierarchical database, IMS's implementation of the SQL data definition language (DDL) conforms to the well-defined, standard DDL syntax that is used with relational databases throughout the industry. Because of this, leveraging DDL means creating and modifying IMS databases becomes much easier for application developers and database administrators who have not yet had the time to become familiar with IMS. Join Robert Recknagel in this session where he will go more in-depth about this implementation and what you need to get started! Afterward, Deepak Kohli, IMS Offering Manager, will be available for Q&A.

Speaker Bio - Robert

Robert Recknagel started working with IMS as a student. His master thesis was about how to integrate IMS with modern web-based interfaces using Java, SQL and REST/JSON with IMS. He started his career 2014 as an IMS systems programmer at FI-TS, a German IT service provider for banks and insurance companies. Today he is the IT architect for mainframe databases and middleware at FI-TS. In this role, he drives IMS system-side modernization in the IMS systems FI-TS operates and supports IMS application-side modernization projects of their clients. Besides this, he is regularly giving presentations on these topics at national and international conferences.



Speaker Bio - Deepak

Deepak Kohli is an IMS Offering Manager specializing in Database Management and has been working with IMS for several decades. He has worked as a DBA and Sysprog. He has also worked in IMS level 2 support. Deepak is a sought-after speaker in the conference circuit.
Tracy Dean
IMS Tools Offering Manager, IBM
IMS Tools Update

Come learn what's new in the IBM IMS tools portfolio. Discover what we have done in the last 2 years since our last CCDUG meeting, including how you can take advantage of the new features to improve the management of your IMS environment.


Speaker Bio

Tracy Dean is an IBM Offering Manager, responsible for IMS Tools and z/VM Tools. With over 35 years of Z experience, she works with customers worldwide to understand their pain points and drive development teams to address their needs.

Kevin Stewart
IMS Support/Client Advocate, IBM
Nuts and Bolts of IMS Lock Management

Database integrity is a key quality of service for IMS. To protect database integrity, IMS serializes requests for database resources so no two application programs are allowed to update a database segment concurrently. This process is called Lock Management. In this session, IMS expert Kevin Stewart covers the IMS Internal Resource Lock Manager at a high level, then dives more deeply into TIMEOUT and DEADLOCK processing. Effective lock management is critical to your IMS and DB2 data availability and parallelism processing!


Speaker Bio

Kevin worked as a z/OS, IMS, and Db2 system programmer at a large Canadian bank for 19 years, before joining IBM in 2000. He has worked as a customer advocate, tools developer, L2 analyst and change team programmer.

Haley Fung
IMS Offering Manager - API, Java and DevOps, IBM
DevOps and IMS

DevOps in IMS? You heard right. In this presentation, IMS Offering Manager and DevOps expert Haley Fung will highlight how to master DevOps with IMS. From speeding up the entire IMS development cycle - coding, testing, source code management, and deployment, to integrating IMS application assets into a DevOps pipeline using familiar tools like Git, Jenkins, as well as Zowe, to automating your mainframe z/OS processes. Have you considered Ansible automation on z/OS? It can open up possibilities to perform z/OS subsystem provisioning, application deployment, CI/CD pipelines, multi-system orchestration, and much more! Haley will also showcase common use cases in DevOps and Automation to illustrate how to implement the CI/CD pipeline. IMS system programmers and DBAs will gain a new perspective of not only what is involved in the DevOps setup, but also what their roles are in relation to that of the DevOps application developers.


Speaker Bio

Haley Fung is an IMS Offering Manager specializing in API, Java, DevOps and also Ansible for IBM Z. She drives product direction in building solutions for enterprise modernization and integration for IMS. Haley is a frequent presenter at global technical conferences. Her deep technical expertise and her passion and dedication for customers have helped many IMS customers to modernize and enhance their application infrastructures.

Tracy Dean
IMS Tools Offering Manager

Ron Bisceglia
Distinguished Engineer, Rocket Software
DevOps and IMS: Creating, Updating, and Testing IMS Artifacts with Your IMS Application Changes

Modern source code and test data management practices are critical as application developers transition to DevOps processes. How can IMS applications participate in this new world? Implementing change control and test environments that support both application changes and the related DBD and PSB changes is no easy task. In this session, the speaker will build on the earlier presentation on IMS and DevOps to share some new ideas about how an automated, simplified approach can be used to implement IMS changes (such as PSBs) and to create and manage test environments that meet the needs for high quality agile application development.


Speaker Bio - Tracy

Tracy Dean is an IBM Offering Manager, responsible for IMS Tools and z/VM Tools. With over 35 years of Z experience, she works with customers worldwide to understand their pain points and drive development teams to address their needs.

Speaker Bio - Ron

Ron Bisceglia is a Distinguished Engineer for Rocket Software, a global developer of software products, and is responsible for the design, development, and support for several products primarily in the IMS space. He has worked with IMS for over 28 years and for the past 25 years has been involved in the design, development, and support of a range of IMS tools. He has been involved in the development of database reorganization utilities, data propagation tools, database monitoring and analysis solutions, data replication and backup and recovery products.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 



For more information, please contact: registration@ccdb2.ca
© copyright 1996-2021 Central Canada Db2 Users Group
Last updated April 8, 2021.