title: DB2 backup and restore db table preserving foreign key constraints
body: <p>I'm currently having issue going through a test backup and restore of database table on my development machine for db2. Was never entirely successful. Although I was able to restore all data after a drop and re-create of the table, I wasn't able to reset the foreign key constraint as I got SQL error complaining that keys don't match. Here's my exact steps, I'm sure not entirely the right way to do it, but it does eventually restore the 5423 rows of data:</p>
  
  <p>The process</p>
  
  <ol>
  <li><p>export to /export/home/dale/comments.ixf of ixf messages /export/home/dale/msg.txt select * from .comments</p>
  
  <p>Note: step 1 exports 5423 rows of data to a location</p></li>
  <li><p>drop table .comments</p></li>
  <li><p>import from /export/home/dale/comments.ixf of ixf create into .comments</p>
  
  <p>Note: step 3 here creates the table but does not insert any data rows</p></li>
  <li><p>load client from /export/home/dale/comments.ixf of ixf modified by identityoverride replace into .comments</p>
  
  <p>Note: up until this step, I'm able to insert the 5423 rows of data in the recreated db table</p></li>
  <li><p>alter table .comments add FOREIGN KEY (comments_id) REFERENCES .news (article_key)</p>
  
  <p>Note: here alter table fails as db2 complaints that some comments_id does not match article_key</p></li>
  </ol>
  
  <p>Could anyone help with my problem here? Thanks in advance</p>