Don't know if this is the right place, but maybe someone can point me
to the correct source.
I bought DB2 Developer's Edition.  I am now at the point where my
application is not yet in production, but needs to be tested in an ASP

I'm new to DB2 as you can see at the Posting-Count.
I'm not sure but I think that I read about that the Source of stored
Procedures and Functions get stored in SYS-Tables.
Is this right? How can I get back the Source of my Functions??

What is a "Device" in creating DMS tablespaces where the storage
subsystem is RAID 0 3 or 5 0, ie, heavily striped.  I'm referring to an
array of 6 disks.  One or several logical volumes can be created.  Are
they handled by DB2 (8.2 Win WSE) as one device, or can I configure for

I have 2 Stored Procedures and want to call them out of a Trigger. I
know that I'm not able to access Tables witch are part of the
Trigger-Query so I do not.
My Trigger is:

Does IBM offer DB2 hosting?

Has anyone else seen the current DB2 ad campaign playing in the current
trade rags - "DB2 Won't Abandon You" - with the implication that Oracle
is evil because it desupported Oracle 8i last year.
Am I missing something, or is this a completely stupid argument?  IBM

I am migrating from PostgreSQL to DB2 and now I've got a problem with a
Stored Procedure. In PG it is possible to pass SQL Results to a
Procedure but how to do this in DB2? The online Doku only explains the
"normal" Datatypes such as int, real, ...

I try to create a Java Procedure in DB2 running under SuSE 9.3. But the
install_jar command fails with:
Error 58004 Error starting the Java Interpeter.
a db2set -all command results in:

I have come across a bizzare behaviour with DB2/UDB 8.2 on SuSE Linux
2.41
When I have a MQT Refresh going on (complete refresh) it appears to
lock the underlying base tables used to build the MQT.

Considering a project which will target DB2 UDB on Linux as the primary / suggested platform, but also support MySQL and/or PostgreSQL as our project is GPL so it would be "slightly" rude then to
require a licensed database to even "kick the tires"... but then DB2 does rock!

Hi All;
I'm having a problem running an external routine (C language) under DB2
8.2 (FP 9) on AIX 5.3. Since the code was mostly copied from the DB2
sample library, I'm pretty sure it's sound. When executed ("call

Could anyone help me with the option which I need to include in a
export statement which would avoid the quotes " in the output for
columns with Data Type as String.
Vj.

If I try and do a "SELECT IDENTITY_VAL_LOCAL() FROM SYSIBM.SYSDUMMY1"
after I have run a stored procedure in DB2 version 7.2, I get the last
generated Key before the CallableStatement was executed in the
transaction and not the key generated in my stored procedure.

I am trying to find examples of two things that I don't see discussed in the
IBM manuals. I was wondering if the readers of this newsgroup could help me
by giving me some examples or at least pointing to examples that might
already exist somewhere.

This may seems to be a stupid question but I can't figure out how
configuration of more than 4 GB memory on Windows works.
dbset db2_awe=1,<number of physical pages>, <number of address windows>
The first parameter is bufferpool id.