InfoSphere Optim Query Capture and Replay – What’s the value?

Posted by Frank Fillmore on August 8, 2012 under DB2 for Linux Unix Windows, DB2 for z/OS, InfoSphere, Optim, Oracle. Tags: , .

Database recovery logs have been around for a long time.  They support rolling back transactions that abend – providing a logical unit of work (LUW).  The also provide roll-forward recovery so that if a database crashes, a full backup restored can be supplemented by all of the transactions, in chronological sequence, that have occured since the last backup was taken.

For many years now, clever engineers have been using this record of transactions for other purposes.  The most prominent is changed data capture: the technique of reading the database recovery log and replaying the transactions on another server to, say, feed a data warehouse or load-balance between two transaction servers.

IBM has packaged its Guardium technology to provide a new way to capture in-flight SQL statements: InfoSphere Optim Query Capture and Replay (IOQCR).  Not the most lyrical of names, but the idea is sound.  Rather than exploit the database recovery log, IOQCR imbeds a Guardium S-TAP in a database server to gather the SQL as it occurs.  This SQL can then be replayed in another environment.  The use case is to take SQL running in a production system and rerun it against Performance, QA, or Test/Dev database servers.

In May I participated in the IOQCR beta and installed it in a small DB2 9 for Windows server.  The purpose was to evaluate basic functionality and usability.  The IBM development team graciously assisted me with the installation and configuration.  It took a few tries – remember, this was an early beta – but I was able to successfully use all of the features.  SQL statements executing on a database server were captured and replayed flawlessly on another.

Rather than drive transaction load through scripting or third-party products, you can use IOQCR to validate database configuration changes or even the viability of running an SQL workload developed for one database server (we’re looking at you, Oracle) on a different vendor platform entirely.  This is a nifty way to test DB2 9 support of Oracle APIs using your own production PL/SQL code- especially dynamic SQL generated on the fly or by an IDE.  DB2, Informix, Netezza, Oracle, Teradata, SQL Server, Sybase, and MySQL are all supported in v1.1 announced on July 10th.

There’s a demonstration on developerWorks.  The Announcement Letter is also useful.

IBM Information Management Software Portfolio Overview

Posted by Frank Fillmore on April 5, 2012 under DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, DB2 Migrations, IBM Smart Analytics System, Informix, InfoSphere, Netezza, Optim, Q-Replication. Tags: , , , .

The recording of April 5, 2012 webinar “IBM 2012 Information Management Product Strategy and Portfolio Overview” is located here.

The presentation materials: DB2 101 – IBM Information Management Software Portfolio Overview

DB2 Advanced Enterprise Server Edition (AESE) Webinar – Why You Should Consider It

Posted by Kim May on March 26, 2012 under Authorized Training Partner, DB2 for Linux Unix Windows, DB2 Gold Consultants, Frank Fillmore, IBM Champion, Optim. Tags: , , , , , , , , .

IBM introduced the DB2 Advanced Enterprise Server Edtion (AESE) in late 2010, bundling Optim tools, compression and replication for high availability and disaster recovery in with the features in DB2 Enterprise Server Edition.  Current DB2 customers are offered several upgrade options, making AESE an affordable, comprehensive database solution and an alternative to going a la carte.  

In this presentation DB2 Gold Consultant and IBM Champion Frank C. Fillmore, Jr., will explain what each of the features included in the AESE bundle is and what functionality they deliver.  Using customer examples, Frank will analyze the benefits of moving to AESE for each organization and how they evaluated the options and reached a decision.  Finally Frank will explain how to determine the upgrade path for your organization and what you can do immediately to get an accurate estimate of the cost and best time to move to AESE.    For details on the presentation click, “Read More”. 

April 5th, 12:00pm – 1:00pm EDT.    Register here.

Read More…

DB2 101 Webinar – IBM Information Management Portfolio Review

Posted by Kim May on March 26, 2012 under Authorized Training Partner, DB2 Education, DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, DB2 Gold Consultants, DB2 Migrations, Frank Fillmore, IBM Champion, Netezza, Optim. Tags: , , , , , , , , .

Frank delivered a terrific summary of the products in the Information Management portfolio at a lunch event at Baltimore’s Cinghiale restaurant earlier this month.  Unfortunately, we can’t offer everyone lunch (sorry!) but we will offer a repeat presentation via webinar on April 5th.  The invitation and registration information are below and the complete session abstract and Frank’s bio can be accessed by clicking ” Read More”.  Please share this event with anyone who may be interested in learning more about what IBM has to offer – it’s packed with great information.

Thursday, April 5, 2012, 3:00pm – 4:00pm EDT    Register here.  Read More…

IBM Data Strategy Luncheon

Posted by Kim May on February 13, 2012 under Baltimore Washington DB2 Users Group, DB2 Connect, DB2 Education, DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, Frank Fillmore, IBM Champion, Netezza, Optim, Oracle, Q-Replication. Tags: , , , , , , , , .

In 2011, Information Management was IBM’s largest software product family, based on worldwide sales.  What does IBM have that you should know about?  Join us in the beautiful Patrizio dining room at Baltimore’s award winning Cinghiale Italian restaurant on March 8th to find out.

DB2 Gold Consultant and IBM Champion Frank Fillmore will deliver a presentation on IBM’s 2012 Information Management product portfolio, including background on IBM’s recent acquisitions and information integration and data governance strategies.  Learn how IBM has accumulated and integrated data solutions to position themselves as the thought leader in information management.

Whether you already use IBM data products or are interested in finding out what IBM has to offer, the presentation will provide a dose of nutritious food for thought.

To register, click here.   We will send you a confirmation with directions to Cinghiale.  Valet parking will be provided.  We look forward to seeing you there!

Nadir Scores Netezza Certification

Posted by Kim May on November 18, 2011 under DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Migrations, DB2 Stars, IBM Champion, IBM DB2 Services, International DB2 Users Group (IDUG), Netezza, Optim. Tags: , , , , , , .

IBM Information Champion Nadir Doctor successfully passed the IBM Netezza technical certification exam on his first try, without attending the bootcamp or any formal training, one handed.  OK, maybe not one handed.

Congratulations Nadir.  As one of the first IBM Business Partners to become a Netezza reseller, and one of the first to close a Netezza sale, The Fillmore Group is excited to have a team of consultants willing to independently prepare to support Netezza implementations.  Nadir is a fine example of our consulting team’s resources.  He has over ten years of DB2 database/data warehouse and tools experience including InfoSphere Federation Server and Optim Performance Manager and Query Tuner.  If your organization is in need of consulting assistance, please contact The Fillmore Group – we would be proud to introduce Nadir.

Washington Area DB2 Users Group, June 15th

Posted by Kim May on June 7, 2011 under Baltimore Washington DB2 Users Group, DB2 Education, DB2 for Linux Unix Windows, DB2 Migrations, InfoSphere, International DB2 Users Group (IDUG), Optim, Uncategorized. Tags: , , , , , .

The Mid-Atlantic IBM Information Management technical support team has announced the date and location of the first Washington Area DB2 Users Group.  This group is being coordinated by IBM’s Warren Heising and Prem Rangwani to provide education and networking to local Information Management users.  Please contact Warren Heising at IBM if you would like to attend (heising@us.ibm.com).  Details below.

Read More…

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 101 Sessions Announced

Posted by Kim May on February 1, 2011 under Baltimore Washington DB2 Users Group, DB2 Education, DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, DB2 Migrations, IBM DB2 Services, Optim, Oracle, Q-Replication. Tags: , , , , , .

The Fillmore Group will be hosting three sessions of what we are calling, “DB2 101” – sessions that provide an executive overview of the IBM Information Management product portfolio, one each month, in February, March and April.  We have selected three restaurants close to our Baltimore headquarters – 2 in Baltimore and 1 in Columbia, Maryland (about halfway between Baltimore and Washington, DC).  The purpose of each session is to bring attendees up to date on IBM’s Information Management product portfolio (an expanding target), and strategy. Read More…

Buying DB2 Advanced Enterprise Server Edition

Posted by Kim May on December 28, 2010 under DB2 for Linux Unix Windows, DB2 Migrations, Optim, Q-Replication. Tags: , , , , .

The Fillmore Group had the pleasure of working with the IBM New York Metro team on a DB2 Advanced Enterprise Server Edition upgrade and purchase for an existing DB2 ESE customer and I am working on the IBM “Winwire” document that gets circulated internally at IBM about our successful teaming.  The challenge for me is this:  how do I make it sound difficult?  Buying DB2 AESE made perfect sense for the customer from a strategic/technical perspective, and the IBM pricing was amazing.  Read More…