Central PA - NO-CHARGE hands-on Optim Query Workload Tuner Workshop - Thursday - July 28th (9-2 - re

Lori Ann Galluzzo

Central PA - NO-CHARGE hands-on Optim Query Workload Tuner Workshop - Thursday - July 28th (9-2 - re

IBM Optim Query Workload Tuner for z/OS Workshop

Are your DB2 queries running amuck? Would you like to learn more about how IBM can help you tame those queries? Please join us for a NO CHARGE hands-on Optim Query Workload Tuner workshop to be held at the IBM office in Mechanicsburg, PA.

Date: Thursday, July 28, 2011

Location:
IBM Branch office
02-2W14 2nd Floor to rear of Building from Elevators
2020 Technology Pkwy
Mechanicsburg, Pennsylvania

Time: 9:00 AM - 2:00 PM (registration begins at 8:30 AM)

There is no cost to the customer for this proof-of-technology workshop. Complementary lunch will be served. However, participants will be responsible for their own business travel expenses. The proof-of-technology will last approximately 5 hours including lunch and breaks.


Please view the attached document for more detail about the proof-of-technology workshop. To register for this event, please provide the information below in an email to either Terri Kemmer ([login to unmask email]<mailto:[login to unmask email]>) or Stan Goodwin ([login to unmask email]<mailto:[login to unmask email]>). Space is limited to 24 attendees - deadline for registration is Friday, July 22.



REGISTRATION INFORMATION:

Attendee Name:
Company Name:
Job Description:
Email:






IBM Optim Query Workload Tuner for z/OS Workshop
An IBM Proof-of-Technology
Information Management Software



INTRODUCTION:
This proof-of-technology focuses on IBM Optim Query Workload Tuner(r) and the products that integrate to help monitor and optimize DB2(r) performance. Are you wondering how IBM's Optim products relate to your DB2(r) Tools investment? Are you familiar with the Eclipse interface of some of IBM's DB2(r) Tools products? We spend time discussing data management and performance challenges, how IBM Optim Query Workload Tuner(r) can address query and workload performance, monitoring and optimization. This proof-of-technology is designed to show how these tools can easily extend administrative functions for DB2(r) on z/OS.

OBJECTIVE:
This session enables attendees to gain an understanding of Optim Query Workload Tuner(r) for DB2(r) on z/OS. It features lecture and hands-on laboratories. The proof-of-technology will enable attendees to gain familiarity with the Eclipse interface, query monitoring, query tuning and workload tuning.

AUDIENCE:
This Proof of Technology is for Database Administrators, Data Management Architects, Database Developers, Application Developers and other decision influencers evaluating IBM technologies. While managers and executives may want to attend for the presentations, it's the technical folks who will especially want to attend for the labs in order to see these tools in action.

AGENDA:
DB2(r) Performance and Tuning Discussion
Discuss data management, and DB2(r) performance and optimization. Review strategic and tactical measures to help your staff maximize efforts.

Lab Overview and Discussion
Review logistics for lab, preview of activities that will be covered in the day's events.

Lab 0: Eclipse Basics
Hands on laboratory designed to get users unfamiliar with the Eclipse Graphical Interface up to speed quickly. Topics will include navigating the Eclipse IDE and reviewing tool interface.

Lab 1: Database Connection & Configuration
Hands-on laboratory designed to show how users can quickly connect to their DB2(r) subsystem and configure it for tuning.

Lab 2: Single Query Tuning
Hands-on laboratory designed to show users how to quickly tune problem queries in either a development or production environment on DB2(r). Lab will cover importing queries and tuning using query advisor, access path advisor, statistics advisor and index advisor.

Lab 3: Workload Tuning
Hands-on laboratory designed to show users how to define a workload on their DB2(r) subsystem and tune it using workload statistics advisor and workload index advisor.

Lab 4: Using Query Monitor w/ Query Workload Tuner
Hands-on laboratory designed to show how Query Monitor for DB2(r) integrates with Optim Query Workload Tuner. Lab will cover monitoring activities and importing problem queries into the Optim product.

COST/SCHEDULE:
There is no cost to customer for this proof-of-technology. Complementary refreshments and snacks will be served. However, participants will be responsible for their own business travel expenses. The proof-of-technology will last approximately one full business day including lunch and breaks.

FOR MORE INFORMATION:
Contact your IBM Software Sales Representative

Regards
[X]

Terri Kemmer Mechanicsburg, PA 17050
DB2 Advisor USA
IBM US East Extended Team
System z SW Technical Professional
Phone: 1-717-610-7339
e-mail: [login to unmask email]<mailto:[login to unmask email]>



[X]



Attachments

  • Picture (Device Independent Bitmap) 1.jpg (1.9k)

Mark Labby

Central PA - NO-CHARGE hands-on Optim Query Workload Tuner Workshop - Thursday - July 28th (9-2 - re
(in response to Lori Ann Galluzzo)
Is this for the free product or is this only for the at charge product?  


From:"Galluzzo, Lori (HC Product Support)" <[login to unmask email]>To:"[login to unmask email]" <[login to unmask email]>Cc:"Fennen, Odessa (HC Product Support)" <[login to unmask email]>Date:07/08/2011 12:44 PMSubject:[DB2UGCENPA] - Central PA - NO-CHARGE hands-on Optim Query Workload Tuner Workshop - Thursday - July 28th (9-2 - registration from 8:30)



IBM Optim Query Workload Tuner for z/OS Workshop

Are your DB2 queries running amuck?  Would you like to learn more about how IBM can help you tame those queries?  Please join us for a NO CHARGE hands-on Optim Query Workload Tuner workshop to be held at the IBM office in Mechanicsburg, PA.

Date: Thursday, July 28, 2011

Location:
IBM Branch office
02-2W14 2nd Floor to rear of Building from Elevators
2020 Technology Pkwy
Mechanicsburg, Pennsylvania

Time:  9:00 AM - 2:00 PM (registration begins at 8:30 AM)

There is no cost to the customer for this proof-of-technology workshop. Complementary lunch will be served.  However, participants will be responsible for their own business travel expenses.  The proof-of-technology will last approximately 5 hours including lunch and breaks.


Please view the attached document for more detail about the proof-of-technology workshop.  To register for this event, please provide the information below in an email to either Terri Kemmer ([login to unmask email]) or Stan Goodwin ([login to unmask email]).  Space is limited to 24 attendees - deadline for registration is Friday, July 22.



REGISTRATION INFORMATION:

Attendee Name:
Company Name:
Job Description:
Email:




IBM Optim Query Workload Tuner for z/OS Workshop
        An IBM Proof-of-Technology
        Information Management Software


                INTRODUCTION:
This proof-of-technology focuses on IBM Optim Query Workload Tuner® and the products that integrate to help monitor and optimize DB2® performance. Are you wondering how IBM’s Optim products relate to your DB2® Tools investment?  Are you familiar with the Eclipse interface of some of IBM’s DB2® Tools products? We spend time discussing data management and performance challenges, how IBM Optim Query Workload Tuner® can address query and workload performance, monitoring and optimization.  This proof-of-technology is designed to show how these tools can easily extend administrative functions for DB2® on z/OS.  
                OBJECTIVE:
This session enables attendees to gain an understanding of Optim Query Workload Tuner® for DB2® on z/OS.  It features lecture and hands-on laboratories.  The proof-of-technology will enable attendees to gain familiarity with the Eclipse interface, query monitoring, query tuning and workload tuning.
                AUDIENCE:
This Proof of Technology is for Database Administrators, Data Management Architects, Database Developers, Application Developers and other decision influencers evaluating IBM technologies. While managers and executives may want to attend for the presentations, it’s the technical folks who will especially want to attend for the labs in order to see these tools in action.
                AGENDA:
                        DB2® Performance and Tuning Discussion
Discuss data management, and DB2® performance and optimization.  Review strategic and tactical measures to help your staff maximize efforts.

                        Lab Overview and Discussion
                                Review logistics for lab, preview of activities that will be covered in the day’s events.

                        Lab 0: Eclipse Basics
Hands on laboratory designed to get users unfamiliar with the Eclipse Graphical Interface up to speed quickly.  Topics will include navigating the Eclipse IDE and reviewing tool interface.

                        Lab 1: Database Connection & Configuration
                                Hands-on laboratory designed to show how users can quickly connect to their DB2® subsystem and configure it for tuning.

                        Lab 2: Single Query Tuning
Hands-on laboratory designed to show users how to quickly tune problem queries in either a development or production environment on DB2®.  Lab will cover importing queries and tuning using query advisor, access path advisor, statistics advisor and index advisor.

                        Lab 3: Workload Tuning
Hands-on laboratory designed to show users how to define a workload on their DB2® subsystem and tune it using workload statistics advisor and workload index advisor.

                        Lab 4: Using Query Monitor w/ Query Workload Tuner
Hands-on laboratory designed to show how Query Monitor for DB2® integrates with Optim Query Workload Tuner.  Lab will cover monitoring activities and importing problem queries into the Optim product.
                COST/SCHEDULE:
There is no cost to customer for this proof-of-technology. Complementary refreshments and snacks will be served.  However, participants will be responsible for their own business travel expenses.  The proof-of-technology will last approximately one full business day including lunch and breaks.
                FOR MORE INFORMATION:          
                        Contact your IBM Software Sales Representative

Regards
Terri Kemmer Mechanicsburg, PA 17050DB2 Advisor USAIBM US East Extended Team System z SW Technical Professional 
Phone:1-717-610-7339  e-mail:[login to unmask email] 









Attachment Links: Picture (Device Independent Bitmap) 1.jpg (1 k)  
Site Links: View post online   View mailing list online   Send new post via email   Unsubscribe from this mailing list   Manage your subscription  

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2


============================================================================== This message contains privileged and confidential information intended for the above addressees only. If you receive this message in error please delete or destroy this message and/or attachments. The sender of this message will fully cooperate in the civil and criminal prosecution of any individual engaging in the unauthorized use of this message. ==============================================================================

Terri Kemmer

Central PA - NO-CHARGE hands-on Optim Query Workload Tuner Workshop - Thursday - July 28th (9-2 - re
(in response to Mark Labby)
This no-charge workshop is for Optim Query Workload Tuner, which is a fee
based IBM product. This proof-of-technology focuses on IBM Optim Query
Workload Tuner® and the products that integrate(such as Data Studio which
is the free software) to help monitor and optimize DB2® performance.

Regards



Terri Kemmer
Mechanicsburg, PA 17050

DB2 Advisor
USA
IBM US East Extended Team

System z SW Technical Professional


Phone:
1-717-610-7339


e-mail:
[login to unmask email]








From: Mark Labby <[login to unmask email]>
To: [login to unmask email]
Date: 07/08/2011 02:37 PM
Subject: [DB2UGCENPA] - RE: Central PA - NO-CHARGE hands-on Optim
Query Workload Tuner Workshop - Thursday - July 28th (9-2 - registration
from 8:30)



Is this for the free product or is this only for the at charge product?


From:
"Galluzzo, Lori (HC Product Support)" <[login to unmask email]>
To:
"[login to unmask email]" <[login to unmask email]>
Cc:
"Fennen, Odessa (HC Product Support)" <[login to unmask email]>
Date:
07/08/2011 12:44 PM
Subject:
[DB2UGCENPA] - Central PA - NO-CHARGE hands-on Optim Query Workload Tuner
Workshop - Thursday - July 28th (9-2 - registration from 8:30)




IBM Optim Query Workload Tuner for z/OS Workshop

Are your DB2 queries running amuck? Would you like to learn more about
how IBM can help you tame those queries? Please join us for a NO CHARGE
hands-on Optim Query Workload Tuner workshop to be held at the IBM office
in Mechanicsburg, PA.

Date: Thursday, July 28, 2011

Location:
IBM Branch office
02-2W14 2nd Floor to rear of Building from Elevators
2020 Technology Pkwy
Mechanicsburg, Pennsylvania

Time: 9:00 AM - 2:00 PM (registration begins at 8:30 AM)

There is no cost to the customer for this proof-of-technology workshop.
Complementary lunch will be served. However, participants will be
responsible for their own business travel expenses. The
proof-of-technology will last approximately 5 hours including lunch and
breaks.


Please view the attached document for more detail about the
proof-of-technology workshop. To register for this event, please provide
the information below in an email to either Terri Kemmer (
[login to unmask email]) or Stan Goodwin ([login to unmask email]). Space is
limited to 24 attendees - deadline for registration is Friday, July 22.



REGISTRATION INFORMATION:

Attendee Name:
Company Name:
Job Description:
Email:






IBM Optim Query Workload Tuner for z/OS Workshop
An IBM Proof-of-Technology
Information Management Software


INTRODUCTION:
This proof-of-technology focuses on IBM Optim Query Workload Tuner® and
the products that integrate to help monitor and optimize DB2® performance.
Are you wondering how IBM’s Optim products relate to your DB2® Tools
investment? Are you familiar with the Eclipse interface of some of IBM’s
DB2® Tools products? We spend time discussing data management and
performance challenges, how IBM Optim Query Workload Tuner® can address
query and workload performance, monitoring and optimization. This
proof-of-technology is designed to show how these tools can easily extend
administrative functions for DB2® on z/OS.
OBJECTIVE:
This session enables attendees to gain an understanding of Optim Query
Workload Tuner® for DB2® on z/OS. It features lecture and hands-on
laboratories. The proof-of-technology will enable attendees to gain
familiarity with the Eclipse interface, query monitoring, query tuning and
workload tuning.
AUDIENCE:
This Proof of Technology is for Database Administrators, Data Management
Architects, Database Developers, Application Developers and other decision
influencers evaluating IBM technologies. While managers and executives may
want to attend for the presentations, it’s the technical folks who will
especially want to attend for the labs in order to see these tools in
action.
AGENDA:
DB2® Performance and Tuning Discussion
Discuss data management, and DB2® performance and optimization. Review
strategic and tactical measures to help your staff maximize efforts.

Lab Overview and Discussion
Review logistics for lab, preview of
activities that will be covered in the day’s events.

Lab 0: Eclipse Basics
Hands on laboratory designed to get users unfamiliar with the Eclipse
Graphical Interface up to speed quickly. Topics will include navigating
the Eclipse IDE and reviewing tool interface.

Lab 1: Database Connection & Configuration
Hands-on laboratory designed to show how
users can quickly connect to their DB2® subsystem and configure it for
tuning.

Lab 2: Single Query Tuning
Hands-on laboratory designed to show users how to quickly tune problem
queries in either a development or production environment on DB2®. Lab
will cover importing queries and tuning using query advisor, access path
advisor, statistics advisor and index advisor.

Lab 3: Workload Tuning
Hands-on laboratory designed to show users how to define a workload on
their DB2® subsystem and tune it using workload statistics advisor and
workload index advisor.

Lab 4: Using Query Monitor w/ Query Workload Tuner

Hands-on laboratory designed to show how Query Monitor for DB2® integrates
with Optim Query Workload Tuner. Lab will cover monitoring activities and
importing problem queries into the Optim product.
COST/SCHEDULE:
There is no cost to customer for this proof-of-technology. Complementary
refreshments and snacks will be served. However, participants will be
responsible for their own business travel expenses. The
proof-of-technology will last approximately one full business day
including lunch and breaks.
FOR MORE INFORMATION:
Contact your IBM Software Sales Representative

Regards



Terri Kemmer
Mechanicsburg, PA 17050

DB2 Advisor
USA
IBM US East Extended Team

System z SW Technical Professional



Phone:
1-717-610-7339


e-mail:
[login to unmask email]












Attachment Links: Picture (Device Independent Bitmap) 1.jpg (1 k)
Site Links: View post online View mailing list online Send new post
via email Unsubscribe from this mailing list Manage your subscription

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2


==============================================================================
This message contains privileged and confidential information intended for
the above addressees only. If you receive this message in error please
delete or destroy this message and/or attachments. The sender of this
message will fully cooperate in the civil and criminal prosecution of any
individual engaging in the unauthorized use of this message.
==============================================================================


Site Links: View post online View mailing list online Send new post
via email Unsubscribe from this mailing list Manage your subscription

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2


Attachments

  • blankfilename.txt (<1k)