Hi All
We have to perform migration of data base from oracle(unix) to db2(z/OS).
Apart from the technical constraints there are some enterprise architecture constraints imposed as well (like max size of FTP transfer cant be more than 2 GB).
The DB size is 1.5 TB. There are approx 200 tables. Maximum no of rows in a table is around 70 million. The tables definitions exist on Z/os. The data from the z/os will be deleted and loaded with the data from oracle.
We plan to load the data using delimted file format. Remote connection from unix to db2 is not allowed ( enterprise architecture dictum :-( ).
There seems to be more than 200 ( 2 GB) files which need to be first FTPed and the loaded into specific tables. Referential constraints will be checked after all the files are loaded using the db2 utility. The control card and data files will be provided by the unix system. The table definitions on z/os and unix mapped 1:1.
Whole process seems too manual to me and the chances of error seems to be very high.
Please suggest is there any other optimal way of doing it. let me know if some more info is required.
Remote connection from unix to db2 is not allowed.
from the sentence I meant we cannot use connect direct.
Reason being for connect direct (as i am told by infrastructure team) infrastructure is not in place.
Joined: 27 Oct 2009 Posts: 505 Location: Netherlands, Amstelveen
tomehta wrote:
Hi Peter
from the sentence I meant we cannot use connect direct.
Reason being for connect direct (as i am told by infrastructure team) infrastructure is not in place.
regards
Well you could have been more specific about that.
Beside FTP what other tools/software for remote connections are installed?
Whole process seems too manual to me and the chances of error seems to be very high.
Please suggest is there any other optimal way of doing it. let me know if some more info is required.
If you are nervous to loose the overview of the entire operation I would suggest that you get the activities into your job scheduler system. That way you can recieve incoming FTPs, merge data files, load tables, and run stats utilities in a predefined order and keep track on every table load.
Besides that, you probably will have the benefit of using the production technical user for the operations, and you will not have to bother getting the right user access for table administration. It will also be easier to audit what have happened, provided you have a production logging system.
