Tri-State Db2 Technology Exchange
Db2 Users Group
Download PDF
Watch recording (logged in Tridex members only)
Session title: Db2 Query Optimization 101 session
Session abstract: 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 plans for the variety of features and table organizations supported by Db2.
Registered Tridex members can also watch a recorded version of this presentation. Please make sure you’re logged in to access this protected content. Continue reading “Db2 Query Optimization 101 session”
Download PDF
Watch recording (logged in Tridex members only)
Session title: Best practices: Step by step instructions to configure a secure database system
Session abstract: From installation to rolling into production ; security impacts every step of setting up a database system. From the OS ; to authentication ; authorization ; encryption and auditing ; a locked down database is a necessity in today’s world.
Continue reading “Best practices: Step by step instructions to configure a secure database system”
Registered Tridex members can also watch a recorded version of this presentation. Please make sure you’re logged in to access this protected content. Continue reading “Best practices: Step by step instructions to configure a secure database system”
Download PDF
Watch recording (logged in Tridex members only)
Session title: Light at the end of the encrypted tunnel
Session abstract: Transport Layer Security (TLS, aka SSL) is the foundation of encrypting data in motion. This presentation will cover the fundamental principals of TLS encryption and working with certificates.
Registered Tridex members can also watch a recorded version of this presentation. Please make sure you’re logged in to access this protected content. Continue reading “Light at the end of the encrypted tunnel”
| 09:00 – 10:20 | Les King, IBM Db2 Update |
| 10:20 – 10:30 | Break |
| 10:30 – 11:30 | Ember Crooks, IBM How to Do Almost Everything (to Administer Db2) via SQL and Jupyter Notebook |
| 11:30 – 11:45 | Break |
| 11:45 – 12:45 | Maryia Rakina and Shalini Wirth (Ramamurthy), IBM What’s new in the Data Management Console and dcmtop |
Download PDF
Watch recording (logged in Tridex members only)
Session title: Db2 Update
Session abstract: In this session we will be taking a look at the latest release of Db2. Db2 11.5.5 just hit the market at the end of 2020 and has a lot of new high value capabilities such as addressing the needs of modernization, both from a deployment perspective and from a workload perspective.
Registered Tridex members can also watch a recorded version of this presentation. Please make sure you’re logged in to access this protected content. Continue reading “Db2 Update”
Download PDF
Watch recording (logged in Tridex members only)
Session title: How to Do Almost Everything (to Administer Db2) via SQL and Jupyter Notebook
Session abstract: Over time, Db2 has added the ability to do more and more via SQL. Join this session to learn how to administer Db2 largely through SQL. Examples will be provided via Juptyer Notebook, but will be entirely in SQL. All examples will be run remotely, requiring no direct server login.
Continue reading “How to Do Almost Everything (to Administer Db2) via SQL and Jupyter Notebook”