Tag: Db2 12

Saint Louis Db2 Users Group – June 2018

Meet us at the Saint Louis DB2 Users Group – June 2018 in St. Louis, MO, USA – STLDUG – and attend our presentation on Continuous Delivery: “Db2 12 – 12 months agile production experience with more focus on the Data and less on the base”.

On October 21st 2016 Db2 12 went GA and several customers have quickly started to take a look at this new version. About a year ago some migrated their production systems and started to gain real life experience. In July IBM also decided to do a massive rebranding throughout the z – ups, sorry – the Z portfolio. Db2 since then comes with a lowercase b, to place all emphasis on “Data”—your data. With all of this in mind we’ve created this presentation, bundling a year of experience to share best practices and tips for the Data-focused, agile database.

Tagged with: , , , ,

Central Canada DB2 Users Group 2018

Meet us at The Central Canada DB2 Users Group 2018 in June, Toronto, Ontario, Canada – CCDB2UG – and attend our presentation on Continuous Delivery: “Db2 12 – 12 months agile production experience with more focus on the Data and less on the base”.

On October 21st 2016 Db2 12 went GA and several customers have quickly started to take a look at this new version. About a year ago some migrated their production systems and started to gain real life experience.
In July IBM also decided to do a massive rebranding throughout the z – ups, sorry – the Z portfolio. Db2 since then comes with a lowercase b, to place all emphasis on “Data”—your data. With all of this in mind we’ve created this presentation, bundling a year of experience to share best practices and tips for the Data-focused, agile database.

Tagged with: , , , ,

IDUG Db2 Tech Conference 2018 in Philadelphia

IDUG Db2 Tech Conference 2018 in Philadelphia, Pennsylvania, USA
View the Pdf presentation our VSP presentation on Continuous Delivery
– Db2 12 – 12 months agile production experience with more focus on the Data and less on the base –

Tagged with: , ,

2018-03 RTS RUNSTATS

 „Breaking the rules is often fun, although we cannot condone it. But breaking the rules of Real Time Statistics (RTS) in Db2 12 can really land you in hot water. We provide two queries that may give you a Get

Tagged with: , , , ,

2018-02 Db2 Catalog Statistics revisited

Db2 Optimizer & access path selection for Db2 11 & Db2 12 : Db2 Catalog data | Problematic default values | Correlations in the Db2 Catalog  It has been six years since the last update so I thought, after Terry Purcell’s excellent

Tagged with: , , ,

Southwest Db2 Users Group – February 2018

SEGUS & SOFTWARE ENGINEERING proudly sponsor this event and present:
1 Compliance with compliments! Viable Db2 z/OS workload tracking: A presentation about capturing DDL, DML, DCL and more of the entire workload, by exploiting resource friendly IFCID technology.
2 Db2 12 Continuous Delivery – New challenges for deployment: A presentation about Db2 12 Continuous Delivery and how it affects Db2 migration/maintenance strategies.
3 Db2 z/OS Lies, Damn Lies, and Statistics: A presentation about Db2 RUNSTATS, BIND/REBIND enhancements and how to protect/recover access paths.

Tagged with: , , , , , , , , , , ,

Heart of Texas Db2 Users Group – February 2018

SEGUS & SOFTWARE ENGINEERING proudly sponsor this event and present:
1 Compliance with compliments! Viable Db2 z/OS workload tracking: A presentation about capturing DDL, DML, DCL and more of the entire workload, by exploiting resource friendly IFCID technology.
2 Db2 12 Continuous Delivery – New challenges for deployment: A presentation about Db2 12 Continuous Delivery and how it affects Db2 migration/maintenance strategies.
3 Db2 z/OS Lies, Damn Lies, and Statistics: A presentation about Db2 RUNSTATS, BIND/REBIND enhancements and how to protect/recover access paths.

Tagged with: , , , , , , , , ,

2017-11 Db2 APAR list: An APAR a day keeps the bugs at bay

Db2 12 APAR – time saving list With all the talk about “agile” going on, and referring to one of my older 2017-09 newsletters* on APARS, I think it is time to tell you all about another little service that

Tagged with: , , , , , , ,

2017-10 Db2 log size: How big is your LOG?

  How to validate that your Db2 LOGs are OK ? Sizing of LOGs changed quite a bit in Db2 11 and Db2 12, so I thought a little recap about the correct sizing and ZPARMS was in order this

Tagged with: , , , , ,

2017-09 Db2 12 SQL Access path: Death by APAR

We recently held one of our Design Councils, this one was all about Db2 12 and going Agile. I was asked the following question after one of my presentations about verifying Db2 Code/Catalog/Function Levels: “How many APARs really can affect

Tagged with: , , , , , ,