Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!uwm.edu!zaphod.mps.ohio-state.edu!brutus.cs.uiuc.edu!psuvax1!psuvm!auvm!UCCVMA!ISCCDR
From: ISCCDR@UCCVMA.BITNET (Charlie Ridlon ISCCDR@UCCVMA.BITNET (415)-987-0692)
Newsgroups: bit.listserv.db2-l
Subject: DB2 Data Structure Tools
Message-ID: <DB2-L%90020519505403@AUVM.BITNET>
Date: 6 Feb 90 00:50:53 GMT
Sender: DB2 Data Base Discussion List <DB2-L@AUVM>
Reply-To: DB2 Data Base Discussion List <DB2-L@AUVM>
Lines: 33
Approved: NETNEWS@AUVM Gateway


 At UC Office of the President, we are about to install our first
 production system that uses DB2. One of the things that became
 apparent during development was the need for tools to assist in
 the manipulation of DB2 objects. In particular, we will be evaluating
 tools that will:

     - change structure attributes (column size)
     - change structures (move column from one table to another)
     - reorganize the data structures (unload, drop, create, load)
     - restore all dependant objects (views, plans, authorizations)
     - copy data between tables
     - migrate objects between subsystems

 We will be considering software from BMC (DB2 Alter, DB2 Reorg Plus,
 DB2 DASD Manager), Platinum Technology (RC/Update, RC/Migrator),
 Online Software International (ProEdit, ProAlter/Plus) and XA
 Systems (DB2 Xpert).

 I am interested in hearing about your experiences with any of these
 products and suggestions for other products that might meet our needs.
 Specifically, which products (if any) do you use? How easy is the product
 to install and maintain? How would you rate the vendor? Would you buy the
 product again knowing what you do now?

 Thanks in advance for your responses.


 Charlie Ridlon
 University of California
 Office of the President
 ISCCDR@UCCVMA.BITNET
 (415)-987-0692