• Jun 5, 2013 from 8:30am to 4:15pm
  • Location: Giant Super Food Store Community Room
  • Latest Activity: Sep 2, 2021

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 – odessa.fennen@hp.com   - 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/ lori.galluzzo@hp.com       

 

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

 

Votes: 0
E-mail me when people leave their comments –

You need to be a member of World Of Db2 to add comments!

Join World Of Db2