Sorry if this questions is too basic. just wanna know if the max
function in db2 gives the result based on the ascii value or in
ascending order. I tried but not able to figure out the result.
Any help will be greatly appreciated

Anyone know why I might be seeing this error...
2005-11-08-12.17.18.916000-360 I13443859H513      LEVEL: Severe
PID     : 2364                 TID  : 3700        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000         DB   : FRDMARTD

we are using db2 udb v8.2 on windows.
if we need to  run a reorg and runstats monthly, i think the best way
to do them is via the tool "Configure Automatic Maintainance". I find
out that for reorg, it has to be done offline. So I should schedule the

I created a MQT defined as:
select a.col1,a.col2,a.col3,b.col1.b.col2
from a , b
where a.id = b.id

I am having trouble with a simple task of declaring a variable.  Is
this possible?
Here is what I want to do.
DECLARE start_date date;

Does anyone know how to use and OS/400 library list with a DAD to
indirectly reference the "collection", a.k.a. "database", a.k.a
"library"?
All of the examples I see have the library name hard coded into the

I bound my package with EXPLAIN(YES), and it's got the following static
SQL in it:
EXEC SQL SELECT CARDF,  RECLENGTH
          INTO :CARDF,:RECLENGTH

I have sucessfully set up an HADR pair of databases. Everthing works
fine for the primary and secondary HADR databases, and manual takeover
works fine.
When I try to set up the second pair of databases for HADR in the same

DB2 WSE 8.1 FP5
Red Hat AS 2.1
What is the difference between adding a unique constraint like:
ALTER TABLE <SCHEMA>.<TABLE> ADD CONSTRAINT CC1131378283225 UNIQUE (

I have a new  AIX 5.1 server with db2 8.1 work group server installed. I
recovered a new database using redirected restore from an online backup image
created from another same platform server. I didn't realize the tablespace
problem until I applied db2 Fixpak 9a on my new server. I ...

Can i write user defined function in the db2 persional edition by the
java, without the COM.ibm.db2.app.*?

[8.2.1 UDB on linux]
I've got two tables, one holding the current price of a product, and
one to hold all prior versions;
CREATE TABLE product_pricing (product varchar(10), price decimal (9,

We are running DB2 7.1 Workgroup edition on a Windows NT server, in a
Windows 2003 domain.  They have recently begun forcing users to change
their passwords every 60 days.  When a user changes their domain
password, they can no longer connect to DB2.  DB2 authenticates using

I'm new to database design and management. I'm presently taking a
course in this area. At the moment I just wanted to know when you have
the following relationship:
Entity 1 <---Relationship----> Entity 2  Integrity Contraint is 1 to N

In my haste, I added a datafile to a tablespace, but I got it in the
wrong directory.  Can I move a datafile of a tablespace?