We use Embarcadero DBArtisan in our shop. There are other tools available from Quest, CA and BMC (at least).
They all have a common failing : to modify an object (e.g. add a column to a table which can't be accomplished with an ALTER) they all (AFAIK) rename the existing table, create a new table with the new structure and do a "INSERT INTO new SELECT cols FROM old". On anything other than a small table this is "death by logging". I've tried to explain to a number of vendors that what we need is the well-known (at least to mainframe folks) unload, drop/recreate, reload mechanism employed by RC/Migrator and (mainframe) Change Manager. But I've had no success. It's obvious that these folks have never had to work with more that a handful of records in a table !!! HTH Phil On Wed, 2003-01-15 at 13:59, [EMAIL PROTECTED] wrote: > What tools are available to use on DB2 UDB on AIX & Sun Platform to do > similar tasks as Spufi and CA Platinum tolls do on mainframe? > Is there SPUFI for DB2 UDB so the users can run adhoc queries? > Is there a tool to find out objects belonging to a database? > I am aware of control center, but looking for something simple so non > technical users can use it. > > Thanks > > > Mehdi Fakhar > DBA > (904) 739-6291 Office > (904) 739-6401 Fax > [EMAIL PROTECTED] > > > > > > -------------------------------------------------- > This e-mail transmission contains information intended only for the use of > the recipient(s) named above. Further, it contains information that may be > privileged and confidential. If you are not the intended recipient, you > are hereby notified that any dissemination, distribution, or copying of > this message (including any attachments) is strictly prohibited. If you > have received this e-mail in error, please notify the sender by reply > e-mail and then delete this message from your mail system. Thank you for > your compliance. > > > - > ::: When replying to the list, please use 'Reply-All' and make sure > ::: a copy goes to the list ([EMAIL PROTECTED]). > *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
