469,271 Members | 1,607 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

Problems with Database move - Windows to Linux

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

Nov 21 '06 #1
3 2111
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

Nov 21 '06 #2
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.
Nov 22 '06 #3
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.
Nov 22 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by webhead74 | last post: by
13 posts views Thread by SectorUnknown | last post: by
2 posts views Thread by fowlertrainer | last post: by
reply views Thread by fowlertrainer | last post: by
8 posts views Thread by Gail Zacharias | last post: by
68 posts views Thread by rkusenet | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.