Here is a problem I would like some opinions on. I have a stored
procedure (I suspect that the problem exists for other procedures as
well, but I haven't verified it). First time it runs (each day) it
takes 8-10 minutes to run. If I rerun the procedure after a while it

I have a table FAMILY folowing columns:
SSN,NAME,DOB,AGE,PL_BIRTH,MARITAL_STAT
I would like to add a column GENDER between columns NAME and DOB.
Is posiible wihout Droping table FAMILY?

I've probably asked this before, but I can't remember the answer!
One can use the DECIMAL function to convert a date to a decimal.
For instance
values decimal(current_date)

Is there a way in DB2 or maybe a separate tool that will let us see
how many pages DB2 has currently read while a backup operation is in
progress.
I understand "db2 list utilities show detail" shows the amount of work

Here a database with 100+T data considering being upgraded and I'm
evaluating the risk. Before that, I wanna know how many such kind of
very large scale DB2 databases have been upgraded? Any one could give
me some reference? If you know such cases, could you tell me the names

I'm using DB2 V9 for windows
I'm inserting records into DGTT from select statement; the problem is
how to insert unique value for every row inserted.
I tried using “generated always as” clause but its exhausting at some

We're trying to take advantage of the new ROW CHANGE TIMESTAMP option.
Here is a simple table:
CREATE TABLE "ACCTASGN"."NUMBER_STATUS"  (
   "STATUS_CODE" CHAR(1) NOT NULL ,

I have a problem with a DB2 server of my customer. It is a Debian
Linux running DB2 Express-C. I have an IDENTITY field as PK in a table
and I use this value as FK in another table. Two weeks ago the FK
values got corrupted or mixed up somehow. I also got some warnings

I am trying to produce following report: sum of sales value for two years
group by months:
month   2006    2007
-------     ------   --------

The following link includes an example of a stored procedure that can be
used to truncate a table without logging:
http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.
db2.udb.apdv.sample.doc/doc/admin_scripts/s-truncate-db2.htm

       I am unable to install  DB2 on Windows Vista...
       Can anyone let me know whether any of the features of DB2 are
not compatible with Vista!
       I have been tryin' to install it several times but failin'...

What is the best way to
I have 10 tables with similar INSERT requiremnts.
INSERT INTO ACSB.VAATAFAE
WITH  AA(AA_TIN, AA_FILE_SOURCE_CD, .AA_TIN_TYP) AS

I would like to know how to we see the output of "MESSAGE_TEXT " .
Below is 1 such procedure ..
create procedure mess_test (out p_sqlstate char(5) , out p_sqlcode
int )

Is DB2 on z/OS same as DB2 on LUW ? Will my DB2 DBA on one environment have
to retrain again on the other ?
Thanks

Maybe a simple question, but what is the best way to move (not copy!) data
from one table to another?
Meaning, I want to insert a set of rows from one table to another *and*
delete all of the same rows from the source table.