472,352 Members | 1,465 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,352 software developers and data experts.

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 4754
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: TD Matthews | last post by:
I'm hoping someone has seen this. I'm moving our dev db (8.1 FP5 for both) to a windows machine from AIX using db2move, and all goes well except...
2
by: erkki | last post by:
Hi, I am trying to move DB2 8.1 database from AIX to Windows. Following errors appears when I try to run db2move db import. <IMPORT.out>...
2
by: valerio | last post by:
Hi all, I've some problem to import data to DB2 using the db2move and db2look tools. Follow the problem : I have exported data from db2 v. 7...
1
by: Terry | last post by:
Hi All, Im attempting to use db2move from 7.1.0 to 8.1.4. It fails to import tables defined using the columns with GENERATED ALWAYS. The error...
4
by: Christos Kalantzis | last post by:
Hello I am migrating a DB from AIX DB2 7.2 to Linux DB2 8.2.2 amd_64bit Linux 2.6. I have often migrated databases from one platform to another...
0
by: ibm_97 | last post by:
Hi, I'd like to move 2 tables' data from schema1 in db1 to schema2 in db2. There's no schema1 in db2. I use something like the following, but I...
2
by: Alan | last post by:
Guys, Got a DB2 ver. 8.2 on Windows 2003 with four tablespaces (some field size around varchar(2000 on it) define on it. Try to create another...
0
by: mikeodba | last post by:
Summary: SQL3255 Reason code 2 from db2move with DB2 v9.1 fixpack 5. on Win32. Win32 DB2 version 9.1 fixpack5 , performing DB2MOVE COPY with...
1
by: Richard2000 | last post by:
Hi team, Has anyboby faced this issue? I'm trying to use db2move to export as400 schema content to my local windows file system. The aim is to...
0
better678
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
1
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.