DB2 Connect VUG Date and Time Announced

Posted by Kim May on March 30, 2011 under DB2 Connect, DB2 for z/OS, International DB2 Users Group (IDUG). Tags: , , , .

IBM DB2 Connect expert Melanie Stopfer’s Presentation, “Help Me, Help You – DRDA Connections to DB2 for z/OS” will be delivered to the DB2 Connect Virtual Users Group on Tuesday, April 27th, from 12:00pm-1:00pm EDT.  All are welcome to join us for this webinar.  Register here.

Abstract:
Do you want to better understand and tune your remote DRDA connections to DB2 z/OS? Are you looking for tips to make your life easier?  Melanie will present analogies and insider advice to help improve performance, availability, reliability, and usability. The goal is to provide you with an arsenal of tips you can use in various remote DRDA distributed to DB2 z/OS situations.  Come learn new DB2 Connect and JDBC Universal Driver tips and tricks that you need to know.

Read More…

DB2 Connect Virtual Users Group – Melanie Stopfer

Posted by Kim May on March 18, 2011 under DB2 Connect, DB2 Education, International DB2 Users Group (IDUG), Uncategorized. Tags: , , , , , .

IBM’s Melanie Stopfer has volunteered to present at the next DB2 Connect VUG session.  Melanie’s presentation is titled, “Help Me, Help You, Remote DRDA Connections to DB2 z/OS“.    The session abstract and objectives are below, along with Melanie’s bio.  I hope you will join us!

Abstract:
Do you want to better understand and tune your remote DRDA connections to DB2 z/OS? Are you looking for tips to make your life easier?  Melanie will present analogies and insider advice to help improve performance, availability, reliability, and usability. The goal is to provide you with an arsenal of tips you can use in various remote DRDA distributed to DB2 z/OS situations.  Come learn new DB2 Connect and JDBC Universal Driver tips and tricks that you need to know.

Read More…

Kim May Named IBM Information Champion Again in 2011

Posted by Frank Fillmore on February 23, 2011 under Baltimore Washington DB2 Users Group, DB2 Connect, International DB2 Users Group (IDUG). Tags: .

Kim May, Vice President of Business Development for The Fillmore Group, has been named an IBM Information Champion for 2011.  The Champion program recognizes contributions to the IBM Information Management software community.  Kim is a long-time member of the Baltimore/Washington DB2 Users Group.  In 2010 Kim launched the DB2 Connect Virtual Users Group in collaboration with IDUG.  In 2011 Kim is hosting a series of free lunch-and-learn sessions to help the community understand the depth and breadth of the IBM Information Management portfolio called “DB2 101”.  Give Kim a shout out when you get the chance.

Virtual Users Group “DB2 Connect: History, Today’s Functionality, and What’s Next”

Posted by Frank Fillmore on December 14, 2010 under DB2 Connect, DB2 Education, DB2 for i, DB2 for VSE&VM, DB2 for z/OS, International DB2 Users Group (IDUG). Tags: , .

Curt Cotner presents DB2 Connect from a technical, historical perspective.  In his presentation Curt explains how DB2 Connect evolved as a technical solution, describes the changes to DB2 Connect and why organizations should consider eliminating the gateway.  Curt looks at what the future holds for DB2 Connect.  Curt covers best practices for moving from three-tier DB2 Connect topology using a gateway to the recommended two-tier architecture so attendees can begin to figure out how to get their organization from here to there.

db2-connect-history-dec-2010

Also, we would like to thank everyone for volunteering.  We are hoping to have three meetings a year and will be posting them through the IDUG website.  A special thanks to Michael McBride for all of this assistance with the website.

Please feel free to invite your friends and colleagues to join the Virtual Users Group!  Contact Blaire Crowley at blaire.crowley@thefillmoregroup.com for details.

DB2 Connect Virtual Users Group Inaugural Meeting on December 14

Posted by Frank Fillmore on November 24, 2010 under DB2 Connect, DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, International DB2 Users Group (IDUG). Tags: , .

“DB2 Connect, History, Today’s Functionality, and What’s Next”

Tuesday, December 14, 2010 from 11:30 a.m. to 1:00 p.m. (US) Eastern Standard Time

IBM Fellow Curt Cotner will present DB2 Connect from a technical, historical perspective.  In his presentation Curt will explain how DB2 Connect evolved as a technical solution, describe the changes to DB2 Connect and why organizations should consider eliminating the gateway.  Curt will finish the presentation with a look at what the future holds for DB2 Connect.  Curt will cover best practices for moving from three-tier DB2 Connect topology using a gateway to the recommended two-tier architecture so attendees can begin to figure out how to get their organization from here to there.

The presentation will be delivered online via GoToWebinar.  Click here to register.

DB2 Connect Virtual Briefing Replay

Posted by Frank Fillmore on August 24, 2010 under DB2 Connect, DB2 Education, DB2 for z/OS.

Thanks to all who attended the Optim Virtual Briefing on DB2 Connect.  If you were not one of the 250 attendees last Thursday, the replay and materials are available here.

For more in-depth training, consider the following IBM authorized training classes.

  • CF602 “DB2 Connect 9 to DB2 for z/OS DRDA Implementation with TCP/IP” December 6, 2010
  • CF632 “DB2 Connect 9 for DB2 for z/OS Problem Determination and Performance” September 20, 2010

IBM/Optim Team Virtual Tech Briefing – DB2 Connect

Posted by Kim May on August 16, 2010 under DB2 Connect, DB2 for i, DB2 for Linux Unix Windows, DB2 for z/OS, Optim, Uncategorized. Tags: , , , , .

Kimberly Madia’s IBM/Optim team is hosting a Virtual Tech Briefing this Thursday:

DB2 Connect for DBAs: A Primer and Look Ahead

Whether you are a DB2 for LUW DBA who would like to access enterprise information or a z/OS DBA wondering how all those Java and .NET programmers are getting to your data, DB2 Connect is the solution.   Frank Fillmore, A DB2 Gold Consultant with an extensive history in training and consulting, will step you through a DB2 Connect primer from end-to-end, including platform architecture, DB2 Connect configuration parameters, and more. Case studies from large scale DB2 Connect health checks will be included.   IBM’s Kevin Foster, who manages the development of the product, will be on hand to discuss licensing, new packaging options such as the DB2 Connect Advanced Edition, which provides pureQuery acceleration in the box, and upcoming changes to the product.

Date: 19 August 2010
Time:  10:00-11:00AM Pacific, 1:00-2:00PM Eastern
Register here: http://ow.ly/2iAlr

Summer Services Special

Posted by Kim May on July 21, 2010 under DB2 Connect, DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, IBM DB2 Services, InfoSphere, Optim, Q-Replication, SQL Tuning. Tags: , , , , , , , , , , , .

As much as I dislike the relentless repetition that’s part of the nature of the world of blogs and twitter and listserves and email blasts, here I go with a shameless pitch for a TFG special services offering I emailed to several DB2 users earlier today.  I am doing this because, at the end of the day, the rate disparity in today’s DB2 services market baffles me.  Are the ridiculously high rates being charged eroding product adoption?  I am afraid so, which is why we are offering a summer services special. 

Read More…

InfoSphere Change Data Capture Luncheon May 6th

Posted by Kim May on April 18, 2010 under Baltimore Washington DB2 Users Group, DB2 Connect, DB2 for i, DB2 for Linux Unix Windows, DB2 for z/OS, InfoSphere, Oracle. Tags: , , , , .

If you will be in Baltimore on May 6th please join us!

Do you know the cost of capturing a change in your production database systems?  Does it cost an extra $100,000 per month to capture that change – and then is the change moved to a data warehouse that’s left many users dissatisfied?  We have a solution, InfoSphere Change Data Capture.

The Fillmore Group is teaming with IBM for a *free* lunch session at Orioles Park at Camden Yards, from 11am to 1pm, where we will explain how InfoSphere Change Data Capture can do an intelligent capture on heterogeneous databases to:  1) create an audit trail detailing who did what and when, 2) replace inefficient staging of changes on your mainframe, 3) eliminate the overhead and instability of ad hoc queries, 4) remove the inefficiency of triggers and message queues, and 5) reduce mainframe costs by $1 million per year – reliably feed downstream ETL, MDM, or SOA applications.

If you are interested in attending, click here for more information.  See you at the Yard!

DB2 Connect Redux

Posted by Frank Fillmore on March 29, 2010 under Authorized Training Partner, DB2 Connect, DB2 Education, DB2 for i, DB2 for VSE&VM, DB2 for z/OS. Tags: , .

I’ve been seeing a lot of an old friend lately: DB2 Connect.  This is the software which enables Distributed Relational Database Architecture (DRDA) Application Requestor (AR) or “client” applications running on Linux, Unix, and Windows platforms to access DB2 “host” databases on System z and System i.  More precisely, DB2 Connect accesses an Application Server (AS) which can be DB2 for z/OS, DB2 Server for VSE&VM, or DB2 for i (Wait, shouldn’t that be DB2 for “me”?)

What we know today as DB2 Connect started out almost 20 years ago as Distributed Database Connection Services (DDCS).  Then it was amazing to access host DB2 data using a spreadsheet.  Of course it took an experienced consultant a few weeks to install and configure DDCS and it’s supporting software which relied on the Systems Network Architecture (SNA) communications protocol.  It was so difficult, The Fillmore Group had a services offering called “Client/Server in 10 Days” where we guaranteed to get DDCS working in your shop in two weeks.  Now you can install and configure DB2 Connect using TCP/IP in about an hour.

So what does DB2 Connect actually do?  At its most basic, DB2 Connect is a protocol converter that changes the character coding on the host (Extended Binary Coded Decimal Interchange Code or EBCDIC) into the equivalent used on Linux, Unix, and Windows platforms (American Standard Code for Information Interchange or ASCII).  It does lots of other things and can be a source of lots of troubleshooting and performance tuning, but EBCDIC to ASCII translation is a core function.

So what’s happening lately?  First, after a few years of no publicly available training in DB2 Connect, The Fillmore Group is holding classes: CF602 “DB2 Connect 9 to DB2 for z/OS DRDA Implementation with TCP/IP” and CF632 “DB2 Connect 9 for DB2 for z/OS Problem Determination and Performance”.  The CF602 beginning June 21 is actually nearing capacity, so if this is something you need, sign up to attend now.  CF632 starts May 17.

As a bonus, I’ve attached a DB2 Connect configuration worksheet.  If you know what it all means and can use it right away, great!  Have at it.  If not, we’ll see you in class.

Second, on the consulting side of the house we’re seeing lots of DB2 Connect activity – especially with DB2 for i.  Having a relational database directly integrated into the i5/OS operating system, System i always has been a bit of a land unto itself.  Now we’re seeing lots of activity integrating System i data into eCommerce and Business Intelligence applications.  If this is what you’re doing, let us know how we can help.