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...
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...
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...
1 Comment - no search term matches found in comments.
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...
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...
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,...
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...