Baltimore/Washington DB2 Users Group December Meeting

Posted by Kim May on November 20, 2009 under Baltimore Washington DB2 Users Group, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, InfoSphere, Optim, Uncategorized. Tags: , , , , , .

I was finally able to confirm all the speakers for the LUW track at the December meeting and – wow! – here’s the lineup summary:  Curt Cotner and Paul Westfall from IBM, and the BWDB2UG board’s own Steve Rosenberger from FEPOC doing a user case study on their archiving implementation.  If you are in the area on Wednesday, December 9th, PLEASE join us – it should be great…the z/OS track includes Rick Weaver from BMC and Roger Miller.  Great presenters and great networking.  Hope to see you!  The full agenda is included after the jump and all the registration and PayPal access is through our (new) website at:

Read More…

Learn How to Become an IBM Information Champion

Posted by Frank Fillmore on October 28, 2009 under Uncategorized.

My colleague, Kim May, will be leading a birds-of-a-feather (BOF) session at IBM’s Information On Demand Conference today – “Becoming an Information Champion for Dummies”.  The particulars are:

BOF-1631A; Wednesday, October 28, 6:00 p.m.; Tradewinds F

Hope to see you there.

IOD is Here!

Posted by Kim May on October 23, 2009 under Baltimore Washington DB2 Users Group, DB2 Education, Information on Demand Conference, Uncategorized. Tags: , , , , , .

I am ready to leave for IOD and had some thoughts on this year’s conference based on what I’ve heard (unconfirmed, ok?)  It’s sad to hear from so many customers that they cannot attend.  IOD and IDUG offer DB2 users the broadest perspective on what’s happening in the world of OUR technology, and it seems the many incentives of attending – great training and lots of discussion about what new features and functionality are being planned, or have already been added (but no one knows about).  One vendor I spoke to estimated IOD attendance will be 80% vendors and IBM’ers, and 20% customers.  Bummer!

I think it’s important that every DB2 user get a sense of the strategy to merge all the acquired products into a comprehensive toolkit.  For those of you who won’t be at the conference, here are some suggestions: Read More…

Kim’s IOD Birds of a Feather Session Is ON

Posted by Kim May on August 18, 2009 under Information on Demand Conference, Uncategorized. Tags: , , .

I am excited to report that my IOD Birds of a Feather session on becoming an Information Champion was selected and will be held on Wednesday, October 28th, at 6pm at the IOD Conference.  Given that I am probably the least technical Information Champion I thought that if I could do it, so can anyone, and I thought it would be helpful to discuss the process with other future Champions.  If you are coming to IOD, I hope you will attend. 

IBM’s Amit Patel, who is serving as the communications focal point for the Information Champions, has offered to help, and I have asked another *technical* Information Champion to help as well.  When he accepts (I hope!) we will have an all-star cast ready (along with me) to assist our colleagues.  The session specifics are:

Becoming an Information Champion for Dummies  
   IBM Information Champion program recognizes individuals who have made exceptional contributions to the Data Management community. Sounds kind of daunting, doesn’t it? Well, it shouldn’t if you have been working with IBM Information Management products and stay involved with the community. Read More…

Baltimore/Washington DB2 Users Group – Chris Eaton!!!!

Posted by Kim May on August 5, 2009 under Baltimore Washington DB2 Users Group, Data Studio, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, Uncategorized. Tags: , , , , , .

I can finally announce it – it’s finalized – Chris Eaton will be here September 9th for the Baltimore/Washington DB2 Users Group meeting.  For me, this is a big, big deal.  The turnout for the June meeting was disappointing and the board agrees that the LUW and z/OS track folks really need to be meeting together to encourage networking and all the social aspects of the users group.  So we are doing both tracks together September 9th in Columbia, with the hotel offering us an extra room and the attendees all getting a sit-down lunch – together, in one dining room. 

The LUW agenda is below.  Joining Chris presenting are *two* DB2 Gold Consultants – Frank Fillmore (on DB2 Connect) and Dave Beulke (on Java tuning and Data Studio).  Registration and the z/OS agenda are on the website at  If you are in town, please join us – this is like getting best of IOD in one day!

Read More…

Training Excitement??

Posted by Kim May on July 29, 2009 under Uncategorized.

The dog days of summer are upon us and seem even more dreadfully slow than usual given the impact of the crummy economy. It’s good to see the stock market back up over 9,000 but the rumbles of pent-up demand haven’t started the phones at The Fillmore Group ringing. It’s OK; we’re patient, and I am happy to have some really positive news to report on the DB2 training front.

First, based on some reorganization within the Information Management training group, a legacy FileNet training sales guru has been moved into the lead role for North American Information Management sales. Czar Barraza is bringing welcome, fresh energy to the sales team, and helping us raise awareness of the value that niche, skilled partners like The Fillmore Group bring to the classroom. I look forward to sharing some news about some new courses we will be offering soon, along with some other training offerings Czar and his team are developing.

The second item is that we have gathered enough students to deliver a second (!) DB2 Connect class this year…Frank will deliver the DB2 Connect Performance and Troubleshooting course, CF632, starting August 10th. We marketed the class with an offer of a Chesapeake Bay summer seafood dinner (crabs, Chincoteague oysters, etc. – yum) and got a great response. This course hasn’t run in almost three years, so in spite of the economy, people continue to learn more about DB2. And…yes, there are still seats available (Register) so if you are craving crabs and beer – please join us!

Data Architect Training (and Kim whining)

Posted by Kim May on July 13, 2009 under Uncategorized.

The Fillmore Group is an IBM delivery partner for Rational Data Architect – now renamed InfoSphere Data Architect. As the foundation for any new database or data warehouse, I expected the two-day Data Architect class to be fairly popular…but we have NEVER had sufficient enrollment to run it in an open enrollment session. Oh, and to be clear, by sufficient enrollment, I mean a whopping four students. It’s on the IBM schedule once a quarter and I promote it with outbound emails and DB2-L postings and still, nothing…

My guess is that either no one is adopting InfoSphere Data Architect, or that new users are finding alternate ways to get the training they need. Most folks I’ve spoken to that are being tasked with learning IDA know Erwin…is there a class somewhere I’ve overlooked? Hmmm…or perhaps the online lessons put together by IBM’s Wei Liu (which ARE excellent) are enough?

Any feedback would be most appreciated! Thanks!

Baltimore/Washington DB2 Users Group Meeting

Posted by Kim May on June 4, 2009 under Baltimore Washington DB2 Users Group, Data Studio, Uncategorized. Tags: , , , , , , , .

The next scheduled Baltimore/Washington DB2 for LUW Track meeting is scheduled for Friday, June 19th at the IBM Technical Exploration Center in McLean, Virginia. Coming in from IBM’s Silicon Valley Lab to present on Data Studio are George Lapis and Anjul Bhambhri. If you will be in town, please join us. The meeting will run from 10am – 2pm; please email to register.

Session 1: Integrated Data Management
This presentation will cover each of the components of Data Studio and how each fits into IBM’s data lifecycle management vision. The presentation includes an overview of the functionality included in Data Studio to support Web Services, Stored Procedures, InfoSphere Data Architect, Data Studio Administrator, Performance Expert, end-to-end monitoring, pureQuery for new and existing applications, and administration capabilities, as well as introduces some new features in the upcoming 2.2 Data Studio release.

Session 2: A Demo of the Data Studio Portfolio
This demo will cover all areas of Data Studio Portfolio which are applicable to DB2 on LUW. The presenter will use Infosphere Data Architect to reverse engineer a database, create logical and physical models, demonstrate SQL Editor and Stored Procedure debugging, will create and deploy a Web Service, create Java Beans from Data Objects, and explore DBA functionality. Attendees will be shown how they can monitor performance with Performance Expert and how the Extended Insight feature helps with end-to-end problem determination.

Presenting will be George Lapis, a technical manager at IBM’s Silicon Valley Lab. He has worked in database software for more than 30 years. For the past several years George led the compiler development team at IBM’s Silicon Valley Lab, working on SQL, XML, and XQuery for DB2, as his primary expertise is in compiler technology and implementation. Currently he is working as an architect with the Data Studio enablement team. George was a member of the R* and Starburst research projects at IBM’s Almaden Research Center.

Co-presenting with George is Anjul Bhambhri, Director of Development for Database Tools at IBM. Anjul is a 20-year veteran of the database industry. Anjul spearheaded the development of XML capabilities in IBM’s database offerings. Prior to her role at IBM, she held various engineering and management positions at Sybase and Informix. Anjul holds a degree in Electrical Engineering.

Forensic data analysis and extraction

Posted by Frank Fillmore on February 19, 2009 under Uncategorized. Tags: , , , , , .

I usually blog about what I learned in the past week that I had hoped to find someplace in a manual: for example, how to perform a specific technical task like changing a hostname on a DB2 server.  This post is a little different for me.

In the past couple of months we have been approached by three different customers – two of which are quite large – all with the same problem: we have data that we can’t access.  The three specific challenges were:

  1. An independant consultant had a DB2 Universal Database version 5 backup file.  He needed to review the data, but didn’t have the DB2 version 5 code (which hasn’t been supported or available for about a decade) required to restore the backup.
  2. A large financial services firm had a legacy CommonStore Content Manager e-mail respository which hadn’t worked for a while.  The firm had gone forward with different e-mail server and archiving technology, but for legal and regulatory reasons needed to occasionally access older e-mail on the non-functioning server.
  3. A large hospitality industry conglomerate de-commissioned a DB2 for OS/390 server.  The customer requested that the DB2 table data be retained (again, for legal and regulatory reasons), so the vendor gave them a bunch of 3490 tape cartridges containing DB2 Image Copy files.  Eventually the customer needed to actually look at the data, but didn’t have a 3490 cartridge reader.  Or DB2 for OS/390.  Or a mainframe computer.

The good news is that we’ve addressed two of the challenges and are close to completing the third.  The common thread is media, format, and software evolution and obsolesence.  Since The Fillmore Group has been working with IBM Information Management software products for over 22 years we have old software code, access to DB2 on a variety of server platforms and at various software versions, and experience with how all of this stuff actually worked way back when President Obama was still at Harvard.

This is a problem to which anyone (like me) who currently has music stored on casette tapes, vinyl albums, CDs, and an iPod can relate.  And it’s only going to get worse.  For thousands of years of civilization, the common API for storing and transmitting information was clay tablets and then papyrus.  With the exponential growth of the volume of data, the variety of storage media, and constant advance of software technology combined with the growing duration and complexity of records retention requirements, lot’s of enterprises are going to encounter a problem like the examples I’ve listed above.

There’s no simple solution.  It would be prohibitively expensive to routinely migrate *all* of an enterprise’s data assets to the latest version of any particular data repository (or format, or media).  So we’ll have to address the opportunities manually, one by one.

I’m interested if anyone else has had to solve a similar “forensic” data recovery or extraction puzzle.

Data Studio Team Request’s Input: Java Data Tools on z/OS

Posted by Kim May on February 5, 2009 under Uncategorized.

Bryan Smith of the Data Studio Team asked us to reach out to blog readers to gather feedback.  See his note below:

“We are investigating implementing some server-side functions in our data tools that would run in a Java runtime on z/OS, and I would appreciate getting your feedback to help us with this planning work.

Do you have the “IBM SDK for z/OS Java 2″ installed on all of your z/OS systems where you would be running your IBM DB2 tools?  If you’re a DBA, you may need to ask your system programmer or, since you need this for Java stored procedures, if you know you have Java stored procedures, you know you have it. If you’re not sure if you have any Java stored procedures, you can run this query:

If yes, what level(s) of the SDK do you have installed?
Do you have zAAPs on the LPARs you would run the tools on?
If no (that is, you don’t have the SDK installed), do you foresee any problems installing that as a prereq for a DB2 for z/OS tool product?
Any comments about our using Java on z/OS?

You can send your feedback directly to me at bfsmith at
Thanks a lot!”