Event details

Date: October 18th, 2018
Time: 09:00 - 19:00
Location: IBM Client Center
Address: Avenue du Bourget/Bourgetlaan 42 - 1130 Brussels

Busy, busy, busy, we are all very busy.

Indeed, we’re all very busy. There is so much to do and so little time to do it all. Sometimes it seems like you just got into the office and it is already time to go home again. Just some of the common complaints of the busy Db2 professional today.

All valid concerns, but it does not diminish the need to properly address Db2 database administration and performance management... All this cannot be done without being up to date the latest developments in the Db2 arena and sharing experiences with, and benefiting from experiences of others.

So please take a little bit of time to evaluate the agenda below, and take a break from you busy day-to-day routine on Thurday 18 October and join your peers for a great day on maintaining and improving on-going efficiency and health of your Db2 environment.

The GSE BeLux Db2 team is convinced you will find this edition to be both interesting and educational. We cover Db 12 topics as diverse as availability enhancements such as PBR RPN, triggers, the latest and greatest on Db2 utilities (for both V11 and V12). We are also very pleased that we found two customers, KBC (B) and Belastingdienst (NL), who will share their Db2 12 migration experiences. This active participation from the Netherlands provides you with a great opportunity to extend your network, as we expect other Dutch colleagues to join this GSE Db2 day.

Besides Db2 for z/OS, we also have a track with Db2 for LUW sessions. This way we have all the people that know how to talk Db2 together, giving you the opportunity to pick up exiting things about either engine. Some great topics on the LUW side that will be presented are related to Db2 Big SQL, Db2 Event Store, as well as a revisit of the NoSQL features of Db2 revisited.

Agenda (click on the sessions and speakers name to see the details)

09:00 - 09:30


09:30 - 10:30

Keynote : “Hybrid Data Management on z”
Les King (IBM Toronto)

10:30 - 11:00

Coffee break

11:00 - 12:00

z-OS track

“PBR RPN and other availability improvements in Db2 12”
Haakon Roberts (IBM)

No LUW session

12:00 - 12:45

Lunch offered by IBM

12:45 - 13:45

z-OS track

“All about triggers”
Steve Thomas (CA)

LUW track

“Db2 Big SQL, Db2 Event Store and Open Source”
Les King (IBM)

13:45 - 14:45

z-OS track

“DB2 12 for Z installation at DTO”
Oscar Paalman (Belastingdienst NL)

LUW track

“NoSQL features of Db2 revisited: integrity, XML, recovery, and more”
Peter Vanroose (ABIS Training & Consulting)

14:45 - 15:15

Coffee break

15:15 - 16:15

z-OS track

“Db2 Utilities: The Very Latest Developments”
Haakon Roberts (IBM)

LUW track

“BLU Time Travel”
Matthias Nicola (IBM Germany)

16:15 - 17:15

z-OS track

“Db2 12 migration @KBC”
Gilbert Sieben (KBC)

LUW track

“Db2 in the Cloud including how to leverage a container-based approach”
Les King (IBM)

17:15 - 19:00

Networking and drink (sponsored by IBM)

Hybrid Data Management on z – Les King (IBM)

In this session we will go through the latest news from the labs on our Hybrid Data Management strategy, and, in particular, how it pertains to Z ! We will look at how our offerings can help clients leverage the various dimensions of hybrid including hybrid cloud, open source, access to semi-structured and unstructured data, event processing and more.

Db2 is at the center of our entire Hybrid Data Management (HDM) strategy. In this session we will walk through IBM's HDM Strategy, how that strategy maps to trends we are seeing in the market place and how this can be leveraged from the Z environment. We will drill down into the high value technical capabilities of the common software base for our HDM offerings and look at how this helps clients evolve their ecosystem to the public or private cloud, leverage container-based deployment forms, handle any kind of workload including new event processing workloads and how our offerings tie into growth in open source, Hadoop and the ability to leverage all kinds of data including JSON, XML, text, etc. All of this - and more - can be done with Db2. We will also include a demo of our new Db2 Event Store.

Les King - Director, Hybrid Data Management Solutions - IBM Analytics

Les King has impacted the vision for IBM’s Hybrid Data Management strategies, which includes Big Data, Analytics, Database and Cloud Data Services by acting as a trusted advisor both to clients and within IBM. He has held this post for four years however; Les has 25 years of experience in IBM Analytics. Les is a globally recognized name across industries in this key space as a direct result of his balanced experience in both technical and business arms of the field. Les is passionate about helping clients understand how IBM can help satisfy their business needs and how the Information Management and Analytics technology will strategically work to accomplish this.

All about Triggers - Steve Thomas (CA)

Triggers (now called Basic Triggers) have been supported in Db2 for around 20 years but now in Db2 12 for z/OS support for Advanced Triggers has been added and the landscape has completely changed. Advanced Triggers provide many useful benefits, not least improved portability with Db2 on distributed platforms and other database management systems, but crucially database operations that used to be very hard to achieve can now be easily accomplished. However, it’s vital for Application Designers, Developers and DBAs to understand the differences between the two types because a DML statement such as an INSERT or MERGE can produce completely different results depending on which type of Trigger is fired. This session will review Basic Triggers, what they can be used for and their limitations. We’ll then move onto covering the new Advanced Trigger capabilities added in Db2 12 for z/OS. We will highlight the differences between the two types and explain why those using Triggers need to be very aware of these changes even if they don’t code the actual Triggers themselves.

PBR RPN and other availability improvements in Db2 12 - Haakon Roberts (IBM)

You've probably heard of PBR RPN in Db2 12 and how it's now possible to store 4 petabytes of data in a single Db2 table. But the real benefit of RPN is how it improves availability and creates a foundation for future improvements in Db2. This session will explain why we delivered RPN in 12, how it works, what the benefit is and how to get there. We'll also look at other significant availability improvements delivered in V12 and after.

Db2 Utilities: The Very Latest Developments - Haakon Roberts (IBM)

DB2 for z/OS utilities is an area of intense and continuous development delivering many significant functional, performance and availability enhancements outside of V12. This session will focus on the very latest improvements that you can take advantage of today, even in V11. Haakon will discuss how to dramatically reduce REORG and LOAD CPU consumption for utilities , help you understand what's new in the LOAD utility and how to take advantage of these new features and provide info about how to speed up UTS conversions and more.

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