473,791 Members | 2,949 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

Similar topics

6
1804
by: webhead74 | last post by:
Hi, I'm trying to move our web site from a Windows 2000 box running IIS / PHP CGI (4.0.6) to a RedHat box running Apache (actually IBM HTTP Server v2.0.47) & PHP 4.3.10. First of all, I didn't develop our web site - a consulting firm did it about three years ago & it's pretty complex. I feel comfortable with PHP, but parts of this code I just can't figure out. They relied heavily upon register globals, it seems - so I've had to...
13
3410
by: SectorUnknown | last post by:
I've written a database (Access mdb) front-end using Python/wxpython/and ADO. However, the scope of the project has changed and I need to access the same data on an MSSQL server. Also, the front-end needs to be cross- platform (Windows and Linux). Does anyone have any suggestions on what database connectivity I should use? I've looked at mxODBC and wxODBC briefly, but am not sure what is the best way to go. BTW, although I would love...
2
2644
by: fowlertrainer | last post by:
Hello ! I have a problem. I create my projects in Windows, and I write a database synchronizing utility for copy a gdb changes to another gdb. Some of these products is need to run in linux. I'm very tired, because I download (apt-get install python2.3-kinterbasedb) the module, what working good in Windows, but in linux I get this message when I try to start my script:
0
1209
by: fowlertrainer | last post by:
Hello ! Very interesting thing: When I copy this script to another dir, it is working, but in this directory is not working. Only different is to this dir is used by an symlink. The python is not working good with symlinked dirs ??? >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
4
5324
by: Spyros | last post by:
I want to move a MySQL Database 3.23.54-max-nt from a Windows 2000 Server to a 4.0.14-max on a Redhat Linux Server. Any idea will be welcome. Thanks Spyros
6
2330
by: gnu | last post by:
Rationale to use Linux ======================= - I can't afford paying for $199 for the license of an OS that's arguably better thank Linux for each of 10 computers I have. - I want to be free of Microsoft stigma, and of constant lockdown on Microsoft products. The world is better than that. - Linux runs .NET :-) Reverse engineers in less than a year. That's
8
4400
by: Gail Zacharias | last post by:
I am investigating the possibility of using pgsql as the database in an application. I have some unusual requirements that I'd like to ask you all about. I apologize in advance if my terminology is a little "off", I'm not familiar with pgsql (yet). I need to be able to move the database files, as normal user-visible files, between machines. I.e. given a database on machine A, I want to be able to copy either a single file (ideally) or a...
68
5185
by: rkusenet | last post by:
http://www.eweek.com/article2/0,1759,1820667,00.asp The database market grew by 10.3 percent in 2004, fueled largely by hunger for business intelligence and analytics, according to numbers released by the Gartner Group on Monday. With 34.1 percent of the overall market, IBM holds a slim margin over its closest competitor, Oracle Corp., which maintains 33.7 percent of the overall market. Microsoft Corp. follows up with 20 percent of...
4
3538
by: James | last post by:
I have a VB windows forms application that accesses a Microsoft Access database that has been secured using user-level security. The application is being deployed using No-Touch deployment. The objective in utilizing this new deployment method is to reduce the maintenance overhead as well as making it easier for my users to setup and run the application initially. I have VS 2002, Windows XP, Access XP(2000 format). He is my problem....
0
9669
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9515
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10426
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10207
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9993
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5430
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5558
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4109
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3713
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.