I am working on bringing HWM down. what is the best way to do this ? i
know db2dart but i am afraid if this locks database or tablespace etc.
i am thinking of exporting all data, dropping tables, recreating
tables and loading data back in. is there anyone who has worked with

Hi, I'm learning what database is and how it works these days, I
choose IBM DB2 express V9.5 as my DBMS(DataBase Management System),
but I'm have no idea how to use it properly.
Now I'm wondering is there a better and efficient way to learn and use

 I want to average a quantity by hour for the last 24 hours.
The sql is like:
SELECT AVG(R.QUANTITY), HOUR(O.SAMPLINGTIME)
FROM OBSER O

I created on home PC a table more than 1 Million rows using example from DB2
COOKBOOK:
CREATE TABLE PERSONNEL
(EMP# INTEGER NOT NULL

I thought the following link could be of interest:
The USNO is conducting a poll for the DoD about leap seconds.
http://tycho.usno.navy.mil/leap_second_poll.html
I note in the description that they do not recognize the possiblity of

I have set up a test table with range partitioning.  The partitions
are by date (recdate):
1) Pre-2004
2) 2004

Just upgraded to 9.1 fp3 from 8.2  (linux)
Noticed the db2set variable: db2instdef
Can some expalin what this variable name holds.
Does this replace the other db2set variable : db2instance

I have a UDF. It is working fine.
But when i try apply the same UDF to a view it is not working.
CREATE VIEW SSN_SORTED AS
WITH TEMP(EMP#,SOCSEC#,JOB_FTN,DEPT,SALARY,DATE_BN,FST_NAME,LST_NAME) AS

In one of our use cases we generate a random number for each
participant. We initialize the rand generation with a known seed in
order to be able to repeat the selection later on (regression test
etc). This no longer works the same way in 9.5 compared to how it used

I am using below Query to find the declared global temporary tables in
a Database:
Below query is for DB2 version 9.1 , you can get same information by
taking snapshot of the tables.

For some reason, DB2 is taking a long time to start archiving the
logs. Pls, do you know what could be causing it?
I see the following msgs on db2diag.log
2008-09-04-00.36.24.414103+000 I415281A322        LEVEL: Warning

I know this could be a dumb question, I just want to confirm that it
is faster to execute inserts, if a timestamp field is set to have a
default value, like DEFAULT CURRENT TIMESTAMP, and skip that column in
inserts, than to include explicit timestamps in the inserts and let

(DB2 LUW v8.2)
When using parameter markers how does the optimizer evaluate filter
factors?
  - and is it able to make use of distribution stats. for parm.

People,
DB2 V8 LUW FP16.
My C++ application inserts several rows per minute in a table.
I am currently revamping the insert statements and have learned about

I am looking to create a stored procedure that accepts 3 integer
values that are concatenated together as a string and part of the
where clause.
Error message: An unexpected order was found.