Baltimore/Washington DB2 Users Group – Chris Eaton!!!!

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

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.