Hello I'm a newbie to this and I need help, please
My question is, we currently have a IDMS db and will be converting to DB2.
What are the things I should do? The IDMS has not been documented very well,
and there are a number of duplicate fields. I was thinking about
documenting all the tables with fields attributes, and documenting the fields
to the 150 screens in this program. We also that about doing a CRUD matrix
to see what it does currently. Does anyone have any other suggestions...
PLEASE....All suggestions are appreciated. )

--
Message posted via http://www.dbmonster.com

SLC via DBMonster.com wrote:
Eventhough there are some db2 people reading this group, I think you
have a better chance getting good answers in comp.databases.ibm-db2


/Lennart

On Mar 27, 10:14 am, "SLC via DBMonster.com" <u32826@uwe> wrote:
coming from is the first step in reaching your conversion goal. Make
sure you really document the data in the new system as well. You might
also have a data model for any temporary conversion tables.

Document your conversion process, who does what and when. How do you
deal with problems during conversion? Restart the current step?
Delete some tables, erase some files and restart from an earlier step?
Delete all the db2 tables and start over? Do you convert all of the
original data at once, or do you convert over in stages? Do you have
multiple sites to convert or only one central DB? Do you need to
maintain operating the old system in parallel to the new until the
new is debugged and working?

Where the data is redundant you will need to make decisions about
what version to take. e.g. you have customer name in three places in
the original system. Which do you take? Do you always pick the same
field from theoriginal system? Or do you compare the sources and
"vote"? Or do you define a hierarchy(for dealing with missing data)?
Or do you generate reports for human review and decision? Do you
clean the original system before conversion, or do cleanup during
conversion? (e.g. correct spellings of things like street names and
cities)

Do not assume you can get all the data converted in one pass. You
might stage the data in conversion tables and try different conversion
methods on it, moving to more refined conversion table until it
matches you new data model.

Hope that's enough ideas for you. Conversions are interesting work,
and there is always a challenge of some kind.
Ed