Problems with Database move - Windows to Linux

[Carl]

I'm a relative newbie to DB2.

I need to move a database from a windows server to a linux server. I
have already identified and resolved an issue with schema names, but I
now have a vexing problem with BLOBs. The table appears to have come
over well (queries show all records match between the two), but the
linux box can't retrieve the data.

I used the db2move DATABASE export/import commands.

Prior to importing, I modified the db2move.lst file under linux using
vi and search/replace (%s/oldschema/newschema) to correct the schema
mismatch.

Does anyone have any recommendations with moving the table containing
the BLOBs from windows to Linux?

Thanks in advance.

Carl

[Carl]

After a little digging:

The DB2 FixPack levels are different:
* Windows is at FP7
* Linux is at FP9

I receive an error when trying to show Table Spaces for any table - not
just the one with the BLOBs (db2cc -select table -show related ->
Table Spaces tab). The error is in Linux, but not in Windows:
* [IBM][JDBC Driver] CLI0611E Invalid column name. SQLSTATE =
S0022
Thank you,

Carl

[Ian]

Carl wrote:

I'm a relative newbie to DB2.

I need to move a database from a windows server to a linux server. I
have already identified and resolved an issue with schema names, but I
now have a vexing problem with BLOBs. The table appears to have come
over well (queries show all records match between the two), but the
linux box can't retrieve the data.

What does "can't retrieve the data" mean? You're saying that the
records are in the table ("all records match between the two").

An error code or something would be helpful.

[Ian]

Carl wrote:

After a little digging:

The DB2 FixPack levels are different:
* Windows is at FP7
* Linux is at FP9

I receive an error when trying to show Table Spaces for any table - not
just the one with the BLOBs (db2cc -select table -show related ->
Table Spaces tab). The error is in Linux, but not in Windows:
* [IBM][JDBC Driver] CLI0611E Invalid column name. SQLSTATE =
S0022

Try running 'db2updv8 -d <dbname>' on the linux box.