Archiwa

We have many options when using Db2 software: – Db2 Local Warehouse (nowadays BLU MPP) – Db2 Warehouse on Cloud (dashDB) – IBM Integrated Analytics system (Sailfish) What are purpose of those? Why so may offerings? What are common things here? What are differences? Most important – which one is best for you? In this … Czytaj dalej

Understanding “the normal behavior” of the DB2 applications (static as well as dynamic SQL) can be a challenge, but using existing performance metrics and baseline these could put you in a situation where you can take action before the SLA’s are violated and even save you a lot of headaches in the “war room” finger … Czytaj dalej

There are many ways to learn about a new DB2 version, but using the catalog is probably the fastest and most enlightening. Once you look at the revision track in the DB2 Catalog and Directory section of the SQL Reference Guide, study the column changes, additions as well as new catalog tables, you have a … Czytaj dalej

This presentation discusses the performance highlights of the latest Db2 for z/OS version. Topics that will be discussed are overall performance enhancements to existing features as well as new performance related features, such as Fast Index Traversal, Contiguous Buffer pools, and Fast Unclustered inserts to name a few.  As a co-author of the DB2 12 … Czytaj dalej

This covers many standards, guidelines every IT department should have for SQL programming This covers many of the efficiencies/inefficiencies of the SQL code This cover many of the ‘Do not code this way’, ‘Code this way’ examples This is a great start for developers to know possible SQL issues Great SQL examples throughout

This covers many examples of Db2 explains using the tool. This covers how to read and analyze visual explain output. This covers filter factors, query rewrites, transitive closure, statistics And more….

This covers the SQL-PL language best practices, error handling, etc.

This covers the many different ways to write queries obtaining the same result. Performance on each is described. Great advanced SQL examples throughout

This covers many SQL tuning standards/guidelines and best practices This covers Do’s and Don’t’s of coding, stage 1 and stage 2 predicates,  indexable and non-indexable predicates, statistics, design, new SQL features

This session focuses on Db2 12 for z/OS, the most recent release of IBM’s flagship relational DBMS product for the mainframe. This presentation gives a technical overview of Db2 12, and offers an update on the strategic roadmap, client experiences, and recent continuous delivery content. Among many recent innovations are: improvements to enhance application performance … Czytaj dalej