New Q Replication Dashboard-TFG and IBM Webcast

Posted by Frank Fillmore 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…

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?

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.