By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,334 Members | 1,328 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,334 IT Pros & Developers. It's quick & easy.

Using "load" to migrate a database to db2

P: n/a
Hello,

I am using "load" to get the table data from another database into a DB2
database. This works quite well (before that I used "import" which is,
as it commits each "line", very slow). The problem I have now is that
when I insert some data into one table a table which stores forgein keys
from the first table has no data yet - so the table loses its
"integrity". So I have to run "set integrity" for each table (and in the
right order). Is there a was to let db2 to the work without my help?

Another question is: what happend to my indexes. I use the "INDEXING
MODE AUTOSELECT" option. Are the indexes rebuild or not (and how can I
find out...)

Thanks.

Greetings, Jan
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Ian
Jan Suchanek wrote:
Hello,

I am using "load" to get the table data from another database into a DB2
database. This works quite well (before that I used "import" which is,
as it commits each "line", very slow). The problem I have now is that
when I insert some data into one table a table which stores forgein keys
from the first table has no data yet - so the table loses its
"integrity". So I have to run "set integrity" for each table (and in the
right order). Is there a was to let db2 to the work without my help?
No, unfortunately not. You could defer creation of your foreign keys
until all loads are complete (thereby eliminating the 'set integrity'
commands).
Another question is: what happend to my indexes. I use the "INDEXING
MODE AUTOSELECT" option. Are the indexes rebuild or not (and how can I
find out...)


This is shown in the OUTPUT for load.


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #2

P: n/a
Ian wrote:
No, unfortunately not. You could defer creation of your foreign keys
until all loads are complete (thereby eliminating the 'set integrity'
commands).

This would be a solution... but how do I start the creation of the fk
after I have finish all loads?

Thanks.

Greetings, Jan
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.