Quest Central for DB2 is smart enough to do the drop/recreate when a table can't be ALTER'ed. Now I will say that it generates an IMPORT (which will also be death by logging...), but it's very easy to take the script that they generate and change it to a LOAD. Maybe Quest will add this "feature" someday.
Thanks. Philip Nelson <[EMAIL PROTECTED]>@Lugwash.org on 01/15/2003 03:47:24 PM Please respond to Philip Nelson <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject: Re: [DB2EUG] UDB tools 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 ******************* PLEASE NOTE ******************* This E-Mail/telefax message and any documents accompanying this transmission may contain privileged and/or confidential information and is intended solely for the addressee(s) named above. If you are not the intended addressee/recipient, you are hereby notified that any use of, disclosure, copying, distribution, or reliance on the contents of this E-Mail/telefax information is strictly prohibited and may result in legal action against you. Please reply to the sender advising of the error in transmission and immediately delete/destroy the message and any accompanying documents. Thank you. - ::: 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
