IDUG Db2 Tech Conference 2018 in Malta

IDUG Db2 Tech Conference in Malta 2018

IDUG EMEA

SEGUS & SOFTWARE ENGINEERING präsentieren:

1 – Workload Replay in a Continuous Delivery world

> Pdf Präsentation

2 – An Audit a day keeps the lawyers at bay!

> Pdf Präsentation  –  AppDev & Analytics II Präsentation

1 – Workload Replay in a Continuous Delivery world

Is your production cloning for development/test a quick and fully automated procedure? Does it consider differences of the underlying hardware and does it allow to choose and automatically run SQL workloads?

By using a highly customizable XML script and exploiting virtualization features we can make a clone YOUR clone and even make it behave like production. Most importantly SQL Capture/Replay fills the gap of automatically running your production workload for testing. It captures production SQL 24/7 by exploiting highly efficient IFCID-via-OPx technology and prepares statements for replay. This enables you to capture any SQL being executed and keep them in sets of workloads to be selected for testing.

Learn how to integrate individual tasks for flexible automation and how to choose from four different levels of testing. These include simple anomaly alerting, access path verification, cloning and workload capture/replay to easily discover different behavior resulting from changes, like new application releases, or environment upgrades. Find out how easily you can pick and choose with Continuous Delivery Deployment Check from Software Engineering GmbH.

Mehr über Db2 Continuous Delivery – CD

Presentation Outline

1. Testing, virtualizing and simulating – the aspects of reliable quality assurance
2. Db2 database/object cloning – what’s state of the art and what’s beyond
3. XML commander – The comprehensive automation of flexibility, covering
   • FTP/Routing
   • JCL
   • ISPF file tailoring, panels, messages
   • Db2 Commands
4. Emphasizing the Data – what has changed since July and what are the hybrid aspects managing Data
   – Anomaly alerting based on Incompatibility Change Indicators (ICIs)
   – Dyn./Stat.Access Path Change Detection e.g.via Plan Management
   – Cloning exploiting Backup System
   – Workload-KPI verification using SQL replay and KPI comparison
5. Top 10 list of tips and gotchas from a year of Db2 12 production Data bases around the world

Audience Experience: Intermediate Advanced
Platform: Db2 z/OS
Presentation Length: 60 minutes
Presentation Category: Database Administration, Performance Management, Db2 Migration

Speaker biography

Roy Boxwell has more than 32 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, speaker and contributor on the IDUG Db2 Listserv and sends out a monthly Db2 z/OS Newsletter.

2 – An Audit a day keeps the lawyers at bay!

With GDPR and a bunch of other laws either in force or „coming soon to an auditor near you“ it is time to bite the bullet and start working with the auditor not against.

Mehr über Audit for Db2 z/OS

Speaker biography

Roy Boxwell has more than 32 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, speaker and contributor on the IDUG Db2 Listserv and sends out a monthly Db2 z/OS Newsletter.