I'm looking for tools to manage data. Specifically I'm looking for tools which allow me to archive data from one table to another and perhaps at the same time delete the same data from the originating table. I may also need the ability to update a column in another table and finally I may have the need to work through a set of parent/child relationships. All of this needs to be schedulable and configurable through a GUI interface.

Thanks in advance!

You can check out tools like DBArtisan (http://www.embarcadero.com/). Using this tool, you can achieve all of the tasks that you have mentioned.

But I am more comfortable in creating DDL/DML scripts for general db admin tasks.

I am not aware as to which version of DB2 you are currently using - but, db2 v8.1 lets you create a lot of these general db admin scripts for you easily.

Hope this helps.

Hi,

Guess you can evaluae this tool and some of the tools mentioned at the IBM site.

The link to the same is

http://www-306.ibm.com/software/data/db2imstools/

Hope that helps..


Nitin.