468,119 Members | 1,962 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,119 developers. It's quick & easy.

DB2MOVE

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
2 4579
"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
"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.

Similar topics

1 post views Thread by TD Matthews | last post: by
2 posts views Thread by erkki | last post: by
1 post views Thread by Terry | last post: by
4 posts views Thread by Christos Kalantzis | last post: by
reply views Thread by ibm_97 | last post: by
2 posts views Thread by Alan | last post: by
reply views Thread by mikeodba | last post: by
13 posts views Thread by didacticone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.