Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!

Lori Ann Galluzzo

Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!
Central PA Regional DB2 User Group
Date: Thursday December 11, 2014
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]>
Agenda for December 11, 2014
8:30-9:00 Breakfast & Announcements
Sponsored By IBM Corporation
9:00-10:15 "DB2 11 Migration Overview"

Presenter: Charles Lewis, IBM.
This presentation will discuss common challenges of migrating to DB2 11.
10:15-10:30 Break

10:30-11:45 "DB2 11 Migration Overview - continued"
Presenter: Charles Lewis, IBM Corporation.
Continued part of the first session

11:45 -12:45 Lunch - Sponsored By: IBM Corporation

1:00-2:15 "Archive Transparency in v11"
Presenter: Stan Goodwin, IBM Corporation
Archive Transparency is new for v11 - this will provide an understanding of the feature and uses.
2:15-2:30 Break

2:30-3:45 "DB2 for z/OS SQL Evolution and Performance for DB2 V10! "
Presenter: Linda Claussen, Themis
Throughout the last several releases of DB2 for z/OS IBM has introduced SQL coding and performance enhancements that are frequently overlooked. This can be achieved by using a multi-solution approach to coding and letting explain tell you which solution is best. The presented case studies in this presentation demonstrates the cost savings and elapsed time improvements when reviewing multiple solutions that produce the same result set to satisfy a given requirement. NOTE: The majority of the SQL coding techniques apply to all DB2 platforms.
Topics Covered:
1. SQL Evolution
2. Multi-Solution Strategy -A comparison of coding techniques
3. Limiting your trips to DB2 - Good Coding Practices

3:45-4:00 Closing


Lori Galluzzo
Database Administrator - Data Engineer III
Analytics & Data Management Practice (AD&M)
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

2014 IBM Champion
IBM Certified Database Administrator - DB2 10 for z/OS
IBM Certified Database Associate - DB2 10.1 Fundamentals
IBM Certified Database Administrator - DB2 10.1 for Linux/UNIX/Windows
IBM Certified Database Administrator - DB2 9 for z/OS


Paul Beltrandi Jr

Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!
(in response to Lori Ann Galluzzo)
Lori, please sign up Cathy Mertz and myself..

Thanks,
Paul Beltrandi Jr
Development DB2 DBA and Team Leader
AMS DBA Service Center
IBM Corporation
275 Grandview Avenue
Suite 201/Floor 2/Office 202E
Camp Hill, PA 17011
Tieline 8-254-7084 or 717-547-7084
[login to unmask email]



From: "Galluzzo, Lori (HC Product Support)"
<[login to unmask email]>
To: "[login to unmask email]" <[login to unmask email]>
Date: 11/21/2014 12:10 PM
Subject: [DB2UGCENPA] - Central PA Regional DB2 User Group -December
11th, 2014! Sign up December 4th!



Central PA Regional DB2 User Group


Date: Thursday December 11, 2014


Place: Giant Super Food Store Community Room, 3301 Trindle Rd , Camp Hill,
PA 17011


Cost: FREE


Reservations: Email: Odessa Fennen – [login to unmask email]


Agenda for December 11, 2014


8:30-9:00 Breakfast & Announcements


Sponsored By IBM Corporation


9:00-10:15 "DB2 11 Migration Overview”





Presenter: Charles Lewis, IBM.


This presentation will discuss common challenges of migrating to DB2 11.


10:15-10:30 Break





10:30-11:45 “DB2 11 Migration Overview - continued”


Presenter: Charles Lewis, IBM Corporation.


Continued part of the first session





11:45 -12:45 Lunch - Sponsored By: IBM Corporation





1:00-2:15 ”Archive Transparency in v11”


Presenter: Stan Goodwin, IBM Corporation


Archive Transparency is new for v11 – this will provide an understanding
of the feature and uses.


2:15–2:30 Break





2:30-3:45 “DB2 for z/OS SQL Evolution and Performance for DB2 V10! ”


Presenter: Linda Claussen, Themis


Throughout the last several releases of DB2 for z/OS IBM has introduced SQL
coding and performance enhancements that are frequently overlooked. This
can be achieved by using a multi-solution approach to coding and letting
explain tell you which solution is best. The presented case studies in this
presentation demonstrates the cost savings and elapsed time improvements
when reviewing multiple solutions that produce the same result set to
satisfy a given requirement. NOTE: The majority of the SQL coding
techniques apply to all DB2 platforms.


Topics Covered:


1. SQL Evolution


2. Multi-Solution Strategy –A comparison of coding techniques


3. Limiting your trips to DB2 - Good Coding Practices





3:45-4:00 Closing








Lori Galluzzo
Database Administrator - Data Engineer III
Analytics & Data Management Practice (AD&M)
HP Enterprise Services



Telephone +1 717.975-5482


Cell +1 717-215-0587


Pager +1 888-323-8935


Email [login to unmask email]
225 Grandview Avenue; MS:B2


Camp Hill, PA 17011





2014 IBM Champion


IBM Certified Database Administrator - DB2 10 for z/OS


IBM Certified Database Associate – DB2 10.1 Fundamentals


IBM Certified Database Administrator - DB2 10.1 for Linux/UNIX/Windows
IBM Certified Database Administrator - DB2 9 for z/OS










Site Links: View post online View mailing list online Start new thread
via email Unsubscribe from this mailing list Manage your subscription
** ** ** Attend the 2014 IDUG North America DB2 Tech Conference ** ** **
---> Philadelpia, Pennsylvania USA 4 - 8 May, 2015 <---
http://www.idug.org/na2015

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

  • graycol.gif (<1k)

Odessa Fennen

Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!
(in response to Paul Beltrandi Jr)
I have added you both to the list of attendees. See you in December!

From: Paul Beltrandi Jr [mailto:[login to unmask email]
Sent: Friday, November 21, 2014 1:11 PM
To: [login to unmask email]
Cc: CATHY MERTZ
Subject: [DB2UGCENPA] - RE: Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!


Lori, please sign up Cathy Mertz and myself..

Thanks,
Paul Beltrandi Jr
Development DB2 DBA and Team Leader
AMS DBA Service Center
IBM Corporation
275 Grandview Avenue
Suite 201/Floor 2/Office 202E
Camp Hill, PA 17011
Tieline 8-254-7084 or 717-547-7084
[login to unmask email]<mailto:[login to unmask email]>

[Inactive hide details for "Galluzzo, Lori (HC Product Support)" ---11/21/2014 12:10:02 PM---Central PA Regional DB2 User Group]"Galluzzo, Lori (HC Product Support)" ---11/21/2014 12:10:02 PM---Central PA Regional DB2 User Group Date: Thursday December 11, 2014

From: "Galluzzo, Lori (HC Product Support)" <[login to unmask email]<mailto:[login to unmask email]>>
To: "[login to unmask email]<mailto:[login to unmask email]>" <[login to unmask email]<mailto:[login to unmask email]>>
Date: 11/21/2014 12:10 PM
Subject: [DB2UGCENPA] - Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!

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

John Ryan

Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!
(in response to Odessa Fennen)
Thank you!!

From: Fennen, Odessa (HC Product Support) [mailto:[login to unmask email]
Sent: Friday, November 21, 2014 3:57 PM
To: [login to unmask email]
Cc: CATHY MERTZ
Subject: [DB2UGCENPA] - RE: Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!

I have added you both to the list of attendees. See you in December!

From: Paul Beltrandi Jr [mailto:[login to unmask email]
Sent: Friday, November 21, 2014 1:11 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Cc: CATHY MERTZ
Subject: [DB2UGCENPA] - RE: Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!


Lori, please sign up Cathy Mertz and myself..

Thanks,
Paul Beltrandi Jr
Development DB2 DBA and Team Leader
AMS DBA Service Center
IBM Corporation
275 Grandview Avenue
Suite 201/Floor 2/Office 202E
Camp Hill, PA 17011
Tieline 8-254-7084 or 717-547-7084
[login to unmask email]<mailto:[login to unmask email]>

[Inactive hide details for "Galluzzo, Lori (HC Product Support)" ---11/21/2014 12:10:02 PM---Central PA Regional DB2 User Group]"Galluzzo, Lori (HC Product Support)" ---11/21/2014 12:10:02 PM---Central PA Regional DB2 User Group Date: Thursday December 11, 2014

From: "Galluzzo, Lori (HC Product Support)" <[login to unmask email]<mailto:[login to unmask email]>>
To: "[login to unmask email]<mailto:[login to unmask email]>" <[login to unmask email]<mailto:[login to unmask email]>>
Date: 11/21/2014 12:10 PM
Subject: [DB2UGCENPA] - Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!

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

Lori Ann Galluzzo

Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!
(in response to Lori Ann Galluzzo)
Central PA Regional DB2 User Group
Date: Thursday December 11, 2014
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]>
Agenda for December 11, 2014
8:30-9:00 Breakfast & Announcements
Sponsored By IBM Corporation
9:00-10:15 "DB2 11 Migration Overview"

Presenter: Charles Lewis, IBM.
This presentation will discuss common challenges of migrating to DB2 11.
10:15-10:30 Break

10:30-11:45 "DB2 11 Migration Overview - continued"
Presenter: Charles Lewis, IBM Corporation.
Continued part of the first session

11:45 -12:45 Lunch - Sponsored By: IBM Corporation

1:00-2:15 "Archive Transparency in v11"
Presenter: Stan Goodwin, IBM Corporation
DB2 11 for z/OS provides basic archive and retrieval functions using SQL through a two table approach. This process will allow the purging of data but have the data remain accessible thru SQL applications. This small change can have large implications of production data volumes and performance.

2:15-2:30 Break

2:30-3:45 "DB2 for z/OS SQL Evolution and Performance for DB2 V10! "
Presenter: Linda Claussen, Themis
Throughout the last several releases of DB2 for z/OS IBM has introduced SQL coding and performance enhancements that are frequently overlooked. This can be achieved by using a multi-solution approach to coding and letting explain tell you which solution is best. The presented case studies in this presentation demonstrates the cost savings and elapsed time improvements when reviewing multiple solutions that produce the same result set to satisfy a given requirement. NOTE: The majority of the SQL coding techniques apply to all DB2 platforms.
Topics Covered:
1. SQL Evolution
2. Multi-Solution Strategy -A comparison of coding techniques
3. Limiting your trips to DB2 - Good Coding Practices

3:45-4:00 Closing


Lori Galluzzo
Database Administrator - Data Engineer III
Analytics & Data Management Practice (AD&M)
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

2014 IBM Champion
IBM Certified Database Administrator - DB2 10 for z/OS
IBM Certified Database Associate - DB2 10.1 Fundamentals
IBM Certified Database Administrator - DB2 10.1 for Linux/UNIX/Windows
IBM Certified Database Administrator - DB2 9 for z/OS


Chuck Krall

Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!
(in response to Lori Ann Galluzzo)
I'll be there

From: Galluzzo, Lori (HC Product Support) [mailto:[login to unmask email]
Sent: Monday, November 24, 2014 9:51 AM
To: [login to unmask email]
Subject: [DB2UGCENPA] - RE: Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!

Central PA Regional DB2 User Group
Date: Thursday December 11, 2014
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]>
Agenda for December 11, 2014
8:30-9:00 Breakfast & Announcements
Sponsored By IBM Corporation
9:00-10:15 "DB2 11 Migration Overview"

Presenter: Charles Lewis, IBM.
This presentation will discuss common challenges of migrating to DB2 11.
10:15-10:30 Break

10:30-11:45 "DB2 11 Migration Overview - continued"
Presenter: Charles Lewis, IBM Corporation.
Continued part of the first session

11:45 -12:45 Lunch - Sponsored By: IBM Corporation

1:00-2:15 "Archive Transparency in v11"
Presenter: Stan Goodwin, IBM Corporation
DB2 11 for z/OS provides basic archive and retrieval functions using SQL through a two table approach. This process will allow the purging of data but have the data remain accessible thru SQL applications. This small change can have large implications of production data volumes and performance.

2:15-2:30 Break

2:30-3:45 "DB2 for z/OS SQL Evolution and Performance for DB2 V10! "
Presenter: Linda Claussen, Themis
Throughout the last several releases of DB2 for z/OS IBM has introduced SQL coding and performance enhancements that are frequently overlooked. This can be achieved by using a multi-solution approach to coding and letting explain tell you which solution is best. The presented case studies in this presentation demonstrates the cost savings and elapsed time improvements when reviewing multiple solutions that produce the same result set to satisfy a given requirement. NOTE: The majority of the SQL coding techniques apply to all DB2 platforms.
Topics Covered:
1. SQL Evolution
2. Multi-Solution Strategy -A comparison of coding techniques
3. Limiting your trips to DB2 - Good Coding Practices

3:45-4:00 Closing


Lori Galluzzo
Database Administrator - Data Engineer III
Analytics & Data Management Practice (AD&M)
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

2014 IBM Champion
IBM Certified Database Administrator - DB2 10 for z/OS
IBM Certified Database Associate - DB2 10.1 Fundamentals
IBM Certified Database Administrator - DB2 10.1 for Linux/UNIX/Windows
IBM Certified Database Administrator - DB2 9 for z/OS



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

________________________________

This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark, its diversified business, or affiliates.

Stan Goodwin

Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!
(in response to Lori Ann Galluzzo)
Lori, here is pdf of my presentation
Stan Goodwin,
Technical Sales Specialist
DB2 Advisor for System Z
IBM Mid-Atlanitc Region
Phone: 720-342-9832
Email: [login to unmask email]

'The mass of mankind, who think more of present evil, however trifling,
then of the past grievances, however oppressive, begin to connect present
evils with present rule, and having lost, in some degree, the memory of
their ancient wrongs, desire to recall a dynasty which, thus viewed, bears
a not an unfavorable comparison with their present state'.... Mary
Frances Cusak, 'History of Ireland'.




From: "Galluzzo, Lori (HC Product Support)" <[login to unmask email]>
To: "[login to unmask email]" <[login to unmask email]>
Date: 11/24/2014 09:51 AM
Subject: [DB2UGCENPA] - RE: Central PA Regional DB2 User Group
-December 11th, 2014! Sign up December 4th!



Central PA Regional DB2 User Group
Date: Thursday December 11, 2014
Place: Giant Super Food Store Community Room, 3301 Trindle Rd , Camp Hill,
PA 17011
Cost: FREE
Reservations: Email: Odessa Fennen – [login to unmask email]
Agenda for December 11, 2014
8:30-9:00 Breakfast & Announcements
Sponsored By IBM Corporation
9:00-10:15 "DB2 11 Migration Overview”

Presenter: Charles Lewis, IBM.
This presentation will discuss common challenges of migrating to DB2 11.
10:15-10:30 Break

10:30-11:45 “DB2 11 Migration Overview - continued”
Presenter: Charles Lewis, IBM Corporation.
Continued part of the first session

11:45 -12:45 Lunch - Sponsored By: IBM Corporation

1:00-2:15 ”Archive Transparency in v11”
Presenter: Stan Goodwin, IBM Corporation
DB2 11 for z/OS provides basic archive and retrieval functions using SQL
through a two table approach. This process will allow the purging of data
but have the data remain accessible thru SQL applications. This small
change can have large implications of production data volumes and
performance.

2:15–2:30 Break

2:30-3:45 “DB2 for z/OS SQL Evolution and Performance for DB2 V10! ”
Presenter: Linda Claussen, Themis
Throughout the last several releases of DB2 for z/OS IBM has introduced
SQL coding and performance enhancements that are frequently overlooked.
This can be achieved by using a multi-solution approach to coding and
letting explain tell you which solution is best. The presented case
studies in this presentation demonstrates the cost savings and elapsed
time improvements when reviewing multiple solutions that produce the same
result set to satisfy a given requirement. NOTE: The majority of the SQL
coding techniques apply to all DB2 platforms.
Topics Covered:
1. SQL Evolution
2. Multi-Solution Strategy –A comparison of coding techniques
3. Limiting your trips to DB2 - Good Coding Practices

3:45-4:00 Closing


Lori Galluzzo
Database Administrator - Data Engineer III
Analytics & Data Management Practice (AD&M)
HP Enterprise Services

Telephone +1 717.975-5482
Cell +1 717-215-0587
Pager +1 888-323-8935
Email [login to unmask email]
225 Grandview Avenue; MS:B2
Camp Hill, PA 17011

2014 IBM Champion
IBM Certified Database Administrator - DB2 10 for z/OS
IBM Certified Database Associate – DB2 10.1 Fundamentals
IBM Certified Database Administrator - DB2 10.1 for Linux/UNIX/Windows
IBM Certified Database Administrator - DB2 9 for z/OS




Site Links: View post online View mailing list online Start new thread
via email Unsubscribe from this mailing list Manage your subscription
** ** ** Attend the 2014 IDUG North America DB2 Tech Conference ** ** **
---> Philadelpia, Pennsylvania USA 4 - 8 May, 2015 <---
http://www.idug.org/na2015

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


Attachments

  • DB2 Transparent Archiving - TRIDUG - v3.pdf (1278.8k)

Lori Ann Galluzzo

Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!
(in response to Lori Ann Galluzzo)

Central PA Regional DB2 User Group
Date: Thursday December 11, 2014
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]>
Agenda for December 11, 2014
8:30-9:00 Breakfast & Announcements
Sponsored By IBM Corporation
9:00-10:15 "DB2 11 Migration Overview"

Presenter: Charles Lewis, IBM.
This presentation will discuss common challenges of migrating to DB2 11.
10:15-10:30 Break

10:30-11:45 ""
Presenter: Charles Lewis, IBM Corporation.
Extended LRSN and RBA Support in DB2 11 for z/OS"

Topic Abstract: " The DB2 recovery log records and tracks changes made to DB2 objects and is critical for application and system restart and recovery. Prior to DB2 11, DB2 used a 6-byte log address which provide for the equivalent of 256 TB of total logging capacity. Many customers have experienced a relentless increase in transaction volumes and a growth in log record size due to use of DB2 features such as large objects (LOBs) and newer data types such as XML. Consolidation of DB2 workloads into a standalone DB2 or a smaller number of DB2 data sharing members has resulted in greater transaction volumes within each DB2 system leading to a higher rate of writing log records.

The net result is many customers are approaching the end of the DB2 log range making it necessary to reset the DB2 log RBA. Before DB2 11 resetting the log RBA requires extensive work and an extended outage. Datasharing customers process log records based on a 6-byte log record sequence number (LRSN) so there is a less disruptive option available to address this issue but even datasharing DB2s will confront this concern at some future date. DB2 11 addresses this concern by allowing for the expansion of both the log RBA and LRSN from 6 bytes to 10 bytes which provides much needed relief.

The presentation will deliver more detail on DB2 logging, the impact of the 6-byte log RBA issue and the steps required to extend log RBAs to 10 bytes in DB2 11.

11:45 -12:45 Lunch - Sponsored By: IBM Corporation

1:00-2:15 "Archive Transparency in v11"
Presenter: Stan Goodwin, IBM Corporation
DB2 11 for z/OS provides basic archive and retrieval functions using SQL through a two table approach. This process will allow the purging of data but have the data remain accessible thru SQL applications. This small change can have large implications of production data volumes and performance.

2:15-2:30 Break

2:30-3:45 "DB2 for z/OS SQL Evolution and Performance for DB2 V10! "
Presenter: Linda Claussen, Themis
Throughout the last several releases of DB2 for z/OS IBM has introduced SQL coding and performance enhancements that are frequently overlooked. This can be achieved by using a multi-solution approach to coding and letting explain tell you which solution is best. The presented case studies in this presentation demonstrates the cost savings and elapsed time improvements when reviewing multiple solutions that produce the same result set to satisfy a given requirement. NOTE: The majority of the SQL coding techniques apply to all DB2 platforms.
Topics Covered:
1. SQL Evolution
2. Multi-Solution Strategy -A comparison of coding techniques
3. Limiting your trips to DB2 - Good Coding Practices

3:45-4:00 Closing


Lori Galluzzo
Database Administrator - Data Engineer III
Analytics & Data Management Practice (AD&M)
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

2014 IBM Champion
IBM Certified Database Administrator - DB2 10 for z/OS
IBM Certified Database Associate - DB2 10.1 Fundamentals
IBM Certified Database Administrator - DB2 10.1 for Linux/UNIX/Windows
IBM Certified Database Administrator - DB2 9 for z/OS


Stan Goodwin

Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!
(in response to Lori Ann Galluzzo)

I plan to. Arrive at 8

Sent from IBM Notes Traveler

Fennen, Odessa --- [DB2UGCENPA] - RE: Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th! ---
From:"Fennen, Odessa" To:[login to unmask email]:Wed, Dec 3, 2014 17:50Subject:[DB2UGCENPA] - RE: Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!
Hi Stan, I wanted to touch base with you on the LRUG for Dec 11th.  I was wondering what time you will be arriving?    I am unable to get to the meeting early because of my kids getting on the bus in the morning.  I won’t be able to arrive until around 9:00 am.   I just wanted to make you aware.  Give me a call if you want to discuss this.  Thanks! Odessa FennenDatabase Administrator IBM Certified Database Associate DB2 10 FundamentalsIBM Certified Database Administrator DB2 10 for z/OS
Americas Data Engineering (AMS DE)
HP Enterprise Services
Telephone +1 717.972.6547
Mobile +1 717.215.4226
Email [login to unmask email]  
225 Grandview Avenue, MS: B2   Camp Hill, PA  17011  From: Stanley Goodwin [mailto:[login to unmask email]
Sent: Monday, December 01, 2014 8:48 PM
To: [login to unmask email]
Subject: [DB2UGCENPA] - RE: Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th! Lori, here is pdf of my presentation
Stan Goodwin,
Technical Sales Specialist
DB2 Advisor for System Z
IBM Mid-Atlanitc Region
Phone: 720-342-9832
Email: [login to unmask email]

'The mass of mankind, who think more of present evil, however trifling, then of the past grievances, however oppressive, begin to connect present evils with present rule, and having lost, in some degree, the memory of their ancient wrongs, desire to recall a dynasty which, thus viewed, bears a not an unfavorable comparison with their present state'....  Mary Frances Cusak, 'History of Ireland'.




From:        "Galluzzo, Lori (HC Product Support)"
To:        "[login to unmask email]"
Date:        11/24/2014 09:51 AM
Subject:        [DB2UGCENPA] - RE: Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!


Central PA Regional DB2 User Group
Date: Thursday December 11, 2014
Place: Giant Super Food Store Community Room, 3301 Trindle Rd , Camp Hill, PA 17011
Cost: FREE
Reservations: Email: Odessa Fennen –  [login to unmask email]
Agenda for December 11, 2014
8:30-9:00 Breakfast & Announcements
Sponsored By IBM Corporation
9:00-10:15 "DB2 11  Migration Overview”

Presenter: Charles Lewis, IBM.  
This presentation will discuss common challenges of migrating to DB2 11.
10:15-10:30 Break

10:30-11:45  “DB2 11  Migration Overview - continued”
Presenter: Charles Lewis, IBM Corporation.  
Continued part of the first session

11:45 -12:45 Lunch - Sponsored By: IBM Corporation

1:00-2:15 ”Archive Transparency in v11”
Presenter: Stan Goodwin, IBM Corporation
DB2 11 for z/OS provides basic archive and retrieval functions using SQL through a two table approach. This process will allow the purging of data but have the data remain accessible thru SQL applications. This small change can have large implications of production data volumes and performance.

2:15–2:30 Break

2:30-3:45 “DB2 for z/OS SQL Evolution and Performance for DB2 V10! ”
Presenter: Linda Claussen, Themis
Throughout the last several releases of DB2 for z/OS IBM has introduced SQL coding and performance enhancements that are frequently overlooked. This can be achieved by using a multi-solution approach to coding and letting explain tell you which solution is best. The presented case studies in this presentation demonstrates the cost savings and elapsed time improvements when reviewing multiple solutions that produce the same result set to satisfy a given requirement. NOTE: The majority of the SQL coding techniques apply to all DB2 platforms.
Topics Covered:
1.           SQL Evolution
2.           Multi-Solution Strategy –A comparison of coding  techniques
3.           Limiting your trips to DB2 - Good Coding Practices

3:45-4:00 Closing


Lori Galluzzo
Database Administrator - Data Engineer III
Analytics & Data Management Practice (AD&M)
HP Enterprise Services

Telephone +1 717.975-5482
Cell +1 717-215-0587
Pager +1 888-323-8935
Email [login to unmask email]
225 Grandview Avenue; MS:B2  
Camp Hill, PA  17011                  

2014 IBM Champion
IBM Certified Database Administrator - DB2 10 for z/OS
IBM Certified Database Associate         – DB2 10.1 Fundamentals
IBM Certified Database Administrator - DB2 10.1 for Linux/UNIX/Windows
IBM Certified Database Administrator - DB2 9 for z/OS



Site Links: View post online   View mailing list online   Start new thread via email   Unsubscribe from this mailing list   Manage your subscription  
** ** ** Attend the 2014 IDUG North America DB2 Tech Conference ** ** **
---> Philadelpia, Pennsylvania USA 4 - 8 May, 2015 <---
http://www.idug.org/na2015

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2 -----End Original Message-----
Attachment Links: image001.jpg (1 k)  
Site Links: View post online   View mailing list online   Start new thread via email   Unsubscribe from this mailing list   Manage your subscription  
** ** IDUG DB2 Tech Conference in Philadelphia, Pennsylvania, USA 2015 ** **
---> Philadelphia, Pennsylvania, USA, 4 - 8 May, 2015 <---
http://www.idug.org/p/cm/ld/fid=551

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

Edited By:
Mark Labby[Organization Members] @ Dec 03, 2014 - 06:39 PM (America/Eastern)

John Ryan

Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!
(in response to Lori Ann Galluzzo)
Hi Odessa,

I’m sorry to hear that Lori is not feeling well.

As you know, I will be at the meeting on the 11th. And I live in Bel Air, MD, but I normally get up there around 6:30 – 7:00 because I get up at my normal time of 4 a.m. and just get going---I don’t like a lot of traffic.

If you could have all of the meeting materials upstairs the night before, I can set everything up – the signs and handouts – when I get there.

That way, there is no burden on you guys.

Please advise.

Thanks,
John

From: Fennen, Odessa [mailto:[login to unmask email]
Sent: Wednesday, December 03, 2014 5:48 PM
To: [login to unmask email]
Subject: [DB2UGCENPA] - RE: Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!

Hi Stan,

I wanted to touch base with you on the LRUG for Dec 11th. I was wondering what time you will be arriving? As you know, Lori’s health is failing miserably. And I’m just not sure how well she is even going to be to get everything set up for this meeting. I have asked her if she has everything covered and needs additional help. She seems to think everything is under control, but I’m just not sure. I am unable to get to the meeting early because of my kids getting on the bus in the morning. I won’t be able to arrive until around 9:00 am. I just wanted to make you aware.

Give me a call if you want to discuss this.

Thanks!


Odessa Fennen
Database Administrator

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

Americas Data Engineering (AMS DE)
HP Enterprise Services
Telephone +1 717.972.6547
Mobile +1 717.215.4226
Email [login to unmask email]<mailto:[login to unmask email]>
225 Grandview Avenue, MS: B2
Camp Hill, PA 17011
[Description: Description: Description: hp_logo_300dpi]



From: Stanley Goodwin [mailto:[login to unmask email]
Sent: Monday, December 01, 2014 8:48 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2UGCENPA] - RE: Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!

Lori, here is pdf of my presentation
Stan Goodwin,
Technical Sales Specialist
DB2 Advisor for System Z
IBM Mid-Atlanitc Region
Phone: 720-342-9832
Email: [login to unmask email]<mailto:[login to unmask email]>

'The mass of mankind, who think more of present evil, however trifling, then of the past grievances, however oppressive, begin to connect present evils with present rule, and having lost, in some degree, the memory of their ancient wrongs, desire to recall a dynasty which, thus viewed, bears a not an unfavorable comparison with their present state'.... Mary Frances Cusak, 'History of Ireland'.




From: "Galluzzo, Lori (HC Product Support)" <[login to unmask email]<mailto:[login to unmask email]>>
To: "[login to unmask email]<mailto:[login to unmask email]>" <[login to unmask email]<mailto:[login to unmask email]>>
Date: 11/24/2014 09:51 AM
Subject: [DB2UGCENPA] - RE: Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!
-----End Original Message-----

Chuck Krall

Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!
(in response to Lori Ann Galluzzo)
Hi Lori

Do you have th ehand houts?

From: Galluzzo, Lori (HC Product Support) [mailto:[login to unmask email]
Sent: Wednesday, December 03, 2014 9:04 AM
To: [login to unmask email]
Subject: [DB2UGCENPA] - RE: Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!


Central PA Regional DB2 User Group
Date: Thursday December 11, 2014
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]>
Agenda for December 11, 2014
8:30-9:00 Breakfast & Announcements
Sponsored By IBM Corporation
9:00-10:15 "DB2 11 Migration Overview"

Presenter: Charles Lewis, IBM.
This presentation will discuss common challenges of migrating to DB2 11.
10:15-10:30 Break

10:30-11:45 ""
Presenter: Charles Lewis, IBM Corporation.
Extended LRSN and RBA Support in DB2 11 for z/OS"

Topic Abstract: " The DB2 recovery log records and tracks changes made to DB2 objects and is critical for application and system restart and recovery. Prior to DB2 11, DB2 used a 6-byte log address which provide for the equivalent of 256 TB of total logging capacity. Many customers have experienced a relentless increase in transaction volumes and a growth in log record size due to use of DB2 features such as large objects (LOBs) and newer data types such as XML. Consolidation of DB2 workloads into a standalone DB2 or a smaller number of DB2 data sharing members has resulted in greater transaction volumes within each DB2 system leading to a higher rate of writing log records.

The net result is many customers are approaching the end of the DB2 log range making it necessary to reset the DB2 log RBA. Before DB2 11 resetting the log RBA requires extensive work and an extended outage. Datasharing customers process log records based on a 6-byte log record sequence number (LRSN) so there is a less disruptive option available to address this issue but even datasharing DB2s will confront this concern at some future date. DB2 11 addresses this concern by allowing for the expansion of both the log RBA and LRSN from 6 bytes to 10 bytes which provides much needed relief.

The presentation will deliver more detail on DB2 logging, the impact of the 6-byte log RBA issue and the steps required to extend log RBAs to 10 bytes in DB2 11.

11:45 -12:45 Lunch - Sponsored By: IBM Corporation

1:00-2:15 "Archive Transparency in v11"
Presenter: Stan Goodwin, IBM Corporation
DB2 11 for z/OS provides basic archive and retrieval functions using SQL through a two table approach. This process will allow the purging of data but have the data remain accessible thru SQL applications. This small change can have large implications of production data volumes and performance.

2:15-2:30 Break

2:30-3:45 "DB2 for z/OS SQL Evolution and Performance for DB2 V10! "
Presenter: Linda Claussen, Themis
Throughout the last several releases of DB2 for z/OS IBM has introduced SQL coding and performance enhancements that are frequently overlooked. This can be achieved by using a multi-solution approach to coding and letting explain tell you which solution is best. The presented case studies in this presentation demonstrates the cost savings and elapsed time improvements when reviewing multiple solutions that produce the same result set to satisfy a given requirement. NOTE: The majority of the SQL coding techniques apply to all DB2 platforms.
Topics Covered:
1. SQL Evolution
2. Multi-Solution Strategy -A comparison of coding techniques
3. Limiting your trips to DB2 - Good Coding Practices

3:45-4:00 Closing


Lori Galluzzo
Database Administrator - Data Engineer III
Analytics & Data Management Practice (AD&M)
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

2014 IBM Champion
IBM Certified Database Administrator - DB2 10 for z/OS
IBM Certified Database Associate - DB2 10.1 Fundamentals
IBM Certified Database Administrator - DB2 10.1 for Linux/UNIX/Windows
IBM Certified Database Administrator - DB2 9 for z/OS



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

________________________________

This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark, its diversified business, or affiliates.

Jack Wilkie

Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!
(in response to Lori Ann Galluzzo)
Lori, how can I get a copy of these presentations? Thank you. Jack Wilkie
>
> Central PA Regional DB2 User Group
> Date: Thursday December 11, 2014
> 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]>
> Agenda for December 11, 2014
> 8:30-9:00 Breakfast & Announcements
> Sponsored By IBM Corporation
> 9:00-10:15 "DB2 11 Migration Overview"
>
> Presenter: Charles Lewis, IBM.
> This presentation will discuss common challenges of migrating to DB2 11.
> 10:15-10:30 Break
>
> 10:30-11:45 ""
> Presenter: Charles Lewis, IBM Corporation.
> Extended LRSN and RBA Support in DB2 11 for z/OS"
>
> Topic Abstract: " The DB2 recovery log records and tracks changes made to
> DB2 objects and is critical for application and system restart and
> recovery. Prior to DB2 11, DB2 used a 6-byte log address which provide for
> the equivalent of 256 TB of total logging capacity. Many customers have
> experienced a relentless increase in transaction volumes and a growth in
> log record size due to use of DB2 features such as large objects (LOBs)
> and newer data types such as XML. Consolidation of DB2 workloads into a
> standalone DB2 or a smaller number of DB2 data sharing members has
> resulted in greater transaction volumes within each DB2 system leading to
> a higher rate of writing log records.
>
> The net result is many customers are approaching the end of the DB2 log
> range making it necessary to reset the DB2 log RBA. Before DB2 11
> resetting the log RBA requires extensive work and an extended outage.
> Datasharing customers process log records based on a 6-byte log record
> sequence number (LRSN) so there is a less disruptive option available to
> address this issue but even datasharing DB2s will confront this concern at
> some future date. DB2 11 addresses this concern by allowing for the
> expansion of both the log RBA and LRSN from 6 bytes to 10 bytes which
> provides much needed relief.
>
> The presentation will deliver more detail on DB2 logging, the impact of
> the 6-byte log RBA issue and the steps required to extend log RBAs to 10
> bytes in DB2 11.
>
> 11:45 -12:45 Lunch - Sponsored By: IBM Corporation
>
> 1:00-2:15 "Archive Transparency in v11"
> Presenter: Stan Goodwin, IBM Corporation
> DB2 11 for z/OS provides basic archive and retrieval functions using SQL
> through a two table approach. This process will allow the purging of data
> but have the data remain accessible thru SQL applications. This small
> change can have large implications of production data volumes and
> performance.
>
> 2:15-2:30 Break
>
> 2:30-3:45 "DB2 for z/OS SQL Evolution and Performance for DB2 V10! "
> Presenter: Linda Claussen, Themis
> Throughout the last several releases of DB2 for z/OS IBM has introduced
> SQL coding and performance enhancements that are frequently overlooked.
> This can be achieved by using a multi-solution approach to coding and
> letting explain tell you which solution is best. The presented case
> studies in this presentation demonstrates the cost savings and elapsed
> time improvements when reviewing multiple solutions that produce the same
> result set to satisfy a given requirement. NOTE: The majority of the SQL
> coding techniques apply to all DB2 platforms.
> Topics Covered:
> 1. SQL Evolution
> 2. Multi-Solution Strategy -A comparison of coding techniques
> 3. Limiting your trips to DB2 - Good Coding Practices
>
> 3:45-4:00 Closing
>
>
> Lori Galluzzo
> Database Administrator - Data Engineer III
> Analytics & Data Management Practice (AD&M)
> 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
>
> 2014 IBM Champion
> IBM Certified Database Administrator - DB2 10 for z/OS
> IBM Certified Database Associate - DB2 10.1 Fundamentals
> IBM Certified Database Administrator - DB2 10.1 for Linux/UNIX/Windows
> IBM Certified Database Administrator - DB2 9 for z/OS
>
>
>
> -----End Original Message-----
>


Jack Wilkie
President
Southern Solutions Group
[login to unmask email]
336-210-2993