The **Latest** from the Data Studio Team

Posted by Kim May on April 8, 2009 under Data Studio. Tags: , , , , , .

Two new articles and a great demo –

Oops! Restoring your Database with Data Studio Administrator
New capabilities in IBM Data Studio Administrator enable point-in-time recovery
by Sailaja Bandlamoori and Tawanna Harris
As a DBA, it is crucial that you perform regularly scheduled database system backups as part of your backup and recovery strategy. In the event of an application or hardware failure, you can use these backups to restore your database. This article follows a day in the life scenario for a DBA named Erik, who works at a fictitious company. On this particular day, problems arise when Erik discovers that bad application logic has deleted rows from multiple tables of the company’s GOSALES database. However, because Erik used Data Studio Administrator 2.1 to back up the database, he is able to restore the database to its original state.

Migrating from CA ERWIN to InfoSphere Data Architect
by Norma Mullin
If you’ve had experience with CA ERwin Data Modeler and now are starting to learn InfoSphere™ Data Architect, this paper will speed up your model migration process and ease your learning process of the new environment. You will learn the differences between the two design environments, and you’ll also learn a set of best practices for using features of InfoSphere Data Architect that will put you on the fast track of working productively in InfoSphere Data Architect.

And, by the way, if you haven’t seen the InfoSphere Data Architect demo, you really should check it out:

Tutorial: Optimize existing .NET applications using pureQuery

Posted by Kim May on March 30, 2009 under .NET, Data Studio, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS. Tags: , , .

Hot off the press from Kathy Zeidenstein and the Data Studio team!  Improve the performance and security for your existing .NET applications that access DB2 with pureQuery.

IBM® Data Studio pureQuery Runtime 2.1 includes a new feature, called client optimization, that enables database administrators and developers to take advantage of the performance and security benefits of static SQL execution against IBM DB2® databases without having to modify their existing custom-developed or packaged .NET applications. In this tutorial, learn how to enable this capability for an existing .NET application.

Baltimore/Washington DB2 Users Group LUW Meeting – Friday, 3/6

Posted by Kim May on March 3, 2009 under Baltimore Washington DB2 Users Group, Data Studio, DB2 Education, DB2 for Linux Unix Windows, MQT's, SQL Tuning. Tags: .

The second LUW track meeting is scheduled for this Friday, March 6, 2009, at the IBM TEC in McLean, Virginia.  Petrus Chan from the Toronto Lab will be presenting. 

I’ve spent a good portion of the past couple weeks getting individual invitations out to local DB2 for LUW users but if you are out there and I have not personally invited you, please consider yourself welcome – and try to join us.  Details on the presentations are below.   There is no charge for the sessions (they are *free* thanks to Tak Lee and the local IBM team) and pizza will be provided by The Fillmore Group. Read More…

Bryan Smith Needs More User Input on Data Studio – Please Help

Posted by Kim May on March 3, 2009 under Data Studio, DB2 for Linux Unix Windows, DB2 for z/OS. Tags: , , .

We mentioned a few weeks back that Bryan Smith, from the IBM Data Studio team, is working with a group of developers and marketing folks on IBM’s Data Studio go-to-market strategy.  Based on the quality of feedback Bryan received from the user community after his last request, he’s back for more.  If you can spare them time, please help.

Here is what he has posted on this blog:

“I need your help again. Read More…

New TFG Services Offerings – Data Studio Administration Console

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

I just emailed our website designer and asked her to revise the consulting page so that I can add some services offerings to the site. Three of these offerings I have developed while working with IBM’s Ron Reuben, as he is trying to create an ecosystem of services to surround and better enable Data Studio. The first one we’ve put together, based in part on our experience and appreciation of Q-Replication, is for a Data Studio Administrative Console “Quickstart” to install DSAC, set up monitoring for Q-Rep, and mentor onsite staff. This is MY favorite, as DSAC is currently available from IBM for **FREE**. Here goes, text-style. If you want to really experience the full impact of the marketing slick, check it out on the website in color next week!

The Fillmore Group Services for
Data Studio Administration Console Quickstart

• The Data Studio Administration Console (DSAC) is a free download.
• The DSAC provides real-time monitoring for Q-Replication.
• Thin client, browser-based interface replaces the Java Q-Replication dashboard.
• Easy to learn, deploy, and use. Read More…

IBM Authorized Training – Private Classes – Part 1

Posted by Kim May on December 19, 2008 under Authorized Training Partner, Data Studio, DB2 Education, DB2 for Linux Unix Windows, DB2 Gold Consultants, Q-Replication. Tags: , , , , .

The Information Management training team, led by Mike Agostino and Jim Jackson, recently instituted a program to enable Frank Fillmore, as a DB2 Gold Consultant, to obtain IBM authorized course curriculum for private class delivery.  What this means to DB2 customers is that IBM has created an alternate source from which to obtain DB2 training, which should encourage everyone delivering training to sharpen their pencils to keep pricing competitive, and at the same time raise the level of delivery quality by welcoming seasoned speakers and consultants like Frank back into the business of IBM Information Management training.  Listed below are some of the courses available – the complete list is on our website at under the training link.  I will blog on the rest of the list when I have time for the typing!

CE030 DB2 Family Fundamentals, CE120 SQL Workshop, CE130 DB2 SQL Workshop for Experienced Users, CE242 Using Q-Replication, CE820 Using Rational Data Architect, CF180 Relational Database Design, DW145 Data Replication: Basic Usage (SQL Replication), DW154 Data Replication: Advanced Topics (SQL Replication), DW030 Changing Business with Data Insight, DW112 Architecting the Data Warehouse, DW314 Alphablox Essentials with Blox Builder, DW321 Managing Workloads for DB2 LUW and Infosphere Warehouse, DW351 Infosphere Warehouse 9 Components, DW820 Advanced Data Warehousing Workshop: Multi-Dimensional Modeling, DWA51 Infosphere Warehouse 9 – SQL Warehouse Tool and Admin Console, DWB51 Infosphere Warehouse 9 – Cubing Services, DWC51 Infosphere Warehouse 9 – Data Mining and Unstructured Text Analysis, CF242 DB2 9 for LUW Multi-Partition Database Administration, CF492 DB2 9 for LUW Advanced Recovery, CF602 DB2 Connect DRDA Implementation with TCP/IP, CF632 DB2 Connect 9 for z/OS Problem Determination and Performance, CF710 DB2 9 Stored Procedures Programming Workshop, CG100 Using xQuery to Query XML Data with DB2, CG130 Query and Manage XML Data with DB2 9, CG242, DB2 for LUW Multi-Partition Environment for Single Partition DBAs…and more coming soon!

Data Studio Enablement Ideas

Posted by Kim May on December 8, 2008 under Data Studio, DB2 Education, DB2 Gold Consultants, Q-Replication. Tags: , , , , , , , , .

Ron Reuben, IBM’s Data Studio “Enabling Architect”, Frank and I had a discussion a couple weeks ago about developing some specific offerings around Data Studio that will introduce the product – and provide immediate benefit – to existing DB2 customers.  We came up with three offerings and sent them to Ron; this Friday we are scheduled to circle back with him and discuss how these were welcomed by his team.  These ideas reflect, naturally, where we see Data Studio’s capabilities providing the most immediate impact to customers we’ve worked with.  These are ideas – not limitations!

1.  Data Studio Administration Console (DSAC) is a free download with many capabilities, and can be used extensively for Q-Replication real-time monitoring.  We suggested contacting all current Q-Replication customers and offering assistance with the implementation of DSAC.  This should take only a few days and will introduce Q-Rep customers to the Data Studio product family and get them familiar with the look-and-feel of the components.  For more information on DSAC, check out:

2.  Data Studio Developer (DSD) and pureQuery, which, by the way, was recently enhanced with v2.1 last week.  Read More…

Using Data Studio Administration Console for Q Replication

Posted by Frank Fillmore on October 15, 2008 under Data Studio, Q-Replication. Tags: , , , .

I mentioned in earlier posts that the Replication Center, a Java fat-client GUI used to build and administer an SQL or Q Replication environment, is being deprecated in favor of the Data Studio suite of thin-client, browser-based interfaces.  There’s also a link on an earlier post to the Q Replication Tools.  One of these tools, the Data Studio Administration Console (DSAC), is taking the place of the original Java Q Replication Dashboard.   DSAC is free and not to be confused with its for-fee sibling Data Studio Administrator.

There are a few anomalies I’ve encountered while installing and using DSAC in a DB2 for z/OS unidirectional Q Replication environment.

  1. You need local administrator authority on the supported Windows operating system in order to install DSAC.  This is true of DB2 9 as well.  The difference is DB2 9 will accept a domain logon as a local administrator (e.g. acmedomain\myuserid); DSAC will *not* install when logged into Windows with a domain userid even if it is part of the local administrators group will full privileges.  The workaround is to use the domain logon to create a new userid (e.g. “install”) on the Windows server with adminsitrator privileges, logon locally to the server with that userid, and install DSAC.
  2. There are a number of DB2 for z/OS prerequisites in order to use the DSAC.  If you *only* want the Q Replication monitor feature, it won’t be necessary to install DB2 Accessories Suite v1.3.
  3. You need to install the security certificates when using DSAC for the first time.  You will be prompted by Windows.  If you don’t install the certificate, the next time you attempt to logon with the same userid, DSAC will remain at the logon page with no error or other information.  Intertestingly, you can logon onto DSAC using a domain userid (acmedomain\myuserid).

Now that you’ve gotten DSAC installed, the next post will detail how to configure and use DSAC as a Q Replication real-time monitoring tool.

Thursday’s Q-Replication Challenges

Posted by Frank Fillmore on October 2, 2008 under Data Studio, Q-Replication. Tags: , , , .

Hat’s off to Kim for getting our blog off the ground. From the initial request from IBM, to reading “Blogging for Dummies” (yes, there really is such a book), to the artwork, format, and technical underpinnings, I’m just along for the ride.

Today’s entry comes after a long day of trying to create a DB2 for z/OS to DB2 for z/OS Q Replication environment at a very large financial institution (yes, there still really is such a thing). If you’re not familiar with Q Replication, it’s IBM’s “low-latency” – that means very little lag between when a transaction is committed on the source system and when it appears on the target – means of getting data from one database to another. This particular project is to provide high-availability, but other customers use Q Replication to populate near-real-time data warehouses. Read More…