db2move problem

[Christos Kalantzis]

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

[Christos Kalantzis]

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

[Christos Kalantzis]

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

[Mark 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?

[hikums]

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?