Looking for a better way to implement this stored procedure. The issue is
that at the end of the procedure, when you try to drop the temp table after
you open the cursor, you get an error stating can't perform that action
because there's a pending operation on the temp table (the ...

     i am facing a problem with a db2 database created with utf-8
character set. My db2 server is running on windows 2000 server, client
is on another machine that is also running windows 2000 server.
installation of db2 is default on both client and server. after

Can anyone tell me what I am doing wrong?
I installed DB2 8.1 + FP5 on Red Hat Enterprise Linux 3 (Update 1),
using the command line method (i.e. db2_install and vi and ....)
The one bit that didn't seem to be documented was how to set the

after my machine windows 2000 professional installed the fixpack 5 for
db2 udb v8.1 windows 32 bit, i have this error in the db2diag.log
2004-05-05-15.09.47.031000   Instance:DB2   Node:000
PID:2488(javaw.exe)   TID:1392   Appid:none

I have rather large LOB objects and I get the error "not enough memory
to process statement" -- I increased the query_heap_sz directly on the
server, but cannot do this on the runtime client since this option is
not available for the client. How do I get rid of this error on the

On Linux, suppose a recoverable database has crashed due to a damaged
tablespace (the container on which the tablespace existed has gone
bad). On restarting the database, I understand that the tablespace
will be in roll forward pending state. Because the container has gone

please I would like to know if it's possible to load data in
hierarchical table structure with identity column used as pk (for all
the tables) :
I mean

I am installing DB2 UDB  v8.1 Personal Edition for XP Home. WHen it tries to
install DAS, it asks for the Domain, Userid and password. I gave the
following:
DOmain: My computer's name (db2test)

I'm looking for information about DB2 UDB v.8 's physical data
structures (structure of primary and secondary indexes). I looked for
in IBM site, but I just found out something about B+tree. Do you know
where can I look for?

I have DB2 UDB v 7.2 fixpak 7. When I go to Control Center to view the
configuration, I do not see query_heap_sz listed in performance tab --
there is appl_ctl_heap_sz, but no query_heap sz. In command center
when I type in get dbm cfg, I still don't see query_heap_sz and when I

Need urgent help...
I am trying to make a change in one column (primary key). I dropped
the primary key which dropped other 2-3 foreign keys referencing this
column.

After install Fixpack 5,  the DB2 service fail start  automatic when the
server.
The service setting is still automatice startup. Manual start it after is OK
Look in the event viewer it said

Hi everybody , I have been trying to execute a simple DB2 stored
Procedure from perl. But it doesn't work. Could anybody please help me
find out why this is happening :
here is my perl script that execute the SP :

I have a table with some sensitive customer data in it.  I am now
keeping all the data in another table, and encrypting it.  I want to
get rid of the original unencrypted data and be sure that it is no
longer anywhere on disk.  Should I drop the table, or first delete the

I was pointed (thanks to Serge Rielau) to the MERGE statement as the
solution to a certain updating problem I had. It works wonderfully.
Where is the documentation for this statement!?! I spent an hour at the
IBM site :