If you are in the Baltimore/Washington area I want to make you are aware of two upcoming DB2 events – the September Baltimore/Washington DB2 Users Group meeting with a special LUW track on September 15th, and a hands-on pureQuery Proof of Technology The Fillmore Group is hosting in our Towson headquarters the following day, September 16th. 

IBM Silicon Valley Lab’s Vijay Bommireddipalli is presenting at the users group meeting the 15th on .NET and Java tuning, then leading the pureQuery PoT the following day.  Read More…

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

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…

While the IBM Optim teams are excited to see customers adopting InfoSphere Data Architect, everyone recognizes the journey from CA ERwin to IDA can be frustrating.   The Optim team has been working to develop more resource materials for ERwin users and recently emailed a new Tips & Tricks guide developed by Joe Cullen.  If you find this valuable please let us know, and we will let you know when the new materials are released.  Thanks to Joe Cullen for offering to share this with the community!

IDA Tips&Tricks by Joe Cullen

The developerworks team has announced a free technical webcast next week on pureQuery, based on feedback from the z community.  Like other developerworks webcasts it will be available for replay - as is the recommended prerequisite, pureQuery Part 1.

pureQuery Deep Dive Part 3:  Client Optimization Administration Enhancements for DBA’s

June 24th, at 1pm Eastern, 10am Pacific

Our dynamic duo of client optimization experts is back again!  Patrick Titzler and Chris Farrar, who some of you may remember from pureQuery Deep Dive Part 1, will discuss the enhancements released in Fix Pack 3 in Optim Development Studio and pureQuery Runtime that make the maintenance, security, and management of the client optimization processes better for DBA’s.  These enhancements are driven by real customer experiences and are centered around a relational repository that enhances security, fosters collaboration and streamlines the process of administering a pureQuery-enabled application.  Tooling support for these capabilities in Optim Development Studio will be demonstrated. 

Register today and don’t miss out on your opportunity to hear from the experts!

IBM has moved DB2 Connect support into the Optim group, as it is in some ways the original Optim solution.  Kathy Zeidenstein, who manages community outreach efforts for the Optim team (a weekly e-newsletter, content on the developerworks site, Twitter, etc.) is coordinating a DB2 Connect Virtual Briefing scheduled for August 19th.  The primary purpose of the presentation is to introduce new features in the advanced edition, however, as DB2 Connect can be used in so many ways, and is so often under-utilized, she’s invited Frank to devote some of the time allocated to delivering an overview of what DB2 Connect can do.  More information is on the way…for the moment we have the date and time reserved (mark your calendars - August 19th at 1pm Eastern), and a tentative agenda:

DB2 Connect for DBAs:  A Primer and a Look to the Future

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. Kevin Foster, who manages the development of the product will be on hand to discuss packaging including licensing, new packaging options such as the DB2 Connect Advanced Edition, which provides pureQuery acceleration in the box, and upcoming changes to the product.
What you will learn:
• Why you need DB2 Connect
• How DB2 Connect is packaged and licensed
• Platform architecture
• Configuration and tuning options

As soon as I have registration information I will post it.

While there are many indications the “Great Recession” is over, the budget lag and fear of one last dip seems to be constraining IT project funding - EXCEPT - of all places, training.  While this seems perfectly logical (when there are fewer hands to do the work, making sure those hands are skilled is critical), historically, training budgets are the first to be cut when there’s a downturn.  Maybe organizations are wising up this time around…here at The Fillmore Group we are receiving more training requests than anytime in the past five years.  Read More…

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!

The countdown to the first day of Spring is below 20!  Spring can’t come soon enough for me, as here in Baltimore we’ve had over 80 inches of snow - our average is 18.  In preparation for Spring I am coordinating events with the local IBM teams to introduce customers to two great technologies we hope everyone will consider implementing in 2010:  InfoSphere Change Data Capture (CDC) and Optim Data Growth Solutions. 

Both events are planned for Baltimore’s beautiful Camden Yards, home of the Baltimore Orioles.  The tentative date for the CDC event is Thursday, May 6th, with a PoT scheduled two weeks later on May 20th.  I am working on getting the Optim dates on the calendar.  If you will be in the Baltimore/Washington area please try to join us - both topics should be of value to organizations looking for ways to better control their data.  CDC’s niche is in quickly moving data to where it’s most effective, while Optim Data Growth Solutions can help any organization with a packrat in the IT Department.  You know who you are.

Hope to see you there!

I am happy to announce the return of distance learning to The Fillmore Group.  Our team developed and implemented a proprietary distance learning tool, built using a combination of WebSphere and DB2, with the free RealPlayer plug-in providing the ability to deliver streaming instructor audio and video, after the events of 9/11 made traveling for DB2 training a challenge.  Over the years we perfected the distance learning tool’s use and used it to deliver training to hundreds of people around the world - who would otherwise not have been able to attend classes.

A couple years ago IBM’s Information Management training group began evaluating distance learning technologies and limiting their use as they have been trying to find a methodology they can use consistently.   But progress hasn’t been as fast as anyone hoped, so the training team has given us the approval to again offer the public classes we deliver for IBM via distance learning.  Starting with the three classes below students can enroll in the IBM classes, use the same curriculum and lab exercise portal as the students in class, and “see and hear” the instructor lecture on the materials.  If you don’t have a travel budget, you can still join us for class!

Coming up soon are the following courses:

CE821, Using InfoSphere Data Architect, starting March 1

CF602, DB2 Connect for z/OS with DRDA, starting March 8

DW352, InfoSphere Warehouse Components, starting March 15

For course outlines and registration information go to www.ibm.com/training