Create DB2 table relations
Home > IT Answers > DataManagement > Create DB2 table relations
Toramky
5 pts.
0
Q:
Create DB2 table relations
DB2, Table Relationships, DB2 Table Relationships, Mapping table relationships
There is a requirement to have a subset of data available in DB2 tables in production to a test environment. There is no relationship defined in DB2 (so info available in catalog relationship tables). Now we need to find the relationship between the tables using some automation process. So we might not able to manually see each and every program to check how the tables are related. Any suggestions/ideas would be greatly appreciated.

Thanks.
ASKED: Nov 21 2008  10:34 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Nperk
20 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Without RI or a really good data dictionary you are essentially out of luck for doing this completely automatically. You'll need to get somebody to at least define the relationship to you -- there are ways to deduce relationships based on table names / column names etc. but you can't be guaranteed that your interpretation is 100% accurate. Once you've mapped out the relationships of the tables then generally the easiest way to solve the problem is to write a quicky program that moves the data for you. Depending on how nice you are, you can make the program smart enough to recognize general keys and then move it all together based on simple user input to the JCL (or ISPF panel, etc). Don't forget the option to allow the requester to either REPLACE or RESUME (append) the test table data.
Last Answered: Nov 24 2008  8:43 PM GMT by Nperk   20 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0