Hi Phil
Quest Central for DB2 does not alter tables in the way you describe below. In the event of an "extended alter" or a change which requires an object to be dropped/recreated we do the following process:
1)Unload all data
2)Drop object
3)recreate object with changes applied
4)propagate any relevant changes to dependent objects i.e.. indexes, views, etc
5)recreate all dependencies
6)reload data
7)optionally collect statistics
8)optional copy
9) rebind any dependent packages
We have many very large environments such as Siebel implementations using our tools with great success.
Jim Wankowski
Quest Software
DB2 product marketing
-----Original Message-----
From: Philip Nelson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 2:47 PM
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
