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

DB2MOVE

P: n/a
Hi Everyone,

i have a doubt regarding db2move utility.

I have created a database with circular logging (primary logs - 2,
secondary logs - 1). I imported tables into this new db using db2move.
A table which has 1147020 records has been imported without any
"transaction log" error. But if i happen to insert the same amount of
records into table using import it failed.

Its on DB2 V8 FP15.

How could db2move handle this situation?
Aug 18 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Mani" <ma***********@gmail.comwrote in message
news:e5**********************************@k36g2000 pri.googlegroups.com...
Hi Everyone,

i have a doubt regarding db2move utility.

I have created a database with circular logging (primary logs - 2,
secondary logs - 1). I imported tables into this new db using db2move.
A table which has 1147020 records has been imported without any
"transaction log" error. But if i happen to insert the same amount of
records into table using import it failed.

Its on DB2 V8 FP15.

How could db2move handle this situation?
What is the exact command you used? Did you use the load option or the
import option. Load does only minimal logging.
Aug 18 '08 #2

P: n/a
"Mani" <ma***********@gmail.comwrote in message
news:d3**********************************@b2g2000p rf.googlegroups.com...
>Hi Mark,

Sorry for not being clear. I have used import option in db2move.
( command: db2move neo import)
When doing an import, it is possible to use the COMMITCOUNT parameter, which
does intermediate commits. I don't know if db2move uses that by default.
Aug 19 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.