IBM DB2 Analytics Accelerator (#IDAA) Workshop a Success!

Posted by Frank Fillmore on April 14, 2014 under Data Studio, DB2 Education, DB2 for z/OS, IDAA, Optim, Sidecar. Tags: , .

Last week in Baltimore The Fillmore Group conducted a deep-dive technical workshop on IBM DB2 Analytics Accelerator.  We covered Basic and Advanced hands-on labs with the support of the IBM Poughkeepsie Demo Center.  Saghi Amirsoleymani and Mike Hood, both of IBM, presented on the Tools Ecosystem supporting the Accelerator including:

The presentation I gave outlining the topics covered in the Basic and Advanced lab exercises is here: IDAA Workshop 2014-04  Additional presentations will be posted soon.

Demo videos of the Tools include:

Database Magazine and Articles on Accelerating Analytics Queries

InfoSphere Warehouse “Haunted”Class 9/28

Posted by Kim May on August 27, 2009 under Data Studio, DB2 Education, InfoSphere, MQT's. Tags: , , .

I am trying to find two missing persons:  the two students I need to get our September 28th DW351, InfoSphere Warehouse 9 Components, class to run.  I am offering a ghost tour to anyone brave enough to join us.  See the message below:

It really isn’t haunted, but it IS a bit mysterious.  That is, until you’ve made your way through the maze of the SQL Warehouse Tool, InfoSphere Intelligent Miner, Cubing Services, and their common interface, the Design Studio, and understand they are more than just smoke and mirrors.  Attend IBM Authorized training class DW351, “InfoSphere Warehouse 9 Components” with The Fillmore Group’s Frank Fillmore and start accumulating warehouse knowledge that will make you – supernatural! 

Students attending the September 28th class will be treated to the Mt. Vernon Ghostwalk, by Baltimore Ghost Tours, and dinner at the Owl Bar in Baltimore’s historic Belvedere Hotel. 

Detailed course and registration information is available on the IBM website at:

New Q Replication Dashboard-TFG and IBM Webcast

Posted by Kim May on August 20, 2009 under Data Studio, DB2 Gold Consultants, Q-Replication, TFG Blog. Tags: , , , , .

Just announced and (I think) just released!  Frank will deliver a webcast on the latest version of the Q Replication Dashboard.  He installed it last night at a customer site and is already deciding which new features he likes best.  Stay tuned – I am sure his prep for the webcast will fuel some blog entries.  Here’s the invitation to the webcast:

The Fillmore Group and leading experts from IBM will deliver a 45-minute webcast to introduce the Q Replication Dashboard and improvements included in the new, redesigned Dashboard scheduled for release this month (or maybe yesterday).

The Q Replication Dashboard is the free monitoring tool available from IBM that replaces the Java Q Replication Dashboard and the Data Studio Administrative Console (DSAC) with a thin-client, browser-based interface. The Dashboard provides real-time Q Replication monitoring. In the webcast presenter and DB2 Gold Consultant Frank C. Fillmore, Jr., will introduce and explain how the new redesigned Dashboard’s expanded features and better ability to customize will enhance your organization’s Q Replication monitoring capabilities. Frank will demonstrate and explain the new Dashboard’s:
•?Improved performance for replication environments with large numbers of subscriptions and queues
•?Greater customization and filtering capabilities
•?Ability to access more data
•?Better access to historical data
•?Simplified security
•?Improved visual appeal
•?Smaller (512mb requirement) footprint for both the client and server

Two sessions of the webcast will be delivered on September 15th, one at 9:00am EDT and another at 7:00pm EDT.

To register: E-mail and include your name, company name, telephone number and the session (9:00 am or 7:00 pm) you would like to attend. 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…

Data Studio Administration Console (DSAC) for Q Replication Updates

Posted by Frank Fillmore on July 17, 2009 under Data Studio, Optim, Q-Replication. Tags: , .

If you are using Data Studio Administration Console (DSAC) to monitor a Q Replication environment, there are a few important things you should know.

  1. DSAC v1.2 Fixpack 1 is available for *free* download.  You can access both the base code and the Fixpack at the Blogroll link in the lower right hand corner of this page under “Q Replication Tools”.  There are a couple of installation “gotchas” that you need to know that I covered in and earlier post.
  2. What is old is new again.  The original Q Replication Dashboard was a Java-based heavy client.  That was replaced by the current DSAC implementation: browser-based, thin-client with a lite webserver imbedded.  Q Replication monitoring is now moving away from the “Data Studio” umbrella and will be called Q Replication Dashboard again.  My guess is that the new implementation will retain a lot of the “look and feel” of DSAC, so there’s no risk in starting to use DSAC today for Q Replication monitoring.  Watch the blog for details as they become available.
  3. In a follow-up to Kim’s What’s in a Name post from a while back, IBMer Anjul Bhambhri made an off-hand remark at the June meeting of the Baltimore/Washington DB2 Users Group which identified an important IBM product naming convention distinction.  Products named “Data Studio” are available for *free*; these are typically tools which provide basic functionality (e.g. DSAC).  Products named “Optim” are for-fee products offering more integration and/or robust functionality.  “Optim” is a name that derives from IBM’s acquisition of Princeton Softech.  Most folks associated “Optim” with data archiving.  Now “Optim” will be the brandlet that covers IBM cross-database tooling.  Clear?  I hope so.  At least until the next change.

If you’re not using DSAC for Q Replication real-time monitoring, how come?

Q-Replication Administration Console Webcast

Posted by Kim May on June 26, 2009 under Data Studio, Q-Replication. Tags: , , .

In conjunction with the Data Studio team Frank Fillmore just tentatively set the date for a webcast to review the functionality of the *free* Data Studio Administration Console (DSAC) features to monitor and support Q-Replication, as well as to give a preview of the new features in the upcoming V9.7 release due out late this summer.

The date: July 30th. We will do some marketing and also advertise the webcast by way of IDUG. If you are interested in attending, check back in mid-July when I should have the date and time confirmed.

I can see clearly now…introducing, “Integrated Data Management”

Posted by Kim May on June 8, 2009 under Data Studio, InfoSphere, Optim. Tags: , , , , , .

The IBM team made another announcement and juggled product names again. Oh no! Except…this time it’s all beginning to make sense. The rationale behind the products developed and acquired by IBM is coming into focus and the picture that’s formed defines the IBM Information Management strategy.

Holly Hayes is the Program Director, Optim Solutions, at IBM, and she has a new article on Developerworks that really pulls it all together. The first paragraph is below; for the entire article go to:

From Holly: “With the June 2009 announcements, IBM is consolidating many of its Data Studio offerings under the Optim name. The Optim portfolio will focus on realizing integrated data management with innovative delivery of application-aware solutions for managing data and data-driven applications across the lifecycle, from requirements to retirement. This overview article explains both the vision and reality of Integrated Data Management and how you — whether a data architect, developer or tester, DBA, or data steward — can use IBM solutions today to respond quickly to emerging opportunities, improve quality of service, mitigate risk, and reduce costs.”

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.

Curt Cotner’s Integrated Data Management Presentation

Posted by Kim May on May 12, 2009 under Cobra, Data Studio, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, Information on Demand Conference. Tags: , , , , , , , .

2009 Integrated Data Management

We were honored to have Curt Cotner join us in Baltimore for a customer luncheon in early April. Curt presented on IBM’s 2009 strategy and impressed everyone in the room. Curt generously sent me a copy of the presentation the next day, and I’ve been back and forth with our hosting company trying to figure out how to enable sharing a file of this size. It’s working now, so I want to share it.

It’s not only a big file – there are some huge ideas and concepts. Please review it when you get a chance – I hope you get the same “wow!” we got during the live presentation back in April.

New Performance Expert Article on developerWorks

Posted by Kim May on May 6, 2009 under Data Studio, DB2 for Linux Unix Windows. Tags: , , , .

The Data Studio team suggested a review of a new article on developerWorks, and it’s great!

Performance monitoring and tuning are critical tasks for a database administrator (DBA). DB2® Performance Expert helps DBAs tackle immediate performance problems, as well as avoid problems in the future. This article is the first of two in a series that describes the top 6 things you can do to get the most out of DB2 Performance Expert.

The top 6 tips for a successful DB2 Performance Expert deployment for DB2 for Linux, UNIX, and Windows, Part 1: Modifying settings, setting up alerts, and using System Health data views

When the next article is published I will post the link. Please let me know if you find this helpful.