Database codepage conversion can be a tricky business. Beginning with a general overview of codepages, where they are specified and where conversion is done, we cover also collation orders and their performance impact. Then we discuss the conversion process itself, including pitfalls, where the app vendor stores strings in different codepages, unknown to Db2. This requires special export/load considerations. The audience will learn how to do a successful conversion.
Performance is a crucial thing for each database. Frequent health-checks are required in critical environments. During this presentation we will discuss db2mon – a tool (script) used for light-monitoring of your Db2 database. Step by step the tool would be run and results analyzed.
Db2 comes with a smart query optimizer which tries to execute every query with best access plan. How to tell the optimizer what to do? Which join method to use or at which optimization class run your queries for a specific session? During this presentation we will discuss how optimization profiles can be created and maintained. Optimization guidelines with examples will also be covered.
One of the most important trends in Application Development over the last few years has been the explosion of interest in using RESTful APIs. This session will eplain why this has happened, the benefits and drawbacks of using RESTful APIs and how Db2 for z/OS now provides strong support for using them in your own applications. We’ll then provide a step by step instructions of what you need to do to develop your own Db2 for z/OS applications using RESTful APIs, using a simple example as a guide.
European SQLAdria Seminar – Vodice 2024
SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.
8 reasons to come Speakers Events Contact
VODICE - 10th - 13th June 2024