Abstracts and Biographies (scroll down)

 

DB2 for z/OS Universal Table Spaces: The DB2 10 Story

Jim Brogan - IBM

Abstract:

DB2 for z/OS delivers a feature that has generated considerable discussion. First made available in DB2 9, the structure

type is called universal table space. This feature will significantly improve your DB2 experience by making DB2 easier

to manage. This presentation will give you the details behind how this feature is implemented, how to use it, and a look

at a few things that have been enhanced with the availability of DB2 10.

Bio:

Jim Brogan is an IBM Certified Consulting IT Specialist. Throughout his 30+ year career, Jim has had many roles in the IT

industry including those of DBA, DBA manager, and consultant at several large corporations including UTC, GE, and Westinghouse.

Jim has been with IBM for 12 years as a Delivery Project Manager with IGS, a DB2 UDB for Linux, Unix, Windows Senior Technical

Specialist with SWG and is currently a DB2 Advisor providing technical support to the IBM sales team and customers for IBM DB2

z/OS in the Northeastern United States.

 

 

30 Point SQL Review for Embedded SQL Applications

Diwakar Rao Kale - Fildelity

Abstract:

Industry statistics show that early detection of defects or performance issues through "review process" have a significantly

lower cost than 'issues' found when the software is in production. One way in which you can help reduce total cost of

ownership and avoid "preventable" issues is by being proactive in developing DB2 code as per set standards and actively

lookout for non-standard code/SQL and potential performance problems and fix it before it's installed in production.

* How can SQL Review strategy help in achieving superior database business continuity?

* Common production failures preventable with SQL review process.

* SQL Review process explained!

* 30 SQL/code review standards, guidelines, and recommendations to be considered when developing SQL/code using a DB2

database, explained in detail with examples. One slide per standard.

* Empower developers! How can you help developers help you!

Objective.

Objective of this presentation is to outline a successful methodology and strategy for achieving superior database business

continuity, supported by software that is written by developers who apply SQL standards.

Gain knowledge to standardize DB2 development, and improve application maintainability.

Understand the fact that code/SQL is where the majority of tuning opportunities exist for a given DB2 system.

Learn that implementing SQL review process provides on-going training for all developer, as standards reflect current

surrounding efficient SQL utilization, given the DB2 version currently deployed.

Ever changing standards exploit improvements and efficiencies to techniques in new versions of DB2, and apply it to your code stack.

 

Bio:

Diwakar Rao Kale is a Director Database Administration with Fidelity Investments, has over 15 years of experience

in enterprise database management, operations, strategic planning and enterprise architecture. Diwakar's focus is

on application design, database performance management and enterprise information integration, has developed and

delivered technical presentations at local user groups, IBM IOD and IDUG conference in North America, Europe, and Asia.

 

 

Advanced Recovery Solutions for DB2 LUW

Bill Minor - IBM

Abstract:

This session will explore in detail the new Advanced Recovery Solutions for DB2 LUW. The solutions are comprised of the

IBM Recovery Expert, IBM Merge Backup and Optim High Performance Unload tools. Minimizing recovery time and maintaining

the integrity of your data is critical to the success of your business. The Advanced Recovery Solutions for DB2 LUW

provide unique capabilities for data analysis, elimination of data errors and maximizing data availability. We will examine

in detail the features these solutions present and demonstrate, through realistic user scenarios, the business value that

can be gained with this technology.

Objectives:

Illustrate the new Advanced Recovery Solutions for DB2 LUW

Demonstrate ease of solution implementation

Gain an understanding of how the features in the Advanced Recovery Solutions can reduce your Total Cost of Ownership

Relate best practices for maximizing your Return on Investment

Bio:

Bill has been with the DB2 LUW organization since 1996. He started his career with the DB2 Advanced Customer Support Team

and then spent eleven years with the DB2 LUW Development Team as a Software Developer and Senior Technical Development Manager

for the DB2 Engine Data Manager component . He is a subject matter expert in the DB2 LUW kernel or engine and specialist in

the area of database object management and storage. Recently he took on a lead technical role within the IBM Tooling Portfolio

in order design and build tools that highly complement DB2 LUW. . Bill has presented at a number of DB2 Conferences, User Groups

and customer events around the world. In his spare time, he tries to learn how to play a guitar.

 

 

Database Appliances, MapReduce, and NoSQL and How they Compare to DB2

Philip Czachorowski - Fidelity

Abstract:

There has been a proliferation of new database technologies and products over the past several years including database

appliances, MapReduce, and NoSQL. IBM offers Netezza, a database appliance and InfoSphere BigInsights, a MapReduce-Hadoop

implementation. The NoSQL movement grew up with the premise that RDBMS technology can not solve all data problems. This talk

will contrast the architecture and implementation of these new technologies using Netezza and BigInsights as examples and

compare them to DB2 for z/OS and DB2 for LUW. It will describe appropriate uses for each technology and show how these

products complement DB2 and also have overlapping functions. Many of the lessons learned in implementing relational database

management systems have been applied to these new technologies.

Bio:

Philip Czachorowski has extensive experience in database architecture, design, and performance tuning. He has worked with

DB2 since the Release 1 early support program in 1983. He has also worked with most of the major DBMS products and has

conducted numerous DBMS technology evaluations and performance benchmarks. He is the founder of the New England DB2 Users

Group and has presented at IDUG, IOD, NEDB2 Users Group, and at other conferences.