DB2 uses estimated selectivity and cardinality to optimize query plans.
For example
SELECT COUNT(*)
FROM EMPLOYEE

I have created a UDF which sits in db2 database.
I want to call that UDF from within a java program and capture the
result.
The UDF takes a string parameter and returns a double value.

Can someone recommend a better approach, I already have clustered
indexes on the t1 column in table td.
This takes more than 30 hours to complete!!
The slowdown is with deletes within the LOOP/END LOOP

Hi...
I have a table with the below records and I need to group by the name
and order by the Code
Code   Name

Can anyone tell me what kind of applications require instance
attachment.
Also the difference between connect and attach database statements.
Cheers!!!

first, this concerns db2 v8 and v9 on AIX and Linux/intel
Until now we used a "user exit" when we want to archive logfiles.
We changed the user exit executable a bit so we receive an email when the
archive fails for some reason.

I want to write a user defined function which does the following.
1. Take a string value as input parameter
2. Should execute a sql statement: select col1, col2, col3, col4 from
table_name where name = value

I am using DB2 v8.2 & jdk 1.5. I have written a Hello World program in
java. Now is it possible to call the HelloWorld program from a stored
procedure ? If so, how? I want to catch the result returned by the java
program into the stored procedure.

I am using DB2 v8.2 & jdk 1.4.
1. I have a java program which returns an array which contains 1 to 5
numbers.
The code:

Can anyone throw some light on this,
We have test,dev and production environments with DB2 8.1 fix pack10
running on aix 5.3.
Ours is an ERP finance application module, The reports which we run on

is it necessary to do runstats on global temp tables if you create
indexes on them and then want to use global temp tables with indexes
efficiently ?

Is it possible to convert IXF files to some more readable format like CSV?
I'm asking this, because when I do IMPORT I sometimes get rejected rows. The
error says that there was a problem with row 1956 (for example). How do I
know what row is that, what data is in that row?

We have a batch process that deletes about 7-8 million records every
day
& takes about 30-35 mins to complete. Is there a way to optimize
deletes? Below is the statement

I want to know what the best practices are for maintaining DSNDB07
(work database) on DB2 v7.1 for Z/OS?
A colleague swears that we need to delete and redefine DSNDB07 daily to
avoid maxing out on extents.   I can not find any information on best

Hi All;
I am trying to test the web services consumer example on a DB2 v9 ESE
Windows server. I have tried 2 methods which both return the same
error: