Ember Speaking at DB2 Symposium in Eindhoven on 11 June

For the 5th blogiversary of db2commerce.com, I’m taking a European trip. It has been more than decade since I’ve been overseas, so I’m very much looking forward to it.

I’ll be speaking at the DB2 Symposium in Einhoven on 11 June! I’ll be giving a day-long intensive on Lessons Learned Running DB2 for E-Commerce. An outline of what I’ll be talking about:

  • High Availability – The Database has to be Online Before Anyone Cares About Performance
    • Overview of high-availability options and considerations
    • How does HADR work – knowing the details can help you make configuration decisions
    • How to set up HADR – a step-by-step guide
    • Using the HADR tools – HADR Simulator, DB2 Log Scanner, and the HADR Calculator
    • How to set up TSAMP to automate HADR failover – another step-by-step guide
    • TSAMP Advanced Topics – beyond db2haicu
  • Monitoring E-Commerce and Transaction-Processing Databases
    • Looking for database problems and helping others look for problems at other layers
    • What to watch during peak retail and transactional periods
    • Using db2top for real time monitoring and lock investigation
    • Using db2pd for system investigation
    • Using the MON_GET* table functions
  • Indexing Tips From the Real World
    • Why low-cardinality indexes are bad for performance
    • Finding problem SQL that could benefit from indexing
    • Mining your package cache for problem SQL
  • Data Pruning – Smaller is Better!
    • Separating workloads for best performance
    • Tips and tricks for deleting large amounts of data
  • Useful SQL for Administering DB2 Databases

The DB2 Symposium is a slightly different format than other conferences and educational opportunities. It provide three days, each with a different speaker with tracks for DB2 for LUW and for Z/OS. It is a fairly small group setting that allows attendees to really connect with the speaker.

You can still sign up if you’d like to attend. There are a couple of great LUW options on 10 June as well – you can sign up for just one day or for multiple days.

Ember Crooks
Ember Crooks

Ember is always curious and thrives on change. She has built internationally recognized expertise in IBM Db2, spent a year working with high-volume MySQL, and is now learning Snowflake. Ember shares both posts about her core skill sets and her journey learning Snowflake.

Ember lives in Denver and work from home

Articles: 554

One comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.