People,
Can someone please explain the benefits one might see in a processors
with larger L2/3 cache than say a standard server processor of 1mb.
Would 8mb L3 cache really make a huge deal to performance ?

create table ppp
(
    t int
)

can anyone give me any information about this message?
SQL State: 51002
Native: -805
Message: [IBM][CLI Driver][DB2/LINUXX8664] SQL0805N  Package

When a Function returning a scalar is written in C, it is easy to
change the code, by just creating a new loadable object.
When the code is written in SQL procedure language, how to replace the
code when there are dependencies? The restrict is default in drop

It seems that on AS/400, the IDENTITY option is not available.  For
example, I cannot declare a column as "integer generated always as
identity".
Is there an alternative that I can use?  The numbers that I would like

I just installed Information Integrator on my machine Windows XP db2
8.2.1.  I want to connect to Oracle 9i.  The closest thing I saw when
trying to create the wrapper was Oracle8.  It says the Library name is
db2net8.dll but the error that comes up when I try to create it is "The

Hey there.
I want to keep track of the transactions per second on a db2 udb luw v
8.1.7. How do I realise this? This would be the case on our production
server and I really don't like the Statement monitor, because of the

Hi everybody, i need some help please.
I have installed DB2 UDB 7.2 on Windows and created database and it
worked fine (i could access it from control centar nad using eclipse
plug-in DB2Explorer). Two days after, when i wanted to access my

I've been trying to get a distributed transaction working between a
.Net client and DB2/UDB. I've tried the following combinations:
Client                Server
Win 2000 SP4          DB2/UDB Ver 8.2 AIX server

 I'm new to DB2, I have over 10 years of experience on Oracle.
 I actually have to books on order that might help. Till then I have
been searching and reading through IBM's DB2 Information Center, as
well as manuals on IBM's website.

I found a DB2 8.2 (FP8) instance running on AIX 5.2 where the dbm
config JDK_PATH is set to a directory that does not exist. I can't even
find any JDK installed on the server. What does DB2 do with the
JDK_PATH, and under what circumstances is it used by DB2?

DB2 8.2 on AIX
Hi,
I'd like to change a column's name in a table which is part of
replication.

I have an update statement which updates 100,00 records and most often
I end up in a tran fail log error , is there any option which would
enable me to commit the updates in batches.
Please let me know if there are any work arounds.

I posted something a while ago about not being able to setup online
reorgs - the db2 control center only offers online runstats. So I
started adding tasks to reorg each table. This works fine, but
sometimes it does not! The reorg fails and alerts me that it failed.

I have a UNION in a SELECT query on DB2 where the second half does not
have all the fields that the first half has. In order to match up the
fields, I am trying to do something akin to the following:
SELECT