DB2MOVE

Mani

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

Mark 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

Mark 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