Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Quest Central for DB2? Expand / Collapse
Author
Message
Posted Thursday, May 24, 2007 3:19 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, April 5, 2013 4:27 AM
Points: 95, Visits: 47

I'm looking for a tool to manage several DB2\Linux databases that is similar to Microsoft SQL's Enterprise Manager?

Can you comment on wether Quest Central can do the job? Would it require me to buy a license for each instance?

Thanks...Nali

Post #368837
Posted Friday, May 25, 2007 7:20 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, July 24, 2014 7:34 AM
Points: 417, Visits: 1,146
I have not tried Quest Central, however I do use Embarcadero's DBArtisan.  It works cross platform for DB2, SQL Server, Oracle and Sybase.  I have used it for both Oracle and SQL Server and really like it.  You would have to talk to a representative about pricing though.  I know they have individual workstation licenses and server licenses at various prices.  Their web site is http://www.embarcadero.com/ for more info.
Post #369005
Posted Wednesday, May 30, 2007 4:11 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 25, 2013 7:39 AM
Points: 287, Visits: 208

I have used Quest Central for DB2 and it is one of those very frustrating products that have some good bits mixed in with aspects that are rubbish.  e.g. The Compare tool to compare one schema in say Prod to it's equivalent in Pre-Prod and can prove very useful in detecting variations.  However support for Sequences is virtually zero.

Moreover, having experienced several release of the product over time, and raised numerous bugs with Quest, I have repeatedly found aspects fixed in an earlier version returning to haunt you.  I have also spoken to their lead developers in the states about aspects I would like to see, promises made but not delivered. 

Most recently Quest seem to have ditched the Quest Central direction in favour of Toad for DB2, probably tied to their dispute with CA over the origins of some of the source QC code. 

Having seen Embarcadero's demo, it seemed a much more rounded product and supports things Quest ignored (e.g. Sequences).  If you are going to check out any products, I would personally suggest avoiding Quest.

 

Post #369820
Posted Wednesday, May 30, 2007 6:29 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, April 5, 2013 4:27 AM
Points: 95, Visits: 47
Thanks for the info. I'm checking out DBArtisan right now. From a price point, there is no comparison, Quest charges per CPU. I have a couple of hundred servers to monitor, and DBArtisan charges per user, so its $10K vs. a few hundred thousand K.
Post #369855
Posted Wednesday, May 30, 2007 8:49 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 2, 2013 2:46 PM
Points: 392, Visits: 82

Quest Central for DB2, while it does include database administration, is more for performance monitoring/diagnostics.  If your looking for a tool from Quest that performs database management you should be looking at Toad for DB2.  This product has a customizable look and feel and offers functionality for database administration as well as database development.  You can download a trial from www.quest.com.  Also, Toad for DB2 is licensed per seat rather than per server which might fit your monetary needs more closely.

Please feel free to shoot me a line if you would like any additional information.  I'd also be happy to set you up with a web demo to show the features and functionalities you are looking for.

Jason

Post #370138
Posted Monday, June 4, 2007 9:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 4, 2007 9:33 AM
Points: 1, Visits: 1

Toad for DB2 V3.0 is in Beta right now (we are expecting to GA next month (July). You can check it out here: http://www.toadsoft.com/toaddb2/toaddb2beta.html

It includes numerous enhancements including the ability to compare/migrate/sync DB2 v8 and V9 objects including sequences . Moreover, you can also do some really cool stuff with it like migrating object stats, saving the migration settings for reuse, transforming source schemas/tablespaces to different schemas/tablespaces on the target etc..

 

Post #371056
Posted Thursday, June 21, 2007 11:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 13, 2008 12:03 PM
Points: 2, Visits: 5

Available at No Cost to use and avilable today, there is the CA Database Command Center that supports DB2, SQL Server, and Oracle and all from a web browser. You may want to check it out as well as you cant beat the price

https://www.ca.com/Register/form.aspx?CID=84918

Steve

Post #375687
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse