Quest Software (http://www.quest.com/) has some freeware utilities and versions of their commercial software:
Quest Central for DB2 (http://www.quest.com/quest_central/db2/freeware/)
SpotlightŪ on WebSphere (http://www.quest.com/spotlight_websphere/)
Quest Software (http://www.quest.com/) has some freeware utilities and versions of their commercial software:
Quest Central for DB2 (http://www.quest.com/quest_central/db2/freeware/)
SpotlightŪ on WebSphere (http://www.quest.com/spotlight_websphere/)
Is Quest's DB2 tool any better than TOAD (which, IMHO, has one of the worst UI of any RDBMS tool I've ever used...) - or, is it basically a TOAD port for DB2? Just curious...
Just curious, but why even use TOAD or Quest's DB2 tool over IBM's Administration interface?
The DB2 Book Suggestions (http://forums.devshed.com/t149008/s.html) thread also contains valuable links to books, various informational sites, etc.
Just curious, but why even use TOAD or Quest's DB2 tool over IBM's Administration interface?
Well, I have used Platinum, BMC, and Quest as an interface to the DB. All were superior to what is now DB2's control center, simply easier to use, period. Quest is our latest tool, and seems very satisfactory (well it lacks some things re:
getting to functions and stored procedures...) Quest does seem 10 times faster than the DB2 admin tool - perhaps it is because the DB2 tool is Java/JDBC - based? Many times it has caused a reboot - memory leakage?
For just running a bunch of queries against the database
on the fly - the free version of WinSQL is my tool of choice.
Very light footprint and quick.
fv
Don't get me wrong, I'm not downing any custom tool out there. I personally have one that I built on my own to interact with my database, but then my reasoning was because I deal with more than just DB2 and this application allows me to interact with DB2, MSSQL, and MySQL at the same time.
I will agree that it isn't as fast as a C/C++ or other compiled appliction because it is done in java. Though, I will have to say that you can access store procedures and functions via the control center.
The control center has been quite usefull for building/debugging PSQL stored procs - the source-level deugger is a very valuable tool. With version 8 (UDB/NT)
it has changed totally - now called the Development Center with a totally different interface that I have not explored much. Also it seems integrated into Visual Studio.NET. Next release (code-named Stinger) we will be able to write stored procs in VB.NET...interesting!
fv
The version 7.2 also has a plugin for VS6. I have it installed, but I have not used it though.
I do recall reading somewhere that you could build what they were calling OLE stored procs with VB6, but info was so scarce that I did not pursue. There is a good book on procedural SQL langage for DB2 here: http://www.phptr.com/
just search for DB2 and you will find it.
Synaptris has released a free reporting software for DB2 Express C users, visit www. synaptris. com/go/expressc for more details and for downloading the software.
I prefer DB2 Maestro, the perfect substitute for TOAD and in some ways also much better product (much cheaper, suberb design and interface, and the support is fast and easy.). I have just pumped an MS SQL database into a DB2 database. All the data including the indexes and foreign keys with just a few clicks. :tntworth:
hello,
i wanna create object-oriented database with db2 , now i need quick document about working with db2 with sql3 language . can anybody guide me ? :o