Constraint Recovery
Asked on behalf of TimSki37: Is it possible to recover or restore database constraints in a schema/library that has been cleared and restored from a different schema/library?
We have a library that was cleared of all physical files and tables were restored from a different library. In doing so, however, all constraints were lost and the system/cross-reference tables were corrupted. As a result of the corrupt cross-reference tables, the system also no longer allows for the addition of constraints on these tables.
What steps must occur so that the contraints can be recovered if that is even possible?
Software/Hardware used:
Software/Hardware used:
ASKED:
September 18, 2007 1:40 PM
UPDATED:
February 13, 2009 4:30 PM
RELATED QUESTIONS
- Create libraries and objects in different ASP'S
- Triggers
- Help!! Physical file accidentally deleted, logicals still there. Is there hope?
- I restored system using system image, all my files and programs from last six months have been deleted. can i get them back?
- Is it possible on iSeries that an index is defined keeping in mind an sql select criteriea however when the queryis run this index does not get used.
Answer Wiki:
Hi,
Your first step is going to be to get your cross-reference tables fixed. You can do this using RCLSTG and specifying SELECT(*DBXREF).
Regards,
Martin Gilbert.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
