CENTRAL PA REGIONAL DB2 USER GROUP - WEDS. JUNE 5TH, 2013 - SIGN UP BY MAY 29TH

Lori Ann Galluzzo

CENTRAL PA REGIONAL DB2 USER GROUP - WEDS. JUNE 5TH, 2013 - SIGN UP BY MAY 29TH
Central PA Regional DB2 User Group
Date: Wednesday, June 5th, 2013
Place: Giant Super Food Store Community Room, 3301 Trindle Rd , Camp Hill, PA 17011
Cost: FREE
Reservations: Email: Odessa Fennen - [login to unmask email]<mailto:[login to unmask email]> - BY May 29th, 2013
Agenda for June 5th 2013
8:30-9:15 Breakfast, Networking & Announcements
Sponsored By: CorreLog, Inc.

9:15-10:30 "DB2 Application Performance APRTI (Access Path Run Time Investigation)"
Presenter: Randy Ebersole , IBM Corporation
The DB2 Optimizer is responsible in choosing the best access path to satisfy SQL data manipulation requirements. The review of the explanation of the access path allows for a certain level of performance understanding. But, at SQL execution time, other variables will impact actual application performance. All good access path choices don't always lead to good run time results. This review will provide various examples of common DB2 application performance scenarios and considerations for evaluating execution time variables. The goal of this presentation is to present possible solutions on database design and SQL coding to reduce the impact of run time variables and improve application performance.

10:30-10:45 Break

10:45-12:00 "Safety in Numbers! - How I Learned to Stop Worrying and Love IFCID'S - IFCID's for DB2 Security "
Presenter: Charles Mills; CorreLog, Inc.

DB2 Security is an ever changing topic - from regulatory requirements to customer SLA''s. It includes what to audit, what IFCID's measure the information needed & steps in understanding what needs to be done to feel secure with your system. It reviews what tools are available in general also.

12:00 -1:15 Lunch & Drawings - Sponsored By: CorreLog, Inc.
12:30 -1:00 Demo - Correlog db Defender - Presenter: Charles Mills; CorreLog, Inc.

1:15-2:30 "Top 25 Tuning Tips "
Presenter: Tony Andrews , Themis Inc.
Most relational tuning experts agree that the majority of performance problems
with applications that access a relational database are caused by poorly coded
programs or improperly coded SQL. Industry experts agree that poorly performing
SQL is responsible for as much as 80 percent of response-time issues. SQL
developers should be informed of the many performance issues associated with the
SQL language and the way they design their programs. It would be especially helpful
if more developers were educated in how to read and analyze DB2 Explain output.

2:30-2:45 Break

2:45-4:00 "DB2 Tuning and Data Studio Overview!"
Presenter: Tony Andrews, Themis Inc.

This presentation will provide a basic overview of Data Studio & how to use it for DB2 Tuning for your systems.

4:00-4:15 Closing

WATCH FOR ANNOUNCEMENT ON FEE BASED CLASS - JUNE 6TH - DAY AFTER THIS RUG MEETING - SIGN UP W/ [login to unmask email]<mailto:[login to unmask email]>

IDUG CENTRAL PA RUG - jUNE 6TH, 2013 - DB2 10 APPLICATION FEATURES & ADVNCED SQL - FEE : $165 to THEMIS iNC. - TONY ANDREWS PRESENTER

Lori Galluzzo
Database Administrator - Data Engineer III
Americas Data Engineering Capability
HP Enterprise Services
Telephone +1 717.975-5482
Cell +1 717-215-0587
Pager +1 888-323-8935
Email [login to unmask email]<mailto:[login to unmask email]>
225 Grandview Avenue; MS:B2
Camp Hill, PA 17011

IBM Certified Database Administrator - DB2 10 for z/OS
IBM Certified Database Associate - DB2 10.1 Fundamentals
IBM Certified Database Administrator - DB2 9 for z/OS



Robert Somers

CENTRAL PA REGIONAL DB2 USER GROUP - WEDS. JUNE 5TH, 2013 - SIGN UP BY MAY 29TH
(in response to Lori Ann Galluzzo)
Odessa,

Please sign me up. Thanks

-Rob

Rob Somers | Database Administrator
PA Department of Transportation | Bureau of Infrastructure and Operations
Information Systems and Technology Office
400 North St, 5th Floor | Harrisburg, PA 17120
Phone: 717.787.8445 | Fax: 717.783.8038
www.dot.state.pa.us<http://www.dot.state.pa.us>



From: Galluzzo, Lori (HC Product Support) [mailto:[login to unmask email]
Sent: Monday, May 13, 2013 4:28 PM
To: [login to unmask email]; [login to unmask email]
Subject: [DB2UGCENPA] - CENTRAL PA REGIONAL DB2 USER GROUP - WEDS. JUNE 5TH, 2013 - SIGN UP BY MAY 29TH

Central PA Regional DB2 User Group
Date: Wednesday, June 5th, 2013
Place: Giant Super Food Store Community Room, 3301 Trindle Rd , Camp Hill, PA 17011
Cost: FREE
Reservations: Email: Odessa Fennen - [login to unmask email]<mailto:[login to unmask email]> - BY May 29th, 2013
Agenda for June 5th 2013
8:30-9:15 Breakfast, Networking & Announcements
Sponsored By: CorreLog, Inc.

9:15-10:30 "DB2 Application Performance APRTI (Access Path Run Time Investigation)"
Presenter: Randy Ebersole , IBM Corporation
The DB2 Optimizer is responsible in choosing the best access path to satisfy SQL data manipulation requirements. The review of the explanation of the access path allows for a certain level of performance understanding. But, at SQL execution time, other variables will impact actual application performance. All good access path choices don't always lead to good run time results. This review will provide various examples of common DB2 application performance scenarios and considerations for evaluating execution time variables. The goal of this presentation is to present possible solutions on database design and SQL coding to reduce the impact of run time variables and improve application performance.

10:30-10:45 Break

10:45-12:00 "Safety in Numbers! - How I Learned to Stop Worrying and Love IFCID'S - IFCID's for DB2 Security "
Presenter: Charles Mills; CorreLog, Inc.

DB2 Security is an ever changing topic - from regulatory requirements to customer SLA''s. It includes what to audit, what IFCID's measure the information needed & steps in understanding what needs to be done to feel secure with your system. It reviews what tools are available in general also.

12:00 -1:15 Lunch & Drawings - Sponsored By: CorreLog, Inc.
12:30 -1:00 Demo - Correlog db Defender - Presenter: Charles Mills; CorreLog, Inc.

1:15-2:30 "Top 25 Tuning Tips "
Presenter: Tony Andrews , Themis Inc.
Most relational tuning experts agree that the majority of performance problems
with applications that access a relational database are caused by poorly coded
programs or improperly coded SQL. Industry experts agree that poorly performing
SQL is responsible for as much as 80 percent of response-time issues. SQL
developers should be informed of the many performance issues associated with the
SQL language and the way they design their programs. It would be especially helpful
if more developers were educated in how to read and analyze DB2 Explain output.

2:30-2:45 Break

2:45-4:00 "DB2 Tuning and Data Studio Overview!"
Presenter: Tony Andrews, Themis Inc.

This presentation will provide a basic overview of Data Studio & how to use it for DB2 Tuning for your systems.

4:00-4:15 Closing

WATCH FOR ANNOUNCEMENT ON FEE BASED CLASS - JUNE 6TH - DAY AFTER THIS RUG MEETING - SIGN UP W/ [login to unmask email]<mailto:[login to unmask email]>

IDUG CENTRAL PA RUG - jUNE 6TH, 2013 - DB2 10 APPLICATION FEATURES & ADVNCED SQL - FEE : $165 to THEMIS iNC. - TONY ANDREWS PRESENTER

Lori Galluzzo
Database Administrator - Data Engineer III
Americas Data Engineering Capability
HP Enterprise Services
Telephone +1 717.975-5482
Cell +1 717-215-0587
Pager +1 888-323-8935
Email [login to unmask email]<mailto:[login to unmask email]>
225 Grandview Avenue; MS:B2
Camp Hill, PA 17011

IBM Certified Database Administrator - DB2 10 for z/OS
IBM Certified Database Associate - DB2 10.1 Fundamentals
IBM Certified Database Administrator - DB2 9 for z/OS




-----End Original Message-----

Odessa Fennen

CENTRAL PA REGIONAL DB2 USER GROUP - WEDS. JUNE 5TH, 2013 - SIGN UP BY MAY 29TH
(in response to Robert Somers)
I will sign you up...Thanks!

From: Somers, Robert [mailto:[login to unmask email]
Sent: Tuesday, May 21, 2013 1:39 PM
To: [login to unmask email]
Subject: [DB2UGCENPA] - RE: CENTRAL PA REGIONAL DB2 USER GROUP - WEDS. JUNE 5TH, 2013 - SIGN UP BY MAY 29TH

Odessa,

Please sign me up. Thanks

-Rob

Rob Somers | Database Administrator
PA Department of Transportation | Bureau of Infrastructure and Operations
Information Systems and Technology Office
400 North St, 5th Floor | Harrisburg, PA 17120
Phone: 717.787.8445 | Fax: 717.783.8038
www.dot.state.pa.us<http://www.dot.state.pa.us>



From: Galluzzo, Lori (HC Product Support) [mailto:[login to unmask email]
Sent: Monday, May 13, 2013 4:28 PM
To: [login to unmask email]<mailto:[login to unmask email]>; [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2UGCENPA] - CENTRAL PA REGIONAL DB2 USER GROUP - WEDS. JUNE 5TH, 2013 - SIGN UP BY MAY 29TH

Central PA Regional DB2 User Group
Date: Wednesday, June 5th, 2013
Place: Giant Super Food Store Community Room, 3301 Trindle Rd , Camp Hill, PA 17011
Cost: FREE
Reservations: Email: Odessa Fennen - [login to unmask email]<mailto:[login to unmask email]> - BY May 29th, 2013
Agenda for June 5th 2013
8:30-9:15 Breakfast, Networking & Announcements
Sponsored By: CorreLog, Inc.

9:15-10:30 "DB2 Application Performance APRTI (Access Path Run Time Investigation)"
Presenter: Randy Ebersole , IBM Corporation
The DB2 Optimizer is responsible in choosing the best access path to satisfy SQL data manipulation requirements. The review of the explanation of the access path allows for a certain level of performance understanding. But, at SQL execution time, other variables will impact actual application performance. All good access path choices don't always lead to good run time results. This review will provide various examples of common DB2 application performance scenarios and considerations for evaluating execution time variables. The goal of this presentation is to present possible solutions on database design and SQL coding to reduce the impact of run time variables and improve application performance.

10:30-10:45 Break

10:45-12:00 "Safety in Numbers! - How I Learned to Stop Worrying and Love IFCID'S - IFCID's for DB2 Security "
Presenter: Charles Mills; CorreLog, Inc.

DB2 Security is an ever changing topic - from regulatory requirements to customer SLA''s. It includes what to audit, what IFCID's measure the information needed & steps in understanding what needs to be done to feel secure with your system. It reviews what tools are available in general also.

12:00 -1:15 Lunch & Drawings - Sponsored By: CorreLog, Inc.
12:30 -1:00 Demo - Correlog db Defender - Presenter: Charles Mills; CorreLog, Inc.

1:15-2:30 "Top 25 Tuning Tips "
Presenter: Tony Andrews , Themis Inc.
Most relational tuning experts agree that the majority of performance problems
with applications that access a relational database are caused by poorly coded
programs or improperly coded SQL. Industry experts agree that poorly performing
SQL is responsible for as much as 80 percent of response-time issues. SQL
developers should be informed of the many performance issues associated with the
SQL language and the way they design their programs. It would be especially helpful
if more developers were educated in how to read and analyze DB2 Explain output.

2:30-2:45 Break

2:45-4:00 "DB2 Tuning and Data Studio Overview!"
Presenter: Tony Andrews, Themis Inc.

This presentation will provide a basic overview of Data Studio & how to use it for DB2 Tuning for your systems.

4:00-4:15 Closing

WATCH FOR ANNOUNCEMENT ON FEE BASED CLASS - JUNE 6TH - DAY AFTER THIS RUG MEETING - SIGN UP W/ [login to unmask email]<mailto:[login to unmask email]>

IDUG CENTRAL PA RUG - jUNE 6TH, 2013 - DB2 10 APPLICATION FEATURES & ADVNCED SQL - FEE : $165 to THEMIS iNC. - TONY ANDREWS PRESENTER

Lori Galluzzo
Database Administrator - Data Engineer III
Americas Data Engineering Capability
HP Enterprise Services
Telephone +1 717.975-5482
Cell +1 717-215-0587
Pager +1 888-323-8935
Email [login to unmask email]<mailto:[login to unmask email]>
225 Grandview Avenue; MS:B2
Camp Hill, PA 17011

IBM Certified Database Administrator - DB2 10 for z/OS
IBM Certified Database Associate - DB2 10.1 Fundamentals
IBM Certified Database Administrator - DB2 9 for z/OS




-----End Original Message-----

-----End Original Message-----