It seems to me the IY54968 apar (V8.2) does not correct totally the problem:
db2start
db2 connect to sample
db2 get snapshot for db on sample | grep "oldest transaction"

I created a stored procedure in oracle with the help of sql +plus:
Set serveroutput on
create or replace procedure spComp(company IN CHAR,oFname OUT CHAR,
oFamname OUT CHAR, oAdr OUT CHAR, oTelno OUT CHAR)

I have a client (customer) who asked the question : "Why would I buy and
use UDB, when MySql is free?"  
I had to say I was stunned.  I have no experience with MySql, so I was
left sort of stammering and sputtering, and managed to pull out something

I am a newbie in DB2 and mainframe technology. While compiling a query
I cam across a situation where I had to give a Hex value as the input
to a query; i.e. WHERE file_status = x'00'. Is this correct.
More over if I were to give a BINARY as the input instead, How is it

I have several quick questions about reorg's, and a request (favor).
1.  The documentation says that reorg "Reorganizes an index or a table"
I cannot see how one would reorg ONE particular index - is there a way
to do this?  More importantly, would you WANT to do this?

We tried to migrate a server from version 7.2 (fixack 10a) to 8.1 (fixpack
6a), but because we were not able to migrate DataProgator we had to return
to version 7.2. After that we get a lot of strange messages in the
db2diag.log. I can see there is anerror code ffff d8ec, but I ...

Hi friends,
  I am planning to write db2 family fundamentals(700) by coming week.
I want to know about the prometric test centers in Chennai(India) and
also tell some sites where sample test can be taken apart from IBM

UNIQUE WHERE NOT NULL  is supported in DB2 for z/OS, which allows for
duplicate null values to exist on a unique constraint.
Anyone know if or when this is coming to DB2 for LUW?

Can anyone point to any detailed documentation on Task Center, I have
seen some basic docs on IBM site, and those are very basic. Maybe that
is all there is, but let me know otherwise. I also need any information
available to email the output produced by a task from the show results

Where can I find the supported JDBC level by fixpak?  In particular,
we're at DB2 UDB for UNIX V8.1 FP5.  Thanks.

Hello NG,
for overflow reasons on numerical accumulation
of an int column during SELECTion i have to
change the data type of a column from "int"

Hello all, I am curious to know if anyone has done a trade study on
DB2, SQL Server, and Oracle databases.  Basically I am trying to
identify which one to chose based on "Ease of implementation", Ease of
maintenance", "Pricing" and "Ease of technical support".  The criteria

We observed an interesting phenomenon that is driving us crazy. We have
an archive process that takes rows off of a primary database, then
inserts them into a history database. After loading the exported rows
into the history database, we observed abysmal performance (queries

unfortunately I have no current DB2 server to try this code :
CREATE FUNCTION FN_HOW_MANY_ROWS (TableName VARCHAR(128))
   RETURNS INTEGER
   LANGUAGE SQL

We moved our DB[V8.1FP7] from one AIX[32bit] to another AIX[64bit] by
using backup/restore, ...it?s a long story..., then when we buid a
java stored procedure in development center, we got following message,
and a SQL0444N exception occurred.