Be consider of efficiency, I want to use "load from cursor " instead of
"insert into ... select ..."
so I write sql sentence like following:
declare mycor cursor for select a.a, a.b from table1 a , table2 b where

was having a real mess trying to upgrade v8.1.6 to v8.2.3 (aka FP10).
so i just deleted the failed 8.1/2, and did a fresh install of 8.2,
having been assured by our DBA types that 8.2 could find the files
left from the 8.1 databases.  these are testing databases, so they

Where can I download the latest DB2 Type 4 JDBC Driver?

Is there any SQL that would return the "CREATE TABLE" statement for an
existing table in the database?
Regards,
Jack

Hello All;
Assuming a PMR is in order for this, but wanted to run by the group to
see if anyone had similar experience. We just upgraded a DB2 V8 AIX
(DPF) environment to FP10 from FP6 and have a problem with an

the pseudo code for my update is
for i = 1 to n;
              insert k records into temp_table;
              update a set c1 = (select c1 from temp_table where

db2 V 8.1.3 Windows
I have an application which processes some rows using an SP.There are 2
approaches to this issue.
1) I can call the SP once and pass all the rows together as CLOB.(Rows and

does anyone have an idea as to why the reorgchk utility says that a
particular table needs to be reorged even after running the reorg
command on that particular table. answer is appreciated.

Red Hat 2.1 AS
DB2 v8 FP5
From db2diag.log.  Anyone have an idea what this is about?
2006-02-10-05.46.59.739601   Instance:md   Node:000

Hi ,
How to find out if  a table is locked ?
Thanks
Bikash

Some time ago I was working with DB2/400 - and one of the most appreciated
features was the concept logical files - a bit more than views in that they
maintained an access path. That is it maintained an index of the records in
the physical table(s) depending on specified view ...

I have a table with a column that is a varchar of greater than 255.
There appears to be a problem with grouping when the column is greater
than 255. From reseach it appears this problem is resolved at 7.2+.
Does anyone have a resolution using 7.1 (getting the upgrade requires

What are the considerations for segmenting tables? Would segmenting a
table with 45 million records be a good idea? Any link or website which
gives me a clear idea about the consideration will be appreciated.

On Linux and other UNIX like systems, you can configure a db2 instance
to start automatically at system start with the command db2iauto -on
<instance name>. But how does it work?
On Linux (SuSE 9.3) I see no entry in /etc/inittab and no entry within

I had been running 8.2 on Linux 2.6 for about a month without any
problems.  Suddenly yesterday, my database connection was severed.  I
tried to re-connect but could not (I've forgotten the error message).
I tried db2stop && db2start, which returned successfully, but I could