Skip to content

Db2 JDBC Drivers and Versions

I get asked for this information all the time so I thought I would share the link with all of you….

http://www-01.ibm.com/support/docview.wss?uid=swg21363866

Central Pa Db2 User Group Dec 12, 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 –   odessa.fennen@hmhs.com

 

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 Row and Column Access Control (RCAC)”

Presenter:  Phil Gunning, Gunning Technology Solutions

Attend this session to learn how control access to data using RCAC. The Encrypt and Decrypt functions have been deprecated in DB2 10.5 and beyond and RCAC is the new way of protecting columns and rows from unauthorized access. This session will provide examples of how to implement RCAC and how to use groups and roles to protect data. Along with Db2 Native Encryption, this provides a powerful solution to protect your data.

2:15 – 2:30 Closing

 

 

 

 

Windows Operating System Support for Db2 9.7

If you are planning your migration to Db2 11 you need to pay attention to supported Windows levels….http://www-01.ibm.com/support/docview.wss?uid=swg21665082

Db2 Operating System Requirements

Moving from 9.7 to 11? Windows 2008 Server not supported. See the requirements per Db2 Version here: https://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/softwareReqsForProduct?deliverableId=C4F0F2105FF511E6865BC3F213DB63F7&osPlatforms=Windows&duComponentIds=S001%7CS006%7CS005%7CS003%7CS004%7CA002%7CA007%7CA008&mandatoryCapIds=183%7C25&optionalCapIds=30%7C341%7C47%7C17%7C1%7C20%7C28

Db2 Snapshot Monitoring Views — Refresher

If you are still relying on snapshots, you  might want to take a look at snapshot monitoring views introduced in Db2 9.7.  Although Db2 9.7 has been out of support for some time, I find there are many companies still working on moving off it to a supported releases. If you are in this boat, use this Developer works article to get you moving to the new monitoring. https://www.ibm.com/developerworks/data/library/techarticle/dm-1306snapshotmonitoring/index.html

Web Interface to Z/OS — Zowe Announced

This is a web interface that was announced at SHARE today. Check it out at https://zowe.org/.  Zowe

POWER9 and E950 and E980 Servers Announced — Announcement and Additional Material

Many businesses run Db2 on AIX POWER and it only gets better with POWER9…Get all you need on the AIX Developer Works blog by Nigel Griffiths, here https://www.ibm.com/developerworks/community/blogs/aixpert/entry/POWER9_Enterprise_E950_and_E980_Information?lang=en