DB2 Special Offer Webcast 7/26

Posted by Kim May on July 25, 2011 under DB2 for Linux Unix Windows, DB2 Migrations. Tags: , .

I am pretty resistant to special offers but I am intrigued about what IBM plans to announce tomorrow.  Since the announcement event is open to everyone – if ou are interested, you are welcome to hear it first!  The webcast details are below:

IBM Webcast: Maximizing Your DB2 Investment & Exclusive DB2 Offer!
Event Date: July 26, 2011
Event Time: 1:00pm – 2:00pm Eastern

Hosted By: IBM’s Kristine Enes
Presented By: Philip Anthony (IBM), Dale Hoyt (IBM), Aakash Bordia (IBM)

Read More…

Primer on Oracle to DB2 Application Migration

Posted by Frank Fillmore on June 1, 2011 under DB2 for Linux Unix Windows, DB2 Migrations, Oracle. Tags: , , .

IBM Senior Technical Staff Member, Serge Rielau, has authored a comprehensive, yet concise, overview of DB2’s support for Oracle application PL/SQL, datatypes, functions, and other APIs: “Run Oracle applications on DB2 9.7 for Linux, UNIX, and Windows“.

IBM reports more than 1,000 customers have made the switch from Oracle to DB2.  Are you paying too much for your database software?

DB2 101 at the Iron Bridge Wine Company

Posted by Kim May on April 8, 2011 under DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, IBM DB2 Services, InfoSphere, Netezza, Optim, Oracle. Tags: , , , , , , , .

The Fillmore Group and IBM are hosting a second session of “DB2 101” – our Information Management portfolio overview lunch and learn, on Friday, April 15th, from 11am – 2pm, at the fabulous Iron Bridge Wine Company in Columbia, Maryland, mid-way between Baltimore and Washington.  We felt local database users would benefit from gaining a better understanding of the IBM data management strategy and developed this informative presentation, which will be presented by DB2 Gold Consultant Frank Fillmore, along with Netezza’s Mickey James.  To join us, register here.

DB2 Advanced Enterprise Server Edition Webcast

Posted by Kim May on March 18, 2011 under DB2 for Linux Unix Windows, DB2 Migrations, Netezza, Q-Replication, Uncategorized. Tags: , , , , , , , , .

Many thanks to Frank Fillmore for delivering the DB2 Advanced Enterprise Server Edition – aka AESE – presentation on Wednesday.  We had over 70 people join us for the presentation and appreciate the positive feedback.   The link to the presentation file is here; if you have any questions on AESE or the presentation content please feel free to contact me at kim.may@thefillmoregroup.com.

One final note:  Frank is tracking down answers to the questions posed in the Q&A at the end of the session.  Look for them here – soon!

Q Replication Packaging Revealed!

Posted by Frank Fillmore on March 9, 2011 under DB2 for Linux Unix Windows, DB2 for z/OS, InfoSphere, Q-Replication. Tags: , .

Led Zeppelin had a concert film, song, and album with the title “The Song Remains the Same”.  Even though it comes in different packaging, Q Replication functionality remains consistent. 

Data interoperability – what IBM calls Information Integration – is a core competency of The Fillmore Group.  We deliver consulting services and IBM authorized training for software products like Information Server (think DataStage), InfoSphere Change Data Capture (ne’e DataMirror), InfoSphere Federation Server, and more.

Right now we’re working a lot with DB2 Homogeneous Replication Feature and it’s sibling InfoSphere Replication Server.  BTW – a moment’s digression – what is the difference between these two?  Both feature what is commonly known as Q Replication: IBM’s high volume, low-latency, assured-delivery data replication solution.  The differences come down to licensing and capabilities.  When you install DB2 Enterprise Server Edition (DB2 ESE), all of the code for the DB2 Homogeneous Replication Feature is there.  To activate it, you must purchase and apply the appropriate license key.  This gives you the ability to create DB2 for LUW to DB2 for LUW replication topologies.  Of course DB2 for z/OS can be both a source and target for Q Replication, but the licensing to include DB2 for z/OS is beyond the scope of this post.  DB2 Advanced Enterprise Server Edition (DB2 AESE)  includes a limited-use license for the DB2 Homogeneous Replication Feature.  To learn more about the feature-rich DB2 AESE bundle, join us for a free webinar on Wednesday, March 16.  By contrast, InfoSphere Replication Server can replicate from and to heterogeneous sources and targets.  At one very large integrated financial services firm, Q Replication is being used to:

  • migrate Oracle databases to DB2 for AIX without taking an outage
  • populate a warm standby subsystem for DB2 for z/OS
  • integrate DB2 for z/OS data into an Oracle application
  • create a DB2 for AIX reporting database with near-real-time DB2 transactional data

Clear?  Good.  If not, drop me a note (frank.fillmore@thefillmoregroup.com) to talk about your specific replication use case.

Chat with the Lab: DB2 and Oracle – An Architectural Comparison

Posted by Frank Fillmore on March 8, 2011 under DB2 Education, DB2 for Linux Unix Windows, DB2 Migrations, Oracle. Tags: , .

Date: Thursday, March 31, 2011 (31.3.2010)
Time: 12:30 AM – 2:00 PM Eastern Time (ET)
Speakers: Sal Vella (IBM), Burt Vialpando (IBM)
Register: http://bit.ly/gxtk9S

Many database professionals and DBAs often ask how DB2 and Oracle compare architecturally, that is, how they are different and similar at their core. They also ask what are the equivalent concepts, names, commands etc. in the other database system. This free webinar will answer those questions by covering the following topics in detail:

– Server architecture comparison (e.g. instances and database model, process vs. thread)
– Memory architecture comparison (e.g. Oracle SGA & PGA vs. DB2 instance, database and application memory)
– Parameters, environment variables and registry variables
– Database storage model comparison (e.g. table space types and layouts, compression approaches)
– Basic database administration comparison (e.g. terminology, create database, start/stop, dictionary vs. system catalog, performance)
– Compatibility mode for running Oracle applications with DB2

This webcast is intended for database professionals:
– familiar with Oracle and looking to learn more about DB2 (for Linux, Unix and Windows),
– familiar with DB2 and looking to learn more about Oracle
– who work in a heterogeneous environment and looking to expand their DBMS knowledge and career prospects.

Join Sal Vella and Burt Vialpando on Thursday Mar 31, 2011, at 12:30 PM Eastern to learn more.
To register and receive instructions for attending this webcast, point your browser to:


If clicking this link does not work copy and paste the following URL to your web browser and follow the Registration link: http://www.ibm.com/db2/labchats

For questions/comments/suggestions: http://www.channeldb2.com/group/db2chatwiththelab

DB2 Advanced Enterprise Server Edition (AESE): How to Get It

Posted by Frank Fillmore on November 19, 2010 under DB2 for Linux Unix Windows, DB2 Migrations. Tags: , .

My colleague, Kim May, spent many hours putting together a presentation on the components and features included in the new DB2 Advanced Enterprise Server Edition (AESE).  Moreover, she has included multiple upgrade scenarios showing how the DB2 components that you currently license will affect upgrade licensing costs for AESE.  If you missed our webcast yesterday, Kim is planning a reprise in the next several weeks.  In the meantime, here’s the presentation materials.  Contact Kim (kim.may@thefillmoregroup.com; 443-956-0288) with questions or take her up on her free, no obligation offer of a AESE software licensing quote.


DB2 Advanced Enterprise Server Edition (AESE) Available October 22

Posted by Frank Fillmore on October 7, 2010 under DB2 for Linux Unix Windows, Q-Replication. Tags: , .

IBM’s flagship relational database for distributed platforms, DB2, has been packaged in Workgroup and Enterprise editions for several past versions.  Joining them at the high end is DB2 Advanced Enterprise Server Edition (AESE).  The big news is that many useful tools and capabilities are bundled together in AESE:

·         DB2 Storage Optimization Feature

·         DB2 Performance Optimization Feature

·         Optim Performance Manager

·         InfoSphere Federation Server (limited use)

·         InfoSphere Replication Server (limited use)

·         Optim Development Studio

·         DB2 Advanced Access Control Feature

The pricing is very aggressive, so if you are using Enterprise Server Edition (ESE) and paying separately for any of these additional features, an upgrade to AESE might be an attractive option.  Click on the link below for a chart of feature/functionality for each DB2 bundle.


Dubuntu (DB2 + Ubuntu) Appliance

Posted by Frank Fillmore on March 7, 2010 under DB2 for Linux Unix Windows, IBM Smart Analytics System, InfoSphere. Tags: , , , , .

I once got in trouble with a woman I was dating because I bought her an “appliance” for Christmas.  It was a combination VCR/DVD player (this was a while ago) and she liked movies.  Go figure.  I’ve also gotten in trouble with my wife for *not* buying an appliance – in this case a new, energy efficient clothes dryer; she pays the electric bills.  So you would think that I would steer clear of appliances.  You would be wrong.

Database “appliances” are integrated packages of software including operating system, database software (e.g. DB2), and other useful features.  Sometimes these appliances are pre-configured and optimized on hardware servers as well.  Some prominent examples are IBM’s Smart Analytics System (ISAS) and Oracle’s Exadata.  ISAS is the follow-on to IBM’s Balanced Configuration Unit (BCU) which clearly needed a new, better name.  ISAS combines InfoSphere Warehouse with IBM server hardware and a back-end storage system that provide a complete out-of-the-box solution.  The systems are “balanced” in terms of configured machine resources (i.e. CPU, memory, SAN) based on projected data volumes so you don’t have to spend weeks trying to figure all of that out.  That job has been done for you.  You can begin achieving ROI shortly after powering on the unit.

Appliances don’t always include hardware, however.  Some flavors of ISAS are VMWare images that can be deployed on existing hardware.  This benefits organizations which have established hardware standards in their enterprises and don’t want to deviate.

Want to get started with an appliance (and not get in trouble with your “significant other”)?  Check out this link on Channel DB2.  Anil Mahadev has put together Dubuntu, an all-in-one VMWare image DB2 appliance built on the open source Linux operating system Ubuntu.  It’s all *free*.  This is not a trial.  Using open source application development tools and DB2 Express-C, Anil has put together quite a cool package.

You can download Dubuntu at http://www.idug.org/anil-dubuntu/dubuntu-appliance.html from the IDUG website.  This is perfect for small – even one-person – development shops that can’t invest in expensive up-front software licensing.  If you are a DB2 for z/OS specialist and want to expand your skills to the distributed platforms, here’s a terrific tool.

With apologies to Cole Porter: “Do do that Dubuntu that you do so well.”

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.