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

db2move problem

P: n/a
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 without any
issues using db2move

db2move dbname export -l lobs/

then import on the other machine using

db2move dbname import -l lobs/
This has worked before without a problem. However now I get this error
message :

* IMPORT: table "TLDBUSR "."EMAIL_SETUP"
***ERROR -3525. Check message file tab151.msg!
*** SQLCODE: -3525 - SQLSTATE:
*** SQL3525N The "CODEPAGE" option is incompatible with the
"LOBSINFILE" option.
on every table.

Is this because I am using the 64 bit version of DB2?
Is this a known bug that can be fixed by going to the latest FixPak?

Thanks in advance!

Christos
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Just an update,

I am importing the same exported files successfully into a DB2 8.2.0
32bit Linux.

So can someone confirm that the issue is the 64 bit or the 8.2.2 version?

Christos


Christos Kalantzis wrote:
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 without any
issues using db2move

db2move dbname export -l lobs/

then import on the other machine using

db2move dbname import -l lobs/
This has worked before without a problem. However now I get this error
message :

* IMPORT: table "TLDBUSR "."EMAIL_SETUP"
***ERROR -3525. Check message file tab151.msg!
*** SQLCODE: -3525 - SQLSTATE:
*** SQL3525N The "CODEPAGE" option is incompatible with the
"LOBSINFILE" option.
on every table.

Is this because I am using the 64 bit version of DB2?
Is this a known bug that can be fixed by going to the latest FixPak?

Thanks in advance!

Christos

Nov 12 '05 #2

P: n/a
For those who care for a followup.

I reinstalled 8.2.1 x_86_64 and all worked well. Guess 8.2.2 isn't up
to snuff.
Christos Kalantzis


Christos Kalantzis wrote:
Just an update,

I am importing the same exported files successfully into a DB2 8.2.0
32bit Linux.

So can someone confirm that the issue is the 64 bit or the 8.2.2 version?

Christos


Christos Kalantzis wrote:
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 without any
issues using db2move

db2move dbname export -l lobs/

then import on the other machine using

db2move dbname import -l lobs/
This has worked before without a problem. However now I get this error
message :

* IMPORT: table "TLDBUSR "."EMAIL_SETUP"
***ERROR -3525. Check message file tab151.msg!
*** SQLCODE: -3525 - SQLSTATE:
*** SQL3525N The "CODEPAGE" option is incompatible with the
"LOBSINFILE" option.
on every table.

Is this because I am using the 64 bit version of DB2?
Is this a known bug that can be fixed by going to the latest FixPak?

Thanks in advance!

Christos

Nov 12 '05 #3

P: n/a
"Christos Kalantzis" <ch*******@intertrade.com> wrote in message
news:B_9ye.106401$9A2.104065@edtnps89...
For those who care for a followup.

I reinstalled 8.2.1 x_86_64 and all worked well. Guess 8.2.2 isn't up
to snuff.
Christos Kalantzis

Exactly which Fixpack did you use?

Did you report the problem to IBM support?
Nov 12 '05 #4

P: n/a
DB2(R) for LinuxPPC 64-bit support is now available, which includes the
generation of refreshed hybrid DB2 images. You can create a 32-bit or a
64-bit instance for most DB2 products (excluding DB2 Universal Database
Express Edition and DB2 Universal Database(TM) Workgroup Server
Edition, which only supports the creation of a 32-bit instance).
Supported distributions include Red Hat Enterprise Linux 3 (RHEL3),
SuSE SLES8 and SLES9 for 32-bit, and Red Hat Enterprise Linux 3 (RHEL3)
and SuSE SLES9 for 64-bit.

HTH.

Mark A wrote:
"Christos Kalantzis" <ch*******@intertrade.com> wrote in message
news:B_9ye.106401$9A2.104065@edtnps89...
For those who care for a followup.

I reinstalled 8.2.1 x_86_64 and all worked well. Guess 8.2.2 isn't up
to snuff.
Christos Kalantzis

Exactly which Fixpack did you use?

Did you report the problem to IBM support?


Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.