Moving seed list from DB2 Mainframe to Oracle database

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We are using the seed tables which comes with Broadcom CA Test Data Manager. The seed list resides in Mainframe DB2. Now we would like to move the seed list from DB2 Mainframe to Oracle database. We have following queries.

1. We have been using the same seed list for more than 10 years now. Instead of moving the seed tables from Mainframe DB2 to Oracle database, can we use the new seedlist comes with package currently? If yes, how to make sure the existing Mainframe DB2 and the new seed list are same?

2. If above is not a suitable option, guide us the steps to move the tables from DB2 Mainframe to Oracle database

Environment

All supported TDM releases.

Resolution

You should be able to install the Oracle instance of the Scramble database. It comes with the example seed tables that can be found in the GTSRC_REFERENCE_DATA, GTSRC_REFERENCE_LOV, and GTSRC_REFERENCE_LOV1. It also contains the GTSRC_XREF table, and GTSUBSET table. 

If you have added any custom seed data to GTSRC_REFERENCE_LOV1, you will need to backup your custom data and move that over to the GTSRC_REFERENCE_LOV1 table on the Oracle Scramble database. Likewise, any custom entries in GTSRC_XREF that you need to keep should also be backed up and moved over. 

Custom tables you need to preserve as well  Back them up and somehow import into the Oracle Scramble database.