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

Jack Wilkie

[Fwd: Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!]
Hi Lori. I would like these handouts also. Thanks.

---------------------------- Original Message ----------------------------
Subject: [DB2UGCENPA] - RE: Central PA Regional DB2 User Group -December
11th, 2014! Sign up December 4th!
From: "Krall, Chuck F" <[login to unmask email]>
Date: Wed, December 10, 2014 10:12 am
To: "[login to unmask email]" <[login to unmask email]>
--------------------------------------------------------------------------

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-----

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


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

  • untitled-[2].html (13.4k)

Odessa Fennen

[Fwd: Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!]
(in response to Jack Wilkie)
Please send me your email address...please send to [login to unmask email] .

Thanks!

-----Original Message-----
From: Jack Wilkie [mailto:[login to unmask email]
Sent: Wednesday, December 17, 2014 1:34 PM
To: [login to unmask email]
Subject: [DB2UGCENPA] - [Fwd: RE: Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!]

Hi Lori. I would like these handouts also. Thanks.

---------------------------- Original Message ----------------------------
Subject: [DB2UGCENPA] - RE: Central PA Regional DB2 User Group -December 11th, 2014! Sign up December 4th!
From: "Krall, Chuck F" <[login to unmask email]>
Date: Wed, December 10, 2014 10:12 am
To: "[login to unmask email]" <[login to unmask email]>
--------------------------------------------------------------------------

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-----

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


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

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