Db2 Performance: Tuning Db2 LUW Explains and db2advis, Part 1

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


IDUG Vendor Sponsored Discounts! Save 25% off your IDUG Registration!

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?

IBM DBI BMC logos - Make Magic Happen with DB2

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


IBM DB2 and SAP - A marriage made in heaven? Or Not?

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


Great Reasons to attend IDUG EMEA in Brussels!

2016 IDUG Brussels, Belgium Nov 13-18 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.. ]


Announcement: DB2 User Group Sydney (DUGS) Free Seminar 9th FEB

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

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


Updated: IDUG NA Philadelphia News and Scott Hayes' Recommended Sessions

No doubt, IDUG NA Philadelphia offers a plethora of DB2 education and networking opportunities! It can be hard to decide which sessions to go to, especially if you don't know the speakers or if you are new to IDUG. This blog contains my technical session picks, plus links to Twitter accounts that you should follow for more news and updates...

IDUG NA 2015 DB2 LUW SESSION BINGO!

C01 :: C02 :: C03 :: D04 :: C05 :: C06 :: D07
C08 :: C09 :: D10 :: C11 :: D12 :: C13 :: C14
C15 :: C16 :: D17 :: C18 :: D19 :: E20 :: D21 icon_wink You win!

[ more.. ]


Press Release: PrimeSource Building Products runs SAP on DB2 LUW 4X Faster

DBI Software's pureFeat™ Tools for DB2® Empower PrimeSource Building Products SAP® Database to Run Four Times Faster---In Less than 24 Hours

Thanks to DBI Software, PrimeSource Building Products foregoes hundreds of thousands of dollars in CPUs, memory, and licenses while ADDING its Canadian data and users to its SAP DB2 database

Austin, TX USA (March 26, 2015): Dallas-based PrimeSource Building Products, one of the largest purveyors of fasteners in the world and one of the largest distributors of building materials in North America with 39 distribution centers and 1,200 employees across the United States, Canada, and the Caribbean. In March of 2014, as a growing, vibrant company with dynamic customer-driven leadership, PrimeSource Building Products was facing one of the most serious problems a thriving company can encounter: their SAP DB2 database had become painfully slow, affecting orders and inventory control. The result: a rising chorus of complaints.
Read more...

[ more.. ]


DBI Software Announces pureFeat™ V6.1 Performance Management Suite

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

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

Austin, Texas USA - - 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.1 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.1 pulls even farther ahead of the pack by adding two powerful features: Stored Procedure Visibility and Current Activity Functions...

[ more.. ]


IDUG NA PHX News and Scott Hayes' Recommended Sessions

IDUG News, Updates, and Recommended Technical Sessions LIVE from Phoenix AZ! The weather is AWESOME - sunny, warm, 0% chance of rain all week! Here's the latest scoop on BREAKFASTS, events, tech sessions, and more...

[ more.. ]


FREE IDUG Phoenix AZ Exhibit Hall Pass

Will you be in the Phoenix AZ area during May 13-15? Are you a DB2 professional? DBI Software invites you to join us, free of charge, in the IDUG Exhibit Hall, booth #105, with this FREE PASS! Check out the latest DB2 solutions and enjoy magic performed by professional magician Frank Velasco at DBI's Booth #105!

[ more.. ]


Press Release: HealthPlan Services selects DBI for IBM DB2 LUW Successes

DBI Software celebrates IBM DB2 LUW performance successes with HealthPlan Services

Austin, Texas USA - (March 27, 2014) - HealthPlan ServicesSM (HPS), the nation's leading technology, sales, retention and administrative services provider for the insurance and managed care markets, has selected DBI Software's pureFeat™ Performance Management Suite for IBM DB2 LUW as its strategic DB2 performance monitoring, tuning, and trend analysis tool.

As the insurance industry adapts to the requirements of the Affordable Care Act (ACA) of 2010, visibility and importance of the consumer experience has never been higher. By partnering with DBI Software, Tampa, Fla.-based HPS has taken important proactive measures to help provide its clients and their members with a quality website and superior application performance...

[ more.. ]


Updated: DB2 LUW Performance Tuning Blogs: Greatest Hits

Recently we've been analyzing which of the DB2 LUW Performance Blogs are the most popular. This presents us with an opportunity to weed out the clutter (news and announcements) and organize the most helpful blogs into a single indexed resource for your convenience. Here's most everything you need to know about DB2 LUW monitoring and tuning...

[ more.. ]


Hewlett-Packard Company and DBI Software announce new partnership

Offering enhanced IBM DB2 LUW services and software solutions for a global market

Austin, Texas USA - (December 11, 2013) - DBI Software, an industry leading IBM DB2 LUW performance tools provider, announces a new multi-faceted partnership with Hewlett-Packard Company (NYSE: HPQ). This partnership pairs DBI's revolutionary database monitoring, tuning, and trending tools with HP's outstanding customer relationships to bring a truly powerful DB2 database support solution to the market. Under this partnership, HP will offer DBI's tools as part of its managed services customer outsourcing agreements to accelerate value for HP clients and, for non-outsourced clients, HP will be a DBI authorized reseller.

[ more.. ]


Take a quick 5 question survey for a chance to win $50 Amazon.com Gift Card

2013 Dec 20 Update- Winning Ad: #3, Zero to Hero - Survey Winner: Barry Leb, CNN

DBI pureFeat™ Performance Management Suite for IBM DB2 LUW was just honored by DBTA as a Top 100 Trending Product for 2014. No doubt, DBI offers great tools! However, marketing is not our specialty! Take a short 5 question survey and help us choose the best banner ad for web advertising! Please!

[ more.. ]


Want to attend IDUG NA 2014 in Phoenix for Free?

The IDUG North America 2014 Call for Presentations is OPEN through 4 October 2014! If your presentation is selected, IDUG will give you a free badge! If you speak about your experiences and successes with DBI's pureFeat™ Performance Management Suite for IBM DB2 LUW, DBI will support you with travel and living expenses! THAT'S FREE! Hurry! Not a DBI customer yet? We can fix that too!

[ more.. ]


The IDUG DB2 Tech Conference in Barcelona is coming 13-18 OCT!

Are your bags packed yet? Updates!

IDUG EMEA 13-18 OCT Barcelona Spain Logo The 2013 IDUG DB2 Tech Conference in Barcelona, Spain is the premier training and networking event dedicated exclusively to IBM's industry-leading DB2® product family. This event features DB2 thought-leaders and developers from around the globe. Get the best in DB2 education and training directly from the experts. You will also find a Solutions Centre offering the latest DB2 products and services, including DBI Software where well be featuring DBI's pureFeat Performance Management Suite for IBM DB2 LUW. Click the logo at left for up-to-date information including registration, the full session schedule and more! Here's more conference news...


[ more.. ]


Scott Hayes' picks for #IDUGNA #DB2 Tech Conference Sessions

Deciding what sessions to attend can be quite difficult, especially given the selection of awesome sessions this year at IDUG. Michael Krafick offered some good advice in his guest blog on DB2commerce.com. In this blog post, I'm going to sort out my schedule for the week. Hope to see you in the conference rooms!

[ more.. ]


IBM DB2 LUW TOOLS PROVIDER DBI SOFTWARE RECEIVES MAJOR OUTSIDE INVESTMENT

DBI Team Grows to better serve
its expanding worldwide customer base

Austin, Texas USA - (April 25, 2013) - DBI, a software company providing professional grade database performance management tools, today announced substantial investment from private equity investors and new team members dedicated to accelerating company growth. Jason Paull is appointed as DBI's new CEO and Lee Goddard joins DBI as its Chief Performance Architect. More...

[ more.. ]


Going to #IDUG Orlando? Bookmark this page on your mobile device!

Bookmark http://www.DBISoftware.com/idugna13.php to view #IDUG or #IDUGNA tweets for the latest news, information, and gossip on the IDUG DB2 Tech Conference in Orlando. Check it out!


The two most powerful words in the English language: FREE FOOD!

Actually, "free beer!" But, CLICK HERE for a FREE PASS to the IDUG Orlando Exhibit Hall, then come visit DBI Software in booths 103/105 to learn about DBI's PureFeat™ Performance Management Suite for DB2 LUW!

IDUG Banner



Top 10 Reasons to attend IDUG Orlando Apr 29 - May 3

Perhaps you've read or seen the "official" IDUG Top 10 Reasons for attending this great conference. Here are the "unofficial" Top 10 reasons from my point of view with embellishments. Whether your company sends you or you have to spend your own dime to invest in your education and career, just get to IDUG! The Top 10...

[ more.. ]


DB2 LUW Performance: Good News! A new IBM Red Book is Born!

Get your free PDF copy of Unleashing DB2 10 for Linux, UNIX, and Windows! Here is an abstract of the new book...

[ more.. ]


DB2 LUW Performance Analysis and Tuning Workshop at IDUG AP, Sydney, AUS

IDUG AP Sydney, September 12-14, 2012
Sydney Harbour Bridge

In 2010 and 2011, the "DB2 LUW Performance Analysis and Tuning Workshop" drew top attendance numbers in North America, Australia, and EMEA. For 2012, this IDUG Ed Seminar has been updated and is being offered again as session 1084. Click Here for Details. THIS SEMINAR WILL NOT BE OFFERED AGAIN after 2012! This is your FINAL OPPORTUNITY to reap the rich benefits of this class!

In this full day class, you will receive over three dozen SQL Snapshot commands to help analyze YOUR database. Together, we will learn about what to measure, we will discover the problems and "opportunities for improvement" in your database, we will discuss solutions, and you will return to your office fully equipped to make measurable performance improvements.

This blog post contains the specific instructions that you should use to prepare for this workshop...

[ more.. ]


IBM DB2 9.7 Advanced Application Developer Cookbook

I've recently had the good fortune of reviewing the book IBM DB2 9.7 Advanced Application Developer Cookbook by author Sanjay Kumar. Sanjay will be the special guest of The DB2Night Show™ on 15 June 2012 at 10am CDT for Episode #85 talking about OLAP, Stored Procedures, Optimization Profiles, PL/SQL, SQL tips, and more! Frankly, I think the book title does this book a disservice, for the content is much broader than just application development. DBAs should also find the book to be a very useful resource...

[ more.. ]


DBI Software offers new competitive pricing to accelerate value ...

DBI Software offers new competitive pricing to accelerate value
and lower IT Costs

Trade-in, Trade-up, and Swap-out competitive software database performance products and receive license credits

Austin, Texas USA - (May 23, 2012) - DBI, a software company providing professional grade database performance management tools, today announced special pricing incentives for IBM DB2 LUW customers that acquired performance tool licenses from IBM or other vendors. Similarly, Oracle customers that acquired OEM performance tools, or tools from other vendors, will receive credits.

[ more.. ]


Find all of the #IDUG #DB2 Tech Conference Twitter Buzz in one Place!

Watch or Join the #IDUG (or #IDUGNA) DB2 Tech Conference Twitter Conversation: Visit and bookmark http://bit.ly/idugna12 to monitor IDUG Twitter Conversations. Feel like contributing to the discussion? Use hash tag #IDUGNA or #IDUG.

DBI is a GOLD Sponsor of the IDUG DB2 Tech Conference in Denver and is pleased to provide this additional free service to the DB2 community.


#IDUG #DB2 Tech Conference Denver 2012 "Best Bets" Part 2

This is part 2 of "Best Bets" for The IDUG DB2 Tech Conference in Denver. Suggested sessions for DB2 LUW on Thursday and Friday are highlighted in this blog post. Monday, Tuesday, and Wednesday are discussed in PART 1.

[ more.. ]


#IDUG #DB2 Tech Conference Denver 2012 "Best Bets" Part 1

The IDUG DB2 Tech Conference in Denver begins next week. The agenda is "amazing" and perhaps overwhelming, especially if this is your first IDUG. I will be attending DB2 LUW sessions as much as possible. I wish I could be in two or three places at once, but, since I have to choose, here is my road map to sessions and activities...

[ more.. ]


DBI Software announces new IBM DB2 LUW performance tool releases

DBI Software announces new IBM DB2 LUW performance tool releases offering new features and support for DB2 10

Austin, Texas USA - (May 8, 2012) - DBI, a software company providing professional grade database performance management tools, today announced Brother-Panther version 5.2 with general availability May 23, 2012. Already recognized by the DB2 IT community as a best in class performance monitoring, tuning, and trending tool with its innovative SQL workload aggregate analysis and trend charts that track change events, this new release incorporates several new customer requested enhancements, lower overhead, support for DB2 10, and support for the z/Linux operating system.

[ more.. ]


Page :  1 2 3 4 5