I thought I would wrap up the month of June 2015 with a few helpful tips and links for you. I get asked all the time and see these questions on various DB2 lists and forums — What features come with various DB2 editions or what features come with my particular edition? Well the answers to these questions can always be found in the DB2 announcement letter. For example, to see what comes with an edition and what the licensing options are you can go to the below link for DB2 10.5 —
Also, the good folks at the IBM Toronto Lab usually do a nice article on the latest release and all the editions and features. For the latest, you will find a nice article at Developer Works.
Bookmark these sites and stay tuned!
http://www.ibm.com/developerworks/data/library/techarticle/dm-1311whichdb2edition/
IBM BLU HUB (www.ibmbluhub.com) is the central website for all things BLU. It contains a plethora of articles, use studies and links to important sites. You should visit this site often if you are a use of DB2 LUW. Check out this quote and nice article from my friend and Program Director, IBM Data Warehouse Marketing.” BLU Acceleration in-memory technology does much more to reduce I/O by taking full advantage of the CPU cache and the system memory , along with techniques like data skipping.)”
Table partitioning was introduced in DB2 9.7. Since then many improvements have been made around table partitioning regarding local indexes, data roll in and roll out and utility operations at the table and index level. With table partitioning, available in DB2 10.5 for you WSE folks out there, you can now use table partitioning. Because of the single index reorg capability and other table high availability features. I’ll be posting an article soon here regarding Maximization of DB2 10.5 Table Partitioning Capabilities. Stay tuned! Check out this 9.7 article on how to get moving with table partitioning.
http://www.ibm.com/developerworks/data/library/techarticle/dm-1006tablepartitioning/
You can do this using shadow tables available in DB2 10.5 FP4. Get the details in the article from my friends in the IBM Toronto Lab….
http://www.ibm.com/developerworks/data/library/techarticle/dm-1409oltap-db2-shadow-tables/index.html
Central PA Regional DB2 User Group
Date: Wednesday June 10, 2015
Place: Giant Super Food Store Community Room, 3301 Trindle Road, Camp Hill, PA 17011
Cost: FREE
Reservations: Email: Odessa Fennen – odessa.fennen@hp.com
Agenda for June 10, 2015
8:30-9:00 Breakfast & Announcements
Sponsored By Gunning Technology Solutions, LLC
9:00-10:15 “Exploiting zIIP Capacity with DB2 for z/OS”
Presenter: Randy Ebersole, IBM
The System z Integrated Information Processor (zIIP) became generally available in 2006 with the z9® architecture. It was introduced to provide a way to have new workload run on the mainframe, by allowing certain workloads to run on the zIIP capacity, without that capacity incurring IBM software costs. This presentation will provide an update on all of the ways DB2 for z/OS exploits the zIIP processor. Monitoring of DB2 and zIIP usage will also be discussed so that the attendee can best understand how to recognize the impact of exploiting zIIP capabilities.
10:15-10:30 Break
10:30-11:45 “What’s new about buffer management using DB2 11 for z/OS”
Presenter: Randy Ebersole, IBM
This session explains some buffer pool tuning considerations when using DB2 11 for z/OS. We will discuss some changes that affect the performance of DB2’s deferred writes and castout processing. We’ll discuss improvements to DB2 buffer metrics that improve your ability to tune your buffer pools. We’ll explain how to better manage real storage and minimize CPU consumption. 11:45 -1:00 Lunch – Sponsored By: Gunning Technology Solutions, LLC
1:00-2:15 “Table Monitors, What’s on the Table?”
Presenter: Leo Pedron, LJP Consulting/Gunning Technology Solutions, LLC
An introduction into using table function monitoring to replace traditional snapshots. Snapshot monitoring has been deprecated in DB2 9.7 and a new lightweight monitoring architecture introduced. Attend this session to learn how to use the new monitoring facilities to replace your former snapshot monitoring in DB2 10.5.
2:15–2:30 Break
2:30-3:45 “Protecting Big Data”
Presenter: Howie Hirsch, IBM
Hackers are everywhere. Is it possible to keep ahead of them? If not, what is the next best thing, which is to provide real time monitoring to reduce the time it takes to discover a data breach is occurring in your shop, and stop it before it can cause damage. We will discuss the ways that this is possible and the items that you need to be on the lookout for to be able to give your enterprise world class protection. 3:45-4:00 Closing
Want to control your inventory with a strategic or tactical view? Analytics by price, size, ski, and location? Price performance analysis? Checkout out this powerful IBM Analytics Retail Solution.
Congrats to all my fellow IBM Champions for 2015! Keep up the good work……..stay tuned.
From an exhibitor standpoint, this IDUG was a big success. Many attendees running DB2 on LUW. Lots of great sessions from the Toronto Lab. Plenty of developers here from the lab. I gave my Achieving High Availability with HADR and TSAMP on Monday and was happy with the session and questions. Many folks stopped at the booth to discuss HADR and TSAMP in more detail. Here is the passport to prizes winner!
Well as I am sitting in my booth waiting for the expo hall to open I thought I would share this with you.
https://www.ibm.com/developerworks/library/dm-1406convert-table-db2105/
Get moving and stay tuned!
I’ve written about this before, but I keep seeing big benefits from using it so I wanted to mention it again. Prior to DB2 9.7 FP3A there wasn’t an easy way to identify unused indexes. It could be done using a couple of different techniques but since FP3A a lastused column was added to syscat.indexes indicating the last time an index was used. I routinely use this to identify unused indexes and clean them up, resulting in less space used and faster table and index reorgs. So if you haven’t been checking this, it makes sense to start now. Stay tuned!
Gunning Technology Solutions, LLC. THE WORLD LEADER IN Db2 LUW CONSULTING! 