Ciao a tutti,
st? migrando dalla versione 7 alla versione 8 di DB2.
Ho migrato l'istanza ma non riesco a migrare il database.
Mi da l'errore SQL1224N con SQLSTATE= 55032.

Hello Out there!
I have a DB2 V7.2 Database (Fix11) on Win 2000 Professional. It was before a
NT 4 based Domain -
now it is a Win 2000 Domain. The database server is a domain member. Now

I am trying to test the DB2 V8.1 partitioning on the RedHat Linux EL 3
AS. I installed v8.1 successfully using db2_install and installed the
FP5.
Now, I created an ESE instance and edited the db2nodes.cfg (the 1st

EE instance DB2 v7.2.0 fixpack 3 on WIN2K.
I select some data from a table A and write it to a file using the COALESCE
function and whitespace as the null character:
eg coalesce(col1, ' '). This column has 10,000 nulls in table A.

Is it a bug or BAD (broken as designed :-) that RUNSTATS apparently
ignores the set schema command?
I am running DB2 8.1.5 on linux, using quest as a windows client.

I created 2 remote instances of administration client, then I right
clicked on one of the instance and first dropped it, then removed it.
I thought that only that instance of the admin client would be gone,
but looks like this removed the database itself from the control

I have some problem to launch db2setup (install procedure for db2v8fp3)
under linux (redhat 9.0) :
/home/root/db2v8/conpe/db2/linux/install/db2jinst: line 131:  4359
Erreur de segmentation  $JAVA_PATH/$JAVA_INTERPRETER $JAVA_OPTIONS -cp

hi, we are using db2 udb v8.1 for windows, i have changed the buffer
pool size to accommadate better performance, say size 200000, if i
have multiple connection to the same database  from application
server, will each connection take the memory 800M (200000 x 4k = 800

I have 2 applications, one a Microsoft Visual Basic application and
the other a Java application both connecting to the same DB2 database.
The database has binary LOB objects. The Visual Basic application uses
ODBC bridge and the Java application uses JDBC app driver. Inorder for

We have a procedure to backup archived logs and then purge them. The
backup product we use is Syncsort's Backup Express 2.1.5. We use a user
exit (db2uext2) to copy logs to the archive directory. The backup
procedure is essentially

Looking to find any information on how to properly configure multiple
instances of DB2. This is on Win2k db2 ver 7.2. I am basically looking
for information on how the multiple instance settings should
configured to work, how memory is shared or not, etc. I can not seem

Have been encountering an odd issue. Every now and again, certain
packages of stored procedures just become invalid. I'm aware that
dropping or altering an underlying table would render a package
invalid, but we are doing no such thing...

    We are planning to convert an application with lots of Stored
Procedures from Sysbase on Unix to DB2 on OS/390. We are basically
looking for white papers / documentation / toolkits on such
migrations. Any help regarding this issue would be greatly

I'm writing a shellscript where I'm performing some SQL queries and
assigning  the results to variables. The problem is that the query produces
a column heading, some underline characters and '1 record(s) selected' as
well as the result. All of this text is being assigned to my ...

I use DB2 UDB V8.1.5. Using embedded SQL (SQLJava), I insert a row
into a table which has some foreign keys and check constraints. The
insert works fine, but if I encapsulate the insert into a SELECT INTO
... FROM FINAL TABLE and then try to _precompile_ it, I get the