Hello, I've just started to work with DB2 (using the express edition
version 9.5 under windows vista) and I'm accessing it through a java
program (my java's very rusty). The java program loads the driver,
connects and tries to create two tables. That works just fine. Then it

I'm attempting to implement MQTs to improve performance on some nasty
SQL.
In the Oracle world, if I recall, materialized views must use tables
as underlying objects - ie., they cannot be based on views.

We've just recently converted to DB2 V8 z/os for our backend database
server (upgraded from DB2 V7).
Our java applications run under WebSphere/Windows using the DB2 Type 4
driver (V8 FP14).

Hi, all.
I'm working with a very old db2 version.
Now, I need to add to existing table a blob column.
I've not experience on db2... :-(

I am running following query using Aqua Studio 4.1/AS400 DB2
select sum(amount) from table1
amount column is a decimal(11,2)
I am expecting a numeric total with 2 decimal points but my result

for multi physical partition database, is it possible to configure
multiple FCM network (in case one network goes down). One way is to
etherchanel two ports, but concern there is what if the switch goes
down to which ports of etherchanel is connected?

Hi, all.
I'm trying to implement a REFRESH IMMEDIATE MQT to help with
performance of a particularly sluggish query.
I cannot create it with REFRESH IMMEDIATE, because of reason code

I have a requirement where in I need to display the decimal value of
0.00  as '######.00'
SELECT  case  when DECIMAL(AMT_CHEQUE,31,2) = 0.00 THEN
9999999999999.9999999

    I have a strange need to address on account of some issues with dirty
data.  To present a simplified version of the issue, I need to find a
sum of certain values that pass a filter criteria.  However, some of the
rows will have NULL values in the column to be filtered... and ...

I am running a  " select " query on my DB2 Table ....which has around
45 columns ..from UNIX prompt .
The query output is quiet staggered . Cant we set the window size  to
accomodate all the DB2 columns .

My database DB03 is circular logging. I called the db2 procedure:
get_dbsize_info to get the database size as below:
 Parameter Name  : SNAPSHOTTIMESTAMP
 Parameter Value : 2008-04-08-06.39.49.518070

Hi hi.
I'm trying to figure out where our RAM is going.
We have an Opteron machine with 16GB of mem, on which db2 8.2.6 WSUE is
running. The OS is SLES 10. X86_64.

I have a situation on a DB server where the "current timestamp" command
shows the actual system time offset by one hour, which has never been
noticed before?!?
The DB2 is V9.1 (FP03), running on AIX 5.3.

After I have istalled express version of DB 9.5 on Vista.
I create a stored procedure(used global temporary table),
When i try to execute this procedure, it's very very slow,
even if there is only one row can be fetched.

For those doing cross platform DB2 development the manual is now in its
third version:
http://www.ibm.com/developerworks/db2/library/techarticle/0206sqlref/0206sqlref.html
A link to bookmark....