The 2014 IDUG DB2 Tech Conference now in its 26th year is the premier training event dedicated exclusively to IBM’s industry-leading DB2 product family. The conference includes a robust technical schedule, in-depth seminars, networking opportunities and a vendor exhibition featuring the latest innovations in DB2.
BMC is proud to have sponsored IDUG for over 10 years. Here are some ways you can engage with us and find out how to optimize your mainframe DB2 environment, from sessions to Vendor Solution Presentations (VSPs), to in-booth demos and giveaways, we’ve got a lot in store for you:
1. Session 1: Tame Your Backups without Creating More Work (AO3)
Tuesday, 5/13/2014, 3:15 pm – 4:15 pm
Speaker: Paul Walters, Navy Federal Credit Union and Jim Kurtz BMC Software
Faced with a 10 year old backup process that was running in excess of 24 hours and impacting other database activities such as LOADs, MODIFYs, REORGs and normal system outages, the Navy Federal Credit Union (NFCU) needed to quickly and reliability deploy a new backup strategy that would meet their scheduling requirements without creating maintenance issues or impacting the reliability of their recovery process
2. Session 2: A DB2 Workload Tuning Methodology (EO5)
Wednesday, 5/14/2014, 8:00 am – 9:00 am
Speaker: Phil Grainger BMC Software
Instead of tuning your SQL one statement at a time, why not look to the advantages of tuning an entire workload of SQL instead? Workload SQL tuning can not only provide faster returns on the investment in tuning time and effort but will usually provide bigger savings of cpu and other resources. Workload tuning can also avoid the unfortunate “Silly Putty” situation where improving the performance of one SQL statement can have unexpected detrimental effects elsewhere! Apart from tactical emergency corrections to individual SQL statements, workload SQL tuning should be the preferred mechanism to ensure that application SQL and the underlying database design work together in the most efficient way possible This presentation walks through a typical workload tuning methodology
3. Session 3: DB2 11 Expanded RBA/LRSN – Does this bit make my tail look big? (AO6)
Wednesday, 5/14/2014, 9:15 am – 10:15 am
Speaker: Ken McDonald , BMC Software
DB2 has had a 6 byte RBA since the beginning and a 6 byte LRSN since DB2 Version 4. IBM is introducing the ability to optionally expand the RBA and LRSN to 10 bytes in DB2 11. This change will have fairly far reaching implications on many DB2 structures that have carried a 6 byte RBA since the beginning over 30 years ago. This presentation will raise some of those implications by discussing where RBA values currently reside in the DB2 universe. Details of old versus new formats will be provided. The source of the presentation title? Every page on a DB2 object, both table and index spaces, ends in a structure called PGTAIL. In the expanded world, this becomes PGBIGTAIL.
4. Session 4: Advanced Copy Techniques (G11)
Thursday, 5/15/2014, 1:00 pm – 2:00 pm
Speaker: Tom Price , BMC Software
During the last several years, a number of new techniques have become available for making copies and backups of DB2 data. Each of the methods has certain requirements e.g. special hardware or software licenses, has significant advantages in some cases, and 5/have problems in other cases. This presentation discusses the requirements, advantages, and problems with several new techniques. This discussion should help you decide which methods are the best for your systems.
5. Session 5: Building your DB2 War Room – Your System Health at a Glance (E12)
Thursday, 5/15/2014, 2:15 pm – 3:15 pm
Speaker: Lindsay Keim, State Farm Insurance and Kevin Pintar , BMC Software
Meeting today’s service level agreements for response time and through-put while trying to reduce costs is a challenge that every DB2 Performance, Admin and Application team faces. This two part presentation will focus on monitoring techniques for making your performance team a success. We will explore a large DB2 installation’s approach to quickly identifying and resolving DB2 performance opportunities using custom built dashboards. Secondly, using BMC’s DB2 Health Navigator, we will rapidly diagnose performance issues in several key functional areas such as logging, locking, and buffer pools.
6: Workbench: BMC Workbench for DB2 – Secure self-service tooling for DB2 for z/OS (VSP 1)
Wednesday, 5/14/2014, 1:00 pm – 2:00 pm
Speaker: Phil Grainger, BMC Software and Jim Kurtz, BMC Software
As our typical mainframe workforce starts to look towards retirement, there is becoming a need for more functionally rich interfaces than the historical ISPF screens
BMC Workbench for DB2 brings the power of a graphical interface to the world of DB2 tools
Running in a web browser, thus obviating the need for ANY local installation of software, BMC Workbench for DB2 provides secure self-service access to both DB2 and to the BMC DB2 toolset
Initially targeting application developers, Workbench delivers catalog browsing, access path analysis, statement tuning, job submission and many more activities in a familiar graphical environment
Come to our VSP and see a LIVE demo of the latest version of BMC Workbench for DB2
7. DB2 Recovery: DB2 z/OS Recovery Pay Now or Pay Later (VSP 2)
DB2 for z/OS Recovery: Preparation and Practice
Thursday, 5/15/2014, 10:30 am – 11:30 am
Speaker: Chad Reiber
When was the last time you had to do a recovery? Or should I ask when was the last time you thought about recovery in your day to day activity. Let’s take it to the next level when was the last time you actually practiced a recovery? Today many of us think our DB2 databases are recoverable because we have mirrored DASD to some remote site and recovery is as easy as bringing up the system on that alternate site. But life is not so easy – a little work now can save many sleepless days or should I say weeks when something goes very wrong.
It is not all about having the state of art DB2 recovery tools – it is putting in the time to build the process so if something happens (and it might just be waiting to happen) you are ready to react. This presentation will review potential ways to prepare and practice DB2 recovery. Many BMC and DB2 native utilities and products will be discussed.
8. Tuesday Reception 5:30-7:30
9. Sponsor Showcase Theater
Tuesday, 5/13 5:30-7:30 pm
Wednesday 5/14 11:30 am – 1:00 pm, 4:30-6:00 pm
Thursday, 5/15 11:30am – 1:00 pm
10. Workbench for DB2
BMC Workbench for DB2 provides self-service for application developers who prefer web based access to information about DB2, and for experienced DB2 DBAs who want an easy-to-use GUI approach for some of their tasks. BMC Workbench for DB2 is a component of BMC Object Administration and BMC Performance for DB2 SQL offerings.
11. SQL Performance for DB2
BMC SQL Performance for DB2 diagnoses application performance problems, thereby reducing overall costs. BMC SQL Performance for DB2 integrates the functionality of the following products and technologies into a single offering that helps you optimize performance and availability by tuning the application SQL or physical database design.
12. Backup and Recovery for DB2
BMC Recovery Management for DB2 provides automation and advisory-level features to enable rapid backup and recovery, including recovery any timestamp or log point, high-speed transaction recovery, backout recovery, and instant recovery using intelligent hardware.
13. Object Administration for DB2
With BMC Database Administration for DB2, you will ensure application and data integrity, improve productivity by simplifying DB2 catalog navigation and change management, mitigate risk by synchronizing changes with related objects and enhance application availability by performing maintenance with minimal outages.
14. High speed utilities for DB2
This solution provides catalog and change management tools and high speed utilities to support objects throughout the application life cycle, enables version control for added flexibility recovers inadvertently dropped DB2 objects and enables you to back-out changes.
15. MainView for DB2
As your business grows, so does your data—along with the costs to manage it. BMC MainView offers the most CPU-efficient monitoring and management solution in the industry, shifting up to 70% of monitoring overhead from MIPs to zIIPs. The result? More room to process business applications, and performance management that corrects issues before they even have a chance to cost you money.
16. MLC Cost Reduction – Cost Analyzer for zEnterprise
BMC Cost Analyzer for zEnterprise incorporates the complexity of MLC pricing into an easy to use solution for actively managing MLC costs. By analyzing utilization and cost data, BMC Cost Analyzer for zEnterprise portrays the system peaks and cost drivers so you can identify cost-reducing strategies. Robust graphical reporting gets you started and powerful “what-if” planning capabilities let you test-drive changes and see the cost impacts those might have before you commit to any changes.
17. DB2 Reference Book
Get your DB2 Reference Book!
18. DB2 Reference Poster
19. Mainframe 50 T-Shirt