Hello,
I have to move a DB which contains CLOB, BLOB who is now on a server
NT4: DB2 V7.2 FP10.
The new DB reside on an AIX 5.1 , DB2 V8.1 FP3.
The tables with LOB's contains until 5 000 000 of rows.
I noticed that the utility DB2MOVE can create until 26'000 files, it
is not enough.
I tried so to create Federated Database to make an "Insert into table
select * from nickname_xy"
If there is no LOB, everything is running well ; But as soon as there
are LOBS, I receive a sql0351N, it seems LOBS are not supported whe
using nicknames and Federated Databases.
Can someone help me to find another solutions?
Bernard 0 1307 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: zhouhaiming |
last post by:
On our test machine I can compile my c source code on AIX5.1(ML4) by "-
q32" option and "OBJECT_MODE=32" environment variable, and it can
correctly running. My operation system environment is: AIX5.1, ML4, 32
bit Kernel, IBM c5.1 compile and Informix7.31. I can't compile my c
source code on the same system by using "-q64" option and
"OBJECT_MODE=32"environment, the c compiler raised the error:
/usr/informix/lib/esql/libifsql.so can't be...
|
by: sandeep G |
last post by:
I've a table which has a number & a blob column, both of which are NOT
NULL type. This table is composite partitioned using range & hash on
the same column.
Each partition is sub partitioned into two.
Now if I try to move the partitions to a different tablespace I get an
oracle error sayiing that ERROR: ORA_14257 cannot move partition other
than a Range or Hash partition
Now is there any other way to move the partition to another
|
by: sea |
last post by:
Hi, I have DB2 Workgroup edition, version 7.2, fixpak 7 with a table
column of lob field, sizes of actual data in this field range from 50
to 100 mb. My java application takes FOREVER to query the table and
display the data in this lob column. Any suggestions on how to
increase the speed? Will stored procedures help? Will it help for the
java application to read the lob field in chunks instead of reading it
all at once? Right now for each...
|
by: Laurent |
last post by:
Error While fetching BLOBs from a table using DB2CLI :
------------------------------------
SQL0429N
The maximum number of concurrent LOB locators has been exceeded.
Explanation: A maximum of 32,000 concurrent LOB locators per unit of
work, is supported by DB2.
User Response: Modify the program so that it requires fewer concurrent
LOB locators and try again.
sqlcode: -429
|
by: tigr |
last post by:
I am trying to read BLOBs from a large table (i.e., greater than 34K
rows) using Java and the IBM JDBC driver (actually through an
Application server).
I get the following:
SQL0429N The maximum number of
concurrent LOB locators has been exceeded. SQLSTATE=54028
I understand that the LOB locators are pointers to the BLOBs, but is
there any way to free them explicitly, or get the server to do it ?
| |
by: linyy_ca |
last post by:
Hi All,
I have upgrade the OS from AIX5.1 to AIX5.2ML03 and installed DB2v8.2(
no FixPack) on RS/6000 H50. I find it is very slow when run command
db2icrt to create Instance and db2start.
The db2icrt took me 2-3 minutes to finish.
The db2start took more than 1 minutes to start( without any database).
The hardware config is 2CPU 1GB memory.
|
by: nagaraj_hayyal |
last post by:
hi all,
i am a c++ developer facing a problem with DB2-CLI on AIX5.2.
we are using db2 v8 fixpak 10, gcc 3.3.2, on aix5.2 with extensive use
of STL vectors.
we are using ODBC 3.0 for our applications.
the exception we are getting is "function sequence error cli0125E".
we are using multithreaded applications which uses pthread library.
with single thread the application works fine without any such
exceptions.
but when we execute with...
|
by: frederic.germaneau |
last post by:
Hi,
I'm trying to install, postgreSQL v8 beta2 on AIX5.2,
and I have one problem:
configure refuses to see AIX5.2 like as an OS assuming multithreading,
any idea to resolve it ?
|
by: cpressley2 |
last post by:
Hi all,
I am doing a db converison from windows v7 to aix v8. The db contains
many LOBs. I did an export specifying the LOB option, compressed the
data (using tar and gzip for windows) , ftp the data, and decompressed
the data. I then ran the import using the same LOB option and the
output from the import command says that the data was loaded with no
issues.
However when the application tries to view the data, it complains about
|
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,...
|
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...
| |
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...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |