Skip to content

Central Pa Db2 User Group Dec 12, 2018

November 5, 2018



Central PA Regional DB2 User Group

Date: Wednesday, December 12, 2018

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

Cost: FREE

Reservations: Email: Odessa Fennen –


Agenda for December 12, 2018

8:30-9:00 Breakfast & Announcements

Sponsored By  Gunning Technology Solutions


9:00-10:15  “DB2 BAR Best Practices

Presenter:  Dale McInnis, IBM

In this presentation we will discuss the options open to customer for DB2 recovery. We will review the options available for different levels of granular recovery, be it object level, tablespace level, node level or DB level. Best practices and what real customers are doing will be discussed.
10:15-10:30 Break


10:30-11:45   DB2 HADR Multiple Standby Deep Dive”

Presenter:  Dale McInnis, IBM

In this presentation we will look at the details behind running HADR in a multiple standby environment.  How does the configuration differ from a single standby and what restrictions are there.   Best practices on how to provide automation in the case of a disaster will be examined.


11:45 -1:00   Lunch – Sponsored By:  Gunning Technology Solutions


1:00 – 2:15   “DB2 LUW Table Partitioning for Superior Performance and Availability””

Presenter:  Phil Gunning, Gunning Technology Solutions

First seen in DB2 v4 for z/OS in the early 90’s, table partitioning was included in and announced for Db2 LUW 9.1. DBAs need to be familiar with table partitioning to manage the historic growth in data that is occurring and will occur with the Internet of Things. The need for table partitioning is driven by the sheer size of data today, and it enables DBAs to meet business objectives through table partitioning to improve the performance and availability of data; along with the ability to roll in new partitions and roll old data out. This session will highlight how to achieve improved performance through query partition elimination and proper indexing along with achieving high availability with online utilities.


2:15 – 2:30 Closing





From → Uncategorized

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: