This is part 2 of Db2 application tuning for Db2 Explains and db2advis. We are on a mission to make Explains and the Db2 Advisor faster and more efficient. PLEASE review PART 1 as a prerequisite so that the information flow is fresh in your mind before continuing. This blog picks up where Part 1 left off.

[ more .. ]

Would you like Db2 LUW Explains and db2advis.exe to run faster and more efficiently? If so, then this blog is for you! Explain and Db2Advis are applications just like any other, and their performance can be improved by adding indexes to EXPLAIN and ADVISE tables!

In this new series of Db2 LUW Performance blog posts, we will share with you our performance analysis of Db2 EXPLAIN and Db2Advis processing and SQL with the goal of ultimately providing you with CREATE INDEX commands that will make Explain and Db2Advis processing faster and more efficient.

You might be thinking "Who cares?" Well, everyone should care because efficiency is important! And if your management is hounding you for a performance fix to a failing application, you probably want your Explains and Db2Advis to run as fast as possible!

DBI Customers using DBI pureFeat™ Performance Management Suite for IBM Db2 LUW V6.3 or V7.0 will also find this analysis, and the recommended new indexes, very beneficial to DBI's Predictive Index Impact Analysis processing! Briefly, Impact Analysis discovers all of the SQL contributing I/O to a table, then Db2 Explains are run with and without contemplated indexes to ascertain the benefits and risks, if any, of creating a new index.

[ more .. ]

Would you miss your daughter's wedding? Your son's graduation? The birth of your child?

IBM is giving birth to new emerging technologies. Your DB2 Cheese is moving. Will you be able to keep up? Or will you miss the biggest, most important, IBM technology centered event of the year?

IDUG is a non-profit, user run, organization focused on delivering the best education to data professionals, and the IDUG Anaheim conference includes the Data Tech Summit which is focused on not only DB2, but also emerging IBM technologies. If you are a DBA, Manager, Director, Data Architect, or Data Scientist, you must not miss IDUG Anaheim 2017.

Get discounts...

[ more .. ]

The following article on DB2 and SAP is contributed by Martin Hubel. IBM is providing DB2 SAP Road Show Briefings THIS WEEK in select cities. Scott Hayes offers his own commentary on DB2 and SAP. Martin Hubel is an IBM DB2 GOLD Consultant and IBM Champion. He is also one of the world's leading top independent DB2 Consultants with respect to DB2 performance. We hope you find his article thought provoking and helpful.

[ more .. ]

The early bird might be dead, but you can still get a big worm! Use registration code "2016DBI25" and get 25% off your conference registration! This is made possible by a cooperative effort between top IDUG Exhibitors and IDUG inasmuch as vendors are seeking to help boost attendance at this incredible conference! This is just one great reason to attend IDUG EMEA - saving money! Continue reading for more great reasons to attend!

[ more .. ]

The next meeting of Sydney DB2 User Group will be 9th February 2016 at 2pm at the historic Custom House, 2nd Floor Library. Afterward (5pm), the plan is to spend DUGS funds at http://www.tapavino.com.au/ networking. During this DUGs meeting, Frank McEwen has a short presentation on the DB2 LUW package cache, then Scott Hayes, President & Founder of DBI, IBM GOLD Consultant and Champion, will present "Fearless Tuning" which covers...

[ more .. ]

DBI Software Announces pureFeat™ V6.2 Performance Management Suite for IBM® DB2® LUW

NEW Features Make It Easier than Ever
to Fight the RIGHT Fires FASTER

Austin, Texas USA - 23 October 2015 9am CDT - As a DBA or manager, your company counts on you to fight the right fires fast. Today, that task just got much faster and easier with the release of DBI Software's pureFeat™ V6.2 Performance Management Suite for IBM DB2 LUW. Already the acknowledged leader in optimizing IBM DB2 databases, and acclaimed by Database Trends and Applications as one of the Top 100 Companies That Matter Most in Data, DBI's pureFeat V6.2 pulls even farther ahead of the pack by adding many customer suggested enhancements plus a major breakthrough in automated index tuning...

[ more .. ]