Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Location
    St. Louis
    Posts
    16

    Unanswered: Data Management Tools

    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!

  2. #2
    Join Date
    Sep 2003
    Posts
    218
    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.

  3. #3
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    IBM Data Archive Expert.

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •