Abstracts and Biographies (scroll down)

 

DB2 9 for DBAs & Future Direction

Roger Miller (IBM)

Abstract:

Craig Mullins is talking about DB2 9 for Developers, so this is the complement, DB2

9 for DBAs, emphasizing improvements in the rest of DB2, then providing a brief

look past DB2 9. I’ll be skipping many of the slides in this handout.

We’ll start with some of the recent changes, discussing hardware, recent platform

changes, improvements in total cost of ownership, and a few V8 APAR changes.

The main topic for today is the changes in DB2 9, starting with the performance and

scalability topics, then into the changes for improved availability and on to improved

productivity for database administrators and for programmers. We’ll note the

improvements for regulatory compliance, in performance and in availability.

Performance improves for utilities, optimization and LOBs. Data definition on

demand extends the theme of online schema evolution from V8. Utility

enhancements help with new function, more LOB and XML support, better

performance and improved availability, removing the BUILD2 step from online reorg.

DB2 9 enhances DB2's ability to handle new and enterprise applications. DB2 9

builds upon and extends DB2 traditional strengths and the ground-breaking V8 in

many areas: online schema evolution, Unicode, XML, DB2 family SQL, utilities,

security and 64-bit virtual storage.

Then we’ll discussion what comes next, the version we’ll call DB2 X.

Finally, I’ll wrap up with a whirlwind tour of my favorite DB2 web sites, showing the

resources and where to find information about DB2.

Biography:

Roger Miller is a DB2 for z/OS technical evangelist, architect, designer, writer, and factotum (from the Latin

for does everything or jack of all DB2 trades, master of several) who has worked 29 years on many facets of DB2,

ranging across performance, concurrency, availability, SQL, languages, install, and security. He is writing a

book on DB2 performance with Akira Shibamiya and Craig Mullins. He often helps customers to use the product,

answers many questions and presents frequently to user groups. He was a customer application and systems

programmer for 10 years before coming to IBM. His favorite response is, “It depends.” followed by an explanation

of what it depends upon.

 

BMC DB2 9 Support

Bill Arledge (BMC)

Abstract:

BMC delivered support for DB2 9 in August of 2007 across all of our DB2 product solutions. This presentation

will highlight specific support in each area, including our performance, administration, and recovery

management solutions. We will discuss how BMC products can help you simplify your migration to DB2 9, offering

automated approaches for implementing new DB2 9 features.

Biography:

Bill Arledge is an IT veteran with 33 years experience across a variety of roles, including application

development and database administration. Bill’s database experience began in the late 1970’s as an IMS DBA

and developer. He began working with DB2 in 1984 as a database specialist at IBM. He worked with DB2

throughout the late eighties, consulting with numerous IBM customers on existing and planned DB2

implementations. Bill joined BMC in 1990 and is currently a technical product manager responsible for

BMC’s DB2 data management products. In that capacity he consults extensively with BMC DB2 customers

and works closely with BMC’s Research and Development organization to drive product direction.

 

DB2 9 and Native XML Support

Phil Grainger (CA)

Abstract:

Although you may not currently have XML data in your life, chances are that it is in your future!

Native support for storage and management of XML documents is one of the biggest changes in DB2 9

and the journey is just beginning.

This technical presentation starts with an overview of XML, how XML documents should be created and

managed and then reviews how DB2 and XML work together in a pre-DB2 9 world.

We will then look at how things change in DB2 9. The information we will cover includes:

·      How SQL and DB2 have been extended to support access to XML documents alongside

       traditional relational data

·      The XML data type itself

·      New XML functions in DB2 9 that can be used to retrieve and qualify rows based on

       the content of XML documents

·      Additional XML support delivered since DB2 9 went GA. For example, the use of the

       XMLTABLE() function to return "repeating" groups of data from an XML document as

       if they were each an individual row of a relational table. This is the first step to

       really being able to process portions of an XML document in a truly relational manner.

Bonus content: Interesting new developments from CA Database Management

Biography:

Phil Grainger, Senior Principal Product Manager, CA, has over 20 years experience with DB2, starting in

1987 with DB2 Version 1.2 and all versions thereafter. Beginning as a DBA for one of the largest users

of DB2 in the UK, Phil moved to PLATINUM technology and then to his present role in Product Management

for the CA solutions for DB2. Phil has always been a keen supporter of user groups and is a regular speaker

at CA events, as well as independent industry events. He currently serves as the CA representative on the

European IDUG Planning Committee, and is a regular contributor to the IDUG sponsored DB2-L discussion list.

 

DB2 9 enhancements, use them or you'll forget them!

Joe Brockert (NEON)

Abstract:

This presentation highlights the DB2 9 for z/OS enhancements that directly impact DB2 maintenance cycle and

recoverability. Every release of DB2 offers new features and functionality that could make your maintenance

cycle shorter and ensure your recovery time objectives are met. Don't leave these features and functions

sitting around, put them to use and enjoy the benefits.

Example areas covered in this presentation will include:

     * DB2 maintenance: cyclic, re-active, automated, on demand, or autonomic

     * Real Time Statistic exploitation including COLGROUP

     * REORG w/o BUILD 2 phase

     * Universal Table Spaces (UTS)

     * And more…

If your maintenance cycle is in need of a review and updates, your batch window continues to grow smaller,

then this presentation should have something to offer you.

Biography:

Joe Brockert has 30 years of experience in the full life cycle of Information Technology, and in his 20 years

of industry experience he has worked in the design, development, and implementation of custom written

applications for oil and gas, law, insurance, utility and food distribution companies. Seven of these years

were spent as Manager of Database Administration for SYSCO, a Fortune 100 company. In the last 10 years Joe

has been a System Consultant working for several ISV’s in the area of integration software and Database tools,

across all industries, working extensively in Asia-Pac. Joe has served on the board for the DB2 Exchange in

Houston and has been a guest speaker at various trade shows and user groups.

 

IBM DB2 Tools

Alice Ma (IBM)

Abstract:

You know that old saying "Having the right tool makes all the difference"? Here’s your opportunity to improve

your company's productivity by knowing what the right tool is and how to use it. During this chat we will be

chatting about ways to help you be more efficient in performing routine database administrator (DBA) tasks

such as monitoring the health of the database management system (DBMS), performance tuning, managing changes,

and leveraging static SQL and security features.

Biography:

My Bio: Guru on DBA Tools! (send this to you later).. Been working with w/ db since 1994. 11 yrs with IBM.

Prior to IBM I supported the VA hostipal DBs. I just might know something.. hehe.. you would think!

I have spoken at conferences all around the world (not just the USA. i.e. Dussledorf, Berlin, Netherlands,

Greece, Canada, Austria, etc..)

 

DB2 9 For Developers Only

Craig S. Mullins (NEON)

Abstract:

This presentation highlights the DB2 9 for z/OS enhancements that directly impact DB2 application developers.

Every release of DB2 is chock full of new features and functionality and that can make it hard to focus on

those things that are most helpful for programmers. So instead of scanning volumes of manuals, you can watch

this presentation which will distill the DB2 9 information down to cover what should be most important to

programmer/analysts.

Examples of areas this presentation will cover include:

     * A brief overview of DB2 9 XML capability

     * New data types and functions

     * New SQL statements like INTERSECT, EXCEPT, MERGE, and TRUNCATE

     * The ability to SELECT FROM and UPDATE, DELETE, or MERGE statement

     * Improvements to existing SQL

     * And more…

If you are a programmer wanting to learn more about DB2 9, or a DBA looking for the programmer’s perspective

on DB2 9, this presentation should have something to offer you.

Biography:

Craig S. Mullins is a well-known author, lecturer, and columnist on current topics in the DB2 and mainframe

world. Craig has over two decades of experience in all facets of database systems development. He is a frequent

lecturer and contributor to computer industry publications, including Data Management Review, DBMS, DB2 Update,

DB2 Magazine, Oracle Update, SQL Server Update, and many more. He is also the author of two books on DB2 and

database administration: DB2 Developer’s Guide and Database Administration: The Complete Guide to Practices

and Procedures. He graduated cum laude from the University of Pittsburg with a double major in Computer Science

and Economics, and a minor in Mathematics.