Identifying SQL Queries that waste your CPU may not be as simple as it seems. Just to rely on observations or SMF reports tend to show only long running SQL statements, while many “fast” ...
Jupyter Notebooks provide the framework for interactive reports, presentations, and more. In our presentation we introduce the basics of Jupyter Notebooks and show how data from DB2 ...
This presentation will provide an overview of the DB2 10.5/11.1 security mechanisms that are currently available and bring you up to speed on things that must be taken into consideration ...
EXPLAIN is one of the most valuable tools for performance analysis. Like the DB2 internal SQL optimization it's also based on statistics. For new DB2 applications and those with changing ...
Get ready to go deep with Structured Query Language (SQL) and become a power user. Whether you are being asked to solve complicated problems with SQL or you need to read and understand ...
Triggers have now been with us since Version 6 of DB2 (1999!) so it is perhaps time for a refresher. This presentation starts with a recap of the different types of trigger (including ...
Based on extensive user experience, this presentation provides an insight into Partition by Growth (PBG) tablespaces including an overview of how they work; the mechanics of creating ...
Support and usage of XML data type in DB2 for z/OS is still evolving. XML and XML-based languages plays important role in a data transfer and application development. This presentation ...
This presentation will provide you with practical experience in using the dynamic statement cache for SQL tuning purposes. This way you are able to obtain much more precise information ...
New and/or additional features such as IDAA Loader and Accelerator Only Tables (AOT) allow to use the IDAA platform as the central element for data analysis. This presentation demonstrates ...