Cross Platform DB2 for z/OS & LUW

536 Entries
 
 
5 years ago
Be the first person to recommend this.

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” ...

Attachments
5 years ago
Be the first person to recommend this.

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 ...

Attachments
5 years ago
Be the first person to recommend this.

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 ...

Attachments
5 years ago
Be the first person to recommend this.

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 ...

Attachments
5 years ago
Be the first person to recommend this.

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 ...

Attachments
5 years ago
Be the first person to recommend this.

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 ...

Attachments
5 years ago
Be the first person to recommend this.

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 ...

Attachments
5 years ago
Be the first person to recommend this.

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 ...

Attachments
5 years ago
Be the first person to recommend this.

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 ...

Attachments
5 years ago
Be the first person to recommend this.

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 ...

Attachments