Next MDUG Seminar

Date: June 14, 2007

Hotel: The Hotel Baronette (Novi)

Seminar Program - FINAL

Program Details

In this presentation, Jim identifies several new locking enhancements added to V7 and V8 to improve application availability. He'll also describe the new locking scheme used in V8 to reduce global lock contentions in a data sharing system. Jim explains how concurrency control is done by DDL, DML, and Utilities. He'll give you guidelines to design databases to improve concurrency. Jim will tell you how optimistic locking is done using static scrollable cursors. He will also explain how LOB locking is accomplished.

In this presentation, Jim will identify buffer pool enhancements made in DB2 V7 and V8. He'll review the performance benefits of using data space buffer pools versus Hiperpools with large real memory in z/OS. Jim will also cover how buffer pools are managed in V8. He'll also describe new enhancement made to the group buffer pool to improve batch application performance in a data sharing system. Jim will cover data sharing enhancements made in V8 to improve LPL recovery. He will also describe changes made in V8 to allow DB2 to scale when supporting larger numbers of open data sets. Finally, he will mention the future directions in DB2 buffer pool management.

What are the most important things that the beginning DB2 professional needs to know about performance tuning? What do you tune first: poorly-performing applications, SQL, buffer pools, indexes, what? If you can't afford tools, what information is available without them? What basic reports do I need to use in my job? How do you set your priorities on what to tune, and in what order? What are the most common performance challenges, and what are their potential solutions? Are there any standards or guidelines for determining what to monitor, what to tune, how often, and when? This presentation addresses these questions.

Information is the most valuable asset in business today. Information is required for all revenue generating transactions. As businesses expand, the number of data transactions subsequently grows as well. A best practice for controlling this data growth is to implement database archiving, a key component of enterprise data management. Database archiving enables you to archive and remove historical, inactive data from the production database, and save that data to more cost-effective and appropriate storage media. This reduces the amount of data on your Tier 1 production environment, improving performance immediately as well as reducing the cost of purchasing additional expensive storage. Database archiving maintains the “business and technical context” of the archived data, so that the company can easily research and retrieve the required for responding to a customer inquiry or audit request. Further, disaster recovery as well as upgrades and migrations can all be performed quicker and more efficiently.

Reliable applications come from reliable testing – and realistic test data plays a key role. Many organizations clone or copy production environments to create test data – a time consuming and expensive approach. Sub setting data enables you to extract the business objects or transactions you need to create targeted test scenarios. You can extract data from a single database or across multiple related databases and platforms. After migrating data into the target environment, you can view multiple related tables in a single display. Then you can easily edit your test data to force error and boundary conditions needed to verify exception handling. Reusable processing definitions help you speed iterative testing tasks and ensure complete coverage. Finally, learn how to sufficiently validate results. You can compare results from a single database table or across sets of multiple related tables. Make it easy to identify and resolve application problems cost-effectively – before they impact your customers. Gartner suggests that 70 percent of data breaches are internal to corporations. Many organizations today focus only on implementing strategies to protect data in the production environment, while leaving the testing environment vulnerable. In this session, learn about appropriate strategies for removing, masking and transforming data that can be used to identify individuals in your testing environment. Understand how you can create contextually accurate but fictionalized data to produce accurate test results and support compliance with local, state, national, international and industry-based privacy regulations.

About the Speakers

Dr. Jim Teng is an IBM Distinguished Engineer. He became a member of the DB2 team in 1980 and is widely recognized as one of the leading technical experts on DB2. Over his IBM career, Jim has been a significant driving force to design and provide new functions to DB2. He has extensive knowledge in areas of data sharing, database locking, data recovery, data management, buffer pool management, and performance related database technology.

Dr. Teng was a lead architect in DB2 to exploit IBM Parallel Sysplex Architecture. He was also a key contributor to enable SAP solution on IBM’s database platform. Dr. Teng has over 50 patents on relational database technology. He has also published numerous papers in technical journals. He is also a frequent speaker at the annual IDUG (International DB2 Users Group) and the IBM sponsored Information Management Technical Conference.

Lock Lyon is Principal Database Administrator for Fifth Third Bancorp. He has more than 20 years of experience in IT as an IMS and DB2 database administrator, systems analyst, manager, and consultant. Most recently, he spent a considerable amount of time on DB2 for z/OS subsystem upgrades and performance tuning. Lock is the author of the MIS Manager's Appraisal Guide (McGraw-Hill), and has published over 100 technical books and articles during his IT career.

With more than 25 years of experience in education and 17 years in the IT industry, Fred Booker continues to demonstrate his expertise and skills in database design and development for a variety of clients. Fred is particularly strong at helping clients understand the solutions to complex database problems. He has provided training in tools and methodologies of database design and implementation and assisted clients in the analysis, design, implementation, and maintenance of their database environments. More recently Fred has worked with clients in understanding and implementing database active archiving solutions.