Baltimore / Washington DB2 Users' Meeting 12/8/2010

Henry Nalven

Baltimore / Washington DB2 Users' Meeting 12/8/2010
BWDB2UG Quarterly Meeting

!!!! For those Registered for the meeting, both z/OS and LUW,
 Please see the website for session handouts which may be downloaded for your use during the meeting !!!!

www.bwdb2ug.org

To pre-register, please mail the appropriate fee with attendee's and employer's name to:

THE BALTIMORE/WASHINGTON DB2 USERS' GROUP
P.O. BOX 18554
BWI AIRPORT, MARYLAND 21240

All pre-registrations must be received by Friday, December 3, 2010. Make checks payable to the Baltimore/ Washington DB2 Users' Group or use the PAYPAL link on the website:

Visit our website, www.bwdb2ug.org, for more information.

When? Wednesday, December 8, 2010, 9:00AM-3:30PM (registration at 8:30)
Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900

Meeting Fees:
Pre-registered members: $30
Pre-registered non-members: $40
At-the-door for members: $40

At-the-door for non-members: $50
Meeting Schedule:
8:30 – 9:00 Registration

9:00 – 10:15 DB2 and Work Load Management (WLM)
Mark Rader, IBM

Confused about what exactly the IBM z/OS Workload Manager (WLM) is, how it manages work on your system, and how it relates to IBM DB2? In this session, we review the WLM features, including the types of goals you can set for each service class, importance levels and work classification. This information is the foundation for understanding how IBM DB2 for z/OS uses WLM, including advanced WLM functions such as enclaves and application environments. We also explain the relationship between the different types of DB2 work and WLM.

10:15 – 10:30 Coffee Break

10:30 – 11:45 Enhanced Monitoring support in DB2 v10
Mark Rader, IBM

DB2 10 for z/OS includes several exciting enhancements for monitoring the performance of SQL in your system and for managing your distributed connections and threads. This presentation explains how these capabilities allow you a better view of systems performance and more granularity in managing static and dynamic SQL and distributed threads.

11:45 – 12:45 Lunch

12:45 – 2:00 SMS is Now Mandatory for DB2 V10! SMS Best Practices for DB2
John Iczkovits, IBM

Confused about SMS? Do your Storage Administrators intimidate you when discussing how to best use SMS for DB2? Not sure if your company is conforming to best practises for SMS and DB2? Come and understand what SMS means and how to relate what your DB2 needs to the Storage Administrators.

2:00 – 2:15 Break

2:15 – 3:30 Static SQL and Access Path Review - Tips and Tricks
Paul Walters

Demonstrate an approach for reviewing static SQL and Access Paths for zOS. Identify the impact of System Software, Statistics Changes and Application changes upon an access path at bind time. Review specific sources of information such as the DB2 Catalog, Plan Tables, Real Time Statistics and performance data that identify problems prior to impacting a production environment.

Mark Rader is a Consulting IT Specialist with IBM Advanced Technical Skills (ATS), located in Chicago. He has 27 years of technical experience with IBM, and for the last 22 years has worked primarily with DB2 for MVS, OS/390 and z/OS. Among his specialties are DB2 data sharing, performance, and DB2 and WLM interaction. He has guided numerous customers in their implementation of DB2 data sharing, and has presented a variety of DB2 topics at user group meetings and customer workshops. He is one of the authors of Redbooks on Parallel Sysplex application considerations, DB2 data sharing, and DB2 for z/OS distributed function.

John Iczkovits is a Consulting IT Specialist with IBM Advanced Technical Skills. He provides DB2 for z/OS technical support and consulting services. His areas of expertise include DB2 data sharing, performance, and availability. His work in IBM includes experience supporting DB2 as a Systems Engineer, Database Administrator, IT Specialist, Consultant, and project lead. He has an operations background and more than 28 years of IT experience, ranging from database products such as DB2 and IMS to MVS systems support, including storage management. He has also co-authored IBM redbooks, red papers, white papers, and presented at SHARE, the DB2 Tech Conference, the Information On Demand Conference, zEXPO Conference, mini IDUG, and at local DB2 users groups.

Paul Walters has 20 years of application design and development experience using and exploiting DB2 for z/OS. Paul has performed roles in application support, architecture and new product development. Currently, Paul is working as a DB2 Database Administration with a focus is on performance and exploitation DB2 features.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Philip Sevetson

Re: Baltimore / Washington DB2 Users' Meeting 12/8/2010
(in response to Henry Nalven)
Henry,

All four of those presentations look chock-full of chewy goodness! Many of those of us who can't make it to your RUG would still love to see the presentations, if the authors are willing to publish them somewhere that we can go to download them. Would you let them know about our interest, please?

I believe the IDUG website has a way to host such things; I'll look around and see what I can find.

--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Henry L Nalven
Sent: Tuesday, December 07, 2010 10:49 AM
To: [login to unmask email]
Subject: [DB2-L] Baltimore / Washington DB2 Users' Meeting 12/8/2010

BWDB2UG Quarterly Meeting

!!!! For those Registered for the meeting, both z/OS and LUW,
 Please see the website for session handouts which may be downloaded for your use during the meeting !!!!

www.bwdb2ug.org

To pre-register, please mail the appropriate fee with attendee's and employer's name to:

THE BALTIMORE/WASHINGTON DB2 USERS' GROUP
P.O. BOX 18554
BWI AIRPORT, MARYLAND 21240

All pre-registrations must be received by Friday, December 3, 2010. Make checks payable to the Baltimore/ Washington DB2 Users' Group or use the PAYPAL link on the website:

Visit our website, www.bwdb2ug.org, for more information.

When? Wednesday, December 8, 2010, 9:00AM-3:30PM (registration at 8:30)
Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900

Meeting Fees:
Pre-registered members: $30
Pre-registered non-members: $40
At-the-door for members: $40

At-the-door for non-members: $50
Meeting Schedule:
8:30 – 9:00 Registration

9:00 – 10:15 DB2 and Work Load Management (WLM)
Mark Rader, IBM

Confused about what exactly the IBM z/OS Workload Manager (WLM) is, how it manages work on your system, and how it relates to IBM DB2? In this session, we review the WLM features, including the types of goals you can set for each service class, importance levels and work classification. This information is the foundation for understanding how IBM DB2 for z/OS uses WLM, including advanced WLM functions such as enclaves and application environments. We also explain the relationship between the different types of DB2 work and WLM.

10:15 – 10:30 Coffee Break

10:30 – 11:45 Enhanced Monitoring support in DB2 v10
Mark Rader, IBM

DB2 10 for z/OS includes several exciting enhancements for monitoring the performance of SQL in your system and for managing your distributed connections and threads. This presentation explains how these capabilities allow you a better view of systems performance and more granularity in managing static and dynamic SQL and distributed threads.

11:45 – 12:45 Lunch

12:45 – 2:00 SMS is Now Mandatory for DB2 V10! SMS Best Practices for DB2
John Iczkovits, IBM

Confused about SMS? Do your Storage Administrators intimidate you when discussing how to best use SMS for DB2? Not sure if your company is conforming to best practises for SMS and DB2? Come and understand what SMS means and how to relate what your DB2 needs to the Storage Administrators.

2:00 – 2:15 Break

2:15 – 3:30 Static SQL and Access Path Review - Tips and Tricks
Paul Walters

Demonstrate an approach for reviewing static SQL and Access Paths for zOS. Identify the impact of System Software, Statistics Changes and Application changes upon an access path at bind time. Review specific sources of information such as the DB2 Catalog, Plan Tables, Real Time Statistics and performance data that identify problems prior to impacting a production environment.

Mark Rader is a Consulting IT Specialist with IBM Advanced Technical Skills (ATS), located in Chicago. He has 27 years of technical experience with IBM, and for the last 22 years has worked primarily with DB2 for MVS, OS/390 and z/OS. Among his specialties are DB2 data sharing, performance, and DB2 and WLM interaction. He has guided numerous customers in their implementation of DB2 data sharing, and has presented a variety of DB2 topics at user group meetings and customer workshops. He is one of the authors of Redbooks on Parallel Sysplex application considerations, DB2 data sharing, and DB2 for z/OS distributed function.

John Iczkovits is a Consulting IT Specialist with IBM Advanced Technical Skills. He provides DB2 for z/OS technical support and consulting services. His areas of expertise include DB2 data sharing, performance, and availability. His work in IBM includes experience supporting DB2 as a Systems Engineer, Database Administrator, IT Specialist, Consultant, and project lead. He has an operations background and more than 28 years of IT experience, ranging from database products such as DB2 and IMS to MVS systems support, including storage management. He has also co-authored IBM redbooks, red papers, white papers, and presented at SHARE, the DB2 Tech Conference, the Information On Demand Conference, zEXPO Conference, mini IDUG, and at local DB2 users groups.

Paul Walters has 20 years of application design and development experience using and exploiting DB2 for z/OS. Paul has performed roles in application support, architecture and new product development. Currently, Paul is working as a DB2 Database Administration with a focus is on performance and exploitation DB2 features.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Edward Long

Re: Baltimore / Washington DB2 Users' Meeting 12/8/2010
(in response to Philip Sevetson)
I agree these presentations look terrific.
 
The New England DB2 User's Group has it's own website. NEDB2UG.ORG. We would be delighted to host these documents.
 
All of our presentations from the last 5 years or so are also available at our website.
 
Just send the stuff to me and I can, to quote J.L. Picard, make it so.

Edward Long

--- On Wed, 12/8/10, Sevetson, Phil <[login to unmask email]> wrote:


From: Sevetson, Phil <[login to unmask email]>
Subject: Re: [DB2-L] Baltimore / Washington DB2 Users' Meeting 12/8/2010
To: [login to unmask email]
Date: Wednesday, December 8, 2010, 10:08 AM


Henry,

All four of those presentations look chock-full of chewy goodness!  Many of those of us who can't make it to your RUG would still love to see the presentations, if the authors are willing to publish them somewhere that we can go to download them.  Would you let them know about our interest, please? 

I believe the IDUG website has a way to host such things; I'll look around and see what I can find.

--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Henry L Nalven
Sent: Tuesday, December 07, 2010 10:49 AM
To: [login to unmask email]
Subject: [DB2-L] Baltimore / Washington DB2 Users' Meeting 12/8/2010

BWDB2UG Quarterly Meeting

!!!!  For those Registered for the meeting, both z/OS and LUW,
 Please see the website for session handouts which may be downloaded for your use during the meeting !!!!

www.bwdb2ug.org

To pre-register, please mail the appropriate fee with attendee's and employer's name to:

THE BALTIMORE/WASHINGTON DB2 USERS' GROUP
P.O. BOX 18554
BWI AIRPORT, MARYLAND 21240

All pre-registrations must be received by  Friday, December 3, 2010.  Make checks payable to the  Baltimore/ Washington DB2 Users' Group or use the PAYPAL link on the website:
   
    Visit our website, www.bwdb2ug.org, for more information.

When? Wednesday, December 8, 2010, 9:00AM-3:30PM (registration at 8:30)
Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900

Meeting Fees:
Pre-registered members: $30
Pre-registered non-members: $40
At-the-door for members: $40

At-the-door for non-members: $50
Meeting Schedule:
  8:30 – 9:00    Registration   
         
  9:00 – 10:15    DB2 and Work Load Management (WLM)   
      Mark Rader, IBM   
         
      Confused about what exactly the IBM z/OS Workload Manager (WLM) is, how it manages work on your system, and how it relates to IBM DB2? In this session, we review the WLM features, including the types of goals you can set for each service class, importance levels and work classification. This information is the foundation for understanding how IBM DB2 for z/OS uses WLM, including advanced WLM functions such as enclaves and application environments. We also explain the relationship between the different types of DB2 work and WLM.    
         
  10:15 – 10:30    Coffee Break   
         
  10:30 – 11:45    Enhanced Monitoring support in DB2 v10   
    Mark Rader, IBM   
         
      DB2 10 for z/OS includes several exciting enhancements for monitoring the performance of SQL in your system and for managing your distributed connections and threads. This presentation explains how these capabilities allow you a better view of systems performance and more granularity in managing static and dynamic SQL and distributed threads.    
         
  11:45 – 12:45    Lunch    
         
  12:45 – 2:00    SMS is Now Mandatory for DB2 V10! SMS Best Practices for DB2    
      John Iczkovits, IBM   
       
    Confused about SMS? Do your Storage Administrators intimidate you when discussing how to best use SMS for DB2? Not sure if your company is conforming to best practises for SMS and DB2? Come and understand what SMS means and how to relate what your DB2 needs to the Storage Administrators.    
       
  2:00 – 2:15    Break   
         
  2:15 – 3:30    Static SQL and Access Path Review - Tips and Tricks   
      Paul Walters   
       
    Demonstrate an approach for reviewing static SQL and Access Paths for zOS. Identify the impact of System Software, Statistics Changes and Application changes upon an access path at bind time. Review specific sources of information such as the DB2 Catalog, Plan Tables, Real Time Statistics and performance data that identify problems prior to impacting a production environment.   

Mark Rader is a Consulting IT Specialist with IBM Advanced Technical Skills (ATS), located in Chicago. He has 27 years of technical experience with IBM, and for the last 22 years has worked primarily with DB2 for MVS, OS/390 and z/OS. Among his specialties are DB2 data sharing, performance, and DB2 and WLM interaction. He has guided numerous customers in their implementation of DB2 data sharing, and has presented a variety of DB2 topics at user group meetings and customer workshops. He is one of the authors of Redbooks on Parallel Sysplex application considerations, DB2 data sharing, and DB2 for z/OS distributed function.

John Iczkovits is a Consulting IT Specialist with IBM Advanced Technical Skills. He provides DB2 for z/OS technical support and consulting services. His areas of expertise include DB2 data sharing, performance, and availability. His work in IBM includes experience supporting DB2 as a Systems Engineer, Database Administrator, IT Specialist, Consultant, and project lead. He has an operations background and more than 28 years of IT experience, ranging from database products such as DB2 and IMS to MVS systems support, including storage management. He has also co-authored IBM redbooks, red papers, white papers, and presented at SHARE, the DB2 Tech Conference, the Information On Demand Conference, zEXPO Conference, mini IDUG, and at local DB2 users groups.

Paul Walters has 20 years of application design and development experience using and exploiting DB2 for z/OS. Paul has performed roles in application support, architecture and new product development. Currently, Paul is working as a DB2 Database Administration with a focus is on performance and exploitation DB2 features.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *  http://IDUG.ORG/NA *
*   Your only source for independent, unbiased, and trusted DB2 information.   *
**   The most DB2 technical sessions of any conference
**   Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *  http://IDUG.ORG/NA *
*   If you are going to attend only one conference this year, this is it!   *
**    The best DB2 technical sessions in the world
**    Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

William Favero

Re: Baltimore / Washington DB2 Users' Meeting 12/8/2010
(in response to Edward Long)
SlideShare.com is a great way to share presentations.

Willie

On 12/8/2010 9:08 AM, Sevetson, Phil wrote:
> Henry,
>
> All four of those presentations look chock-full of chewy goodness! Many of those of us who can't make it to your RUG would still love to see the presentations, if the authors are willing to publish them somewhere that we can go to download them. Would you let them know about our interest, please?
>
> I believe the IDUG website has a way to host such things; I'll look around and see what I can find.
>
> --Phil Sevetson
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Henry L Nalven
> Sent: Tuesday, December 07, 2010 10:49 AM
> To: [login to unmask email]
> Subject: [DB2-L] Baltimore / Washington DB2 Users' Meeting 12/8/2010
>
> BWDB2UG Quarterly Meeting
>
> !!!! For those Registered for the meeting, both z/OS and LUW,
>  Please see the website for session handouts which may be downloaded for your use during the meeting !!!!
>
> www.bwdb2ug.org
>
> To pre-register, please mail the appropriate fee with attendee's and employer's name to:
>
> THE BALTIMORE/WASHINGTON DB2 USERS' GROUP
> P.O. BOX 18554
> BWI AIRPORT, MARYLAND 21240
>
> All pre-registrations must be received by Friday, December 3, 2010. Make checks payable to the Baltimore/ Washington DB2 Users' Group or use the PAYPAL link on the website:
>
> Visit our website, www.bwdb2ug.org, for more information.
>
> When? Wednesday, December 8, 2010, 9:00AM-3:30PM (registration at 8:30)
> Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900
>
> Meeting Fees:
> Pre-registered members: $30
> Pre-registered non-members: $40
> At-the-door for members: $40
>
> At-the-door for non-members: $50
> Meeting Schedule:
> 8:30 – 9:00 Registration
>
> 9:00 – 10:15 DB2 and Work Load Management (WLM)
> Mark Rader, IBM
>
> Confused about what exactly the IBM z/OS Workload Manager (WLM) is, how it manages work on your system, and how it relates to IBM DB2? In this session, we review the WLM features, including the types of goals you can set for each service class, importance levels and work classification. This information is the foundation for understanding how IBM DB2 for z/OS uses WLM, including advanced WLM functions such as enclaves and application environments. We also explain the relationship between the different types of DB2 work and WLM.
>
> 10:15 – 10:30 Coffee Break
>
> 10:30 – 11:45 Enhanced Monitoring support in DB2 v10
> Mark Rader, IBM
>
> DB2 10 for z/OS includes several exciting enhancements for monitoring the performance of SQL in your system and for managing your distributed connections and threads. This presentation explains how these capabilities allow you a better view of systems performance and more granularity in managing static and dynamic SQL and distributed threads.
>
> 11:45 – 12:45 Lunch
>
> 12:45 – 2:00 SMS is Now Mandatory for DB2 V10! SMS Best Practices for DB2
> John Iczkovits, IBM
>
> Confused about SMS? Do your Storage Administrators intimidate you when discussing how to best use SMS for DB2? Not sure if your company is conforming to best practises for SMS and DB2? Come and understand what SMS means and how to relate what your DB2 needs to the Storage Administrators.
>
> 2:00 – 2:15 Break
>
> 2:15 – 3:30 Static SQL and Access Path Review - Tips and Tricks
> Paul Walters
>
> Demonstrate an approach for reviewing static SQL and Access Paths for zOS. Identify the impact of System Software, Statistics Changes and Application changes upon an access path at bind time. Review specific sources of information such as the DB2 Catalog, Plan Tables, Real Time Statistics and performance data that identify problems prior to impacting a production environment.
>
> Mark Rader is a Consulting IT Specialist with IBM Advanced Technical Skills (ATS), located in Chicago. He has 27 years of technical experience with IBM, and for the last 22 years has worked primarily with DB2 for MVS, OS/390 and z/OS. Among his specialties are DB2 data sharing, performance, and DB2 and WLM interaction. He has guided numerous customers in their implementation of DB2 data sharing, and has presented a variety of DB2 topics at user group meetings and customer workshops. He is one of the authors of Redbooks on Parallel Sysplex application considerations, DB2 data sharing, and DB2 for z/OS distributed function.
>
> John Iczkovits is a Consulting IT Specialist with IBM Advanced Technical Skills. He provides DB2 for z/OS technical support and consulting services. His areas of expertise include DB2 data sharing, performance, and availability. His work in IBM includes experience supporting DB2 as a Systems Engineer, Database Administrator, IT Specialist, Consultant, and project lead. He has an operations background and more than 28 years of IT experience, ranging from database products such as DB2 and IMS to MVS systems support, including storage management. He has also co-authored IBM redbooks, red papers, white papers, and presented at SHARE, the DB2 Tech Conference, the Information On Demand Conference, zEXPO Conference, mini IDUG, and at local DB2 users groups.
>
> Paul Walters has 20 years of application design and development experience using and exploiting DB2 for z/OS. Paul has performed roles in application support, architecture and new product development. Currently, Paul is working as a DB2 Database Administration with a focus is on performance and exploitation DB2 features.
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2 information. *
> ** The most DB2 technical sessions of any conference
> ** Access IBM experts and developers
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
> * If you are going to attend only one conference this year, this is it! *
> ** The best DB2 technical sessions in the world
> ** Independent, not-for-profit, User Run - the IDUG difference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

--
Willie
My DB2 blog --> http://it.toolbox.com/blogs/db2zos/
Houston, TX, USA

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Michael Bruzdzinski

Re: Baltimore / Washington DB2 Users' Meeting 12/8/2010
(in response to William Favero)
They will be available on the website (www.bwdb2ug.org) .

The user presentation from Paul Walters (Sallie Mae) was great. John Iczkovits presentation was chockfull of suggestions about SMS and provided a lot of useful information on DB2 use of DASD in general.


Michael Bruzdzinski
Social Security Administration
OESAE/DDBS/DBSB
[login to unmask email]
410-966-7185 (v)
443-379-2282 (Blackberry)


"Nobody knows what a DBA does but everybody has to have one, because nobody can afford two." (from "The IT Menagerie", IBM Systems Journal, circa 1990)


-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson, Phil
Sent: Wednesday, December 08, 2010 10:09 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Baltimore / Washington DB2 Users' Meeting 12/8/2010

Henry,

All four of those presentations look chock-full of chewy goodness! Many of those of us who can't make it to your RUG would still love to see the presentations, if the authors are willing to publish them somewhere that we can go to download them. Would you let them know about our interest, please?

I believe the IDUG website has a way to host such things; I'll look around and see what I can find.

--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Henry L Nalven
Sent: Tuesday, December 07, 2010 10:49 AM
To: [login to unmask email]
Subject: [DB2-L] Baltimore / Washington DB2 Users' Meeting 12/8/2010

BWDB2UG Quarterly Meeting

!!!! For those Registered for the meeting, both z/OS and LUW,
 Please see the website for session handouts which may be downloaded for your use during the meeting !!!!

www.bwdb2ug.org

To pre-register, please mail the appropriate fee with attendee's and employer's name to:

THE BALTIMORE/WASHINGTON DB2 USERS' GROUP
P.O. BOX 18554
BWI AIRPORT, MARYLAND 21240

All pre-registrations must be received by Friday, December 3, 2010. Make checks payable to the Baltimore/ Washington DB2 Users' Group or use the PAYPAL link on the website:

Visit our website, www.bwdb2ug.org, for more information.

When? Wednesday, December 8, 2010, 9:00AM-3:30PM (registration at 8:30)
Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900

Meeting Fees:
Pre-registered members: $30
Pre-registered non-members: $40
At-the-door for members: $40

At-the-door for non-members: $50
Meeting Schedule:
8:30 – 9:00 Registration

9:00 – 10:15 DB2 and Work Load Management (WLM)
Mark Rader, IBM

Confused about what exactly the IBM z/OS Workload Manager (WLM) is, how it manages work on your system, and how it relates to IBM DB2? In this session, we review the WLM features, including the types of goals you can set for each service class, importance levels and work classification. This information is the foundation for understanding how IBM DB2 for z/OS uses WLM, including advanced WLM functions such as enclaves and application environments. We also explain the relationship between the different types of DB2 work and WLM.

10:15 – 10:30 Coffee Break

10:30 – 11:45 Enhanced Monitoring support in DB2 v10
Mark Rader, IBM

DB2 10 for z/OS includes several exciting enhancements for monitoring the performance of SQL in your system and for managing your distributed connections and threads. This presentation explains how these capabilities allow you a better view of systems performance and more granularity in managing static and dynamic SQL and distributed threads.

11:45 – 12:45 Lunch

12:45 – 2:00 SMS is Now Mandatory for DB2 V10! SMS Best Practices for DB2
John Iczkovits, IBM

Confused about SMS? Do your Storage Administrators intimidate you when discussing how to best use SMS for DB2? Not sure if your company is conforming to best practises for SMS and DB2? Come and understand what SMS means and how to relate what your DB2 needs to the Storage Administrators.

2:00 – 2:15 Break

2:15 – 3:30 Static SQL and Access Path Review - Tips and Tricks
Paul Walters

Demonstrate an approach for reviewing static SQL and Access Paths for zOS. Identify the impact of System Software, Statistics Changes and Application changes upon an access path at bind time. Review specific sources of information such as the DB2 Catalog, Plan Tables, Real Time Statistics and performance data that identify problems prior to impacting a production environment.

Mark Rader is a Consulting IT Specialist with IBM Advanced Technical Skills (ATS), located in Chicago. He has 27 years of technical experience with IBM, and for the last 22 years has worked primarily with DB2 for MVS, OS/390 and z/OS. Among his specialties are DB2 data sharing, performance, and DB2 and WLM interaction. He has guided numerous customers in their implementation of DB2 data sharing, and has presented a variety of DB2 topics at user group meetings and customer workshops. He is one of the authors of Redbooks on Parallel Sysplex application considerations, DB2 data sharing, and DB2 for z/OS distributed function.

John Iczkovits is a Consulting IT Specialist with IBM Advanced Technical Skills. He provides DB2 for z/OS technical support and consulting services. His areas of expertise include DB2 data sharing, performance, and availability. His work in IBM includes experience supporting DB2 as a Systems Engineer, Database Administrator, IT Specialist, Consultant, and project lead. He has an operations background and more than 28 years of IT experience, ranging from database products such as DB2 and IMS to MVS systems support, including storage management. He has also co-authored IBM redbooks, red papers, white papers, and presented at SHARE, the DB2 Tech Conference, the Information On Demand Conference, zEXPO Conference, mini IDUG, and at local DB2 users groups.

Paul Walters has 20 years of application design and development experience using and exploiting DB2 for z/OS. Paul has performed roles in application support, architecture and new product development. Currently, Paul is working as a DB2 Database Administration with a focus is on performance and exploitation DB2 features.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv