Search

1 to 7 of 7
Sort by

Blog Entry
DBI Software pureFeat™ Performance Management Suite for IBM DB2® LUW

Introduction Thank you IDUG for the invitation to contribute an article about DBI Software’s pureFeat™ Performance Management Suite for IBM DB2 LUW. For the past four consecutive years, Database Trends and Applications Magazine (DBTA) has honored DBI pureFeat as one of its Top 100 Trend...

Scott Hayes's profile image

Blog Entry
DB2 Basics: Writing SQL with Examples on DB2 10.5 System Views and Table Functions

Some DBAs write SQL every day and others not as much. Come and learn the basics of writing SQL along with a few tips on more advanced features of SQL. Examples will use system views and table functions available in DB2 10.5. This video is geared towards DBAs who don't write SQL on a regular...

Ember Crooks's profile image

Blog Entry
Shadow Tables – Performance observations using Infosphere Change Data Capture

by Somu Chakrabarty and Iqbal Goralwalla, Triton Consulting IBM has introduced the concept of shadow tables in DB2 10.5 Fixpack 4 (also known as the “Cancun Release”) to avoid separate OLTP and OLAP databases and to improve analytic query performance in a single OLTP database without using...


Blog Entry
Reducing Storage Costs in DB2 for LUW

Mark Gillis and Iqbal Goralwalla, Triton Consulting According to a recent Gartner report, data growth is the biggest data center hardware infrastructure challenge for large enterprises. As such, reducing storage-related costs remains a top priority for these organizations. Over the past...

Mark Gillis's profile image

Blog Entry
IDUG Tech Talk: Monitoring BLU Acceleration in Depth by David Kalmuk

The BLU Acceleration Technology introduced in DB2 10.5 brings with it a host of new monitoring considerations and metrics. This session will introduce you to the new monitoring capabilities that support BLU Acceleration and through practical examples will show you how you can leverage these in...


Blog Entry
Want to run DB2 LUW Databases Faster? by Scott R Hayes (DBI Software)

Want to run DB2 LUW Databases Faster? Put your database processing costs on a Diet! In 2014, I presented “Sage Advice: 20 Invaluable DB2® LUW Performance Insights from Around the Globe” at IDUG Phoenix, IDUG Prague, to regional DB2 User Groups in Minneapolis, Milwaukee, and Chicago,...

Scott Hayes's profile image

Blog Entry
IDUG Tech Talk. Access Paths for DB2 10.5 for LUW Column Based Tables by Mark Gillis

One of the selling points of DB2 10.5 and the Columnar options is that existing row-based tables can be converted to column-based tables and will be accessed by DB2 seamlessly and with no extra effort from the DBA. All well and good, and the performance should be much better, but what if it’s...