Presentation

Content that is a presentation given at a meeting.

Enabling DB2 APPLCOMPAT V11R1...How to use IFCID 366 reports

To enable DB2 APPLCOMPAT V11R1 in your environment, it is necessary to identify and change incompatible functions in dynamic and static SQLs.  This presentation will detail Fifth Third’s approach to identifying these incompatible functions using the IFCID 366 trace and extracts of dynamic and static SQL. The presentation will cover how to interpret IFCID 366 incompatible functions, and how to manage testing and implementation of changes.

DB2 LUW HA redesign and process improvements

DB2 (LUW) HA -redesign (Single to dual disk)
DB2 (LUW) process improvements

DB2 12 Continuous Delivery June 2017_Part2

This deck was too big so had to be broken in to two parts for upload to our server.

DB2 12 Continuous Delivery June 2017_Part1

This deck was too big so had to be broken in to two parts for upload to our server.

DB2 12 Migration Considerations June 2017

With the introduction of function levels within DB2 for z/OS 12, customers can choose when and which enhancements are implemented. These include virtual storage enhancements, new subsystem parameters, optimization enhancements (for static SQL statements, this means package bind/rebind after the function level activation) and new SQL capabilities.

Stored Procedures & SQL PL

Learn to code simple programs in the SQL Procedure Language (SQL PL). This is the language used by most stored procedures being written today on DB2 for LUW and z/OS. We’ll see the basics of the syntax and discover just how easy it is to code stored procedures using this language.

SQL Tuning in the Digital World Part 2

The Digital World includes all kinds of transactions most of which contain SQL. Trapping and fixing nonperforming SQL has gotten more complicated or has it? The speed at which SQL performance problems need to be resolved has shrunken to .1ms or 0 – meaning that they should never happen. Come learn tips and techniques that can assist you in today’s Digital World.

SQL Tuning in the Digital World Parts 1

The Digital World includes all kinds of transactions most of which contain SQL. Trapping and fixing nonperforming SQL has gotten more complicated or has it? The speed at which SQL performance problems need to be resolved has shrunken to .1ms or 0 – meaning that they should never happen. Come learn tips and techniques that can assist you in today’s Digital World.

Trusted Context and Roles – How are you serving up your security?

Abstract:
Practical approaches to how to utilize these DB2 constructs to manage access and ownership of your objects and data. Using ROLE's to own and manage your objects and data can remove auth IDs and groups from the security picture. Useful information allowing you to verify whether you’re environment is as secure as you think it is!
Objective 1: Introduce and define the concepts of Trusted Context and Role
Objective 2: Illustrate how to utilize Role - WITH ROLE AS OBJECT OWNER--AND QUALIFIER

Pages

Subscribe to RSS - Presentation