Env: DB2 UDB 8.1 on AIX
We are executing a db2 sql stored procedure which is invoked from a
java client. The stored procedure contains few select, insert and
update statements.

How can you determine which indexes are currently marked as invalid in
DB2 UDB v 8.2?
Thanks in advance.
Martin

In the past I spent hours and hours and hours writing, editing and
compiling stored procedures (I am not a pro).  It could take me two
days to get a single stored procedure to work.
Then came the revolutionalry Development Center.  On one single window

I've been struggling on and off for 3 months trying to connect to an
DB2 database running on an IBM iSeries machine.
I FINALLY figured out how to connect with Coldfusion (see instructions
below).

I'm new to DB2 and am trying to execute a parameterized stored
procedure from within a VB 6.0 application.  We're using DB2 WSE
version 8.2 with fixpack 10 running on a Windows Small Business Server
2003.  I created the stored procedure on the DB2 server.  When I call

I've got a UDF that is used on the publishing side of a data warehouse:
when the data is headed out to a mart.  It works fine for sets of a few
thousand rows, but really slows for sets of a few million rows:  a
query will go from one to thirty minutes due to two calls on each row.

If  server 01 running HADR in the primary role crashes, and the DBA does a
HADR takeover by force on the 02 server to switch roles, then the 02 server
is now the primary.
What happens when the Server 01 is brought back up? It still thinks it is

I'm using DB2 and I'm trying to pull information from a table.
I've tried every function possible (IFNULL,COALESCE,CASE) to get a zero
every time the column is NULL.
The thing is I don't know if they are actually nulls or if they are

Is there a way to achieve that a select against a database will be case
insensitive?
Meaning that 'select ' from tab1 where col1 = 'abc'' will return the same
result as 'select ' from tab1 where col1 = 'ABC'' . I know the functions

DB2 UDB Work Group Server Edition V8.1.5
Nightly incremental delta backup, and the image size is 3GB.
But the transaction log for a whole day is less than 100MB.
How could this be possible?

I have a IBM iSeries (aka AS-400) running v5r3 of OS/400 that I access
via a linked server from SQL Server 2000.
The following select works fine:
select * from prod400db.test.meldbf.InventoryHistory

I'm developing a C++ application that needs to communicate with DB2. It
seems that the only way to do that, according to the IBM documentation,
is with the CLI API.
The problem with this API is that it needs an ODBC datasource to be

I had been campus recruited by IBM Global Services and after only one
month training I am working as a DB2 DBA on client side for past two
months.
I dont see many oppurtunities building for me in future since a DBA

we have an AIX 5.3 OS, and we purchased DB2 UDB version 8 Workgroup
Edition.
We want to install 64 bits version, but the source CD's that we have
say:

I'm trying to understand what do I need to do when one of my partitions
fail or is dropped from a partition group. Do I have to run the
REDISTRIBUTE DATABASE PARTITION GROUP command or will redistribution
happen automatically?