Hi Friends,
 How to create the functional index in db2? Is it possible to do
that? I refered in online doc. But i am unable to find anything..
Thanks,

Please find me with this, I don't which IBM sys table to query.
I am using DB2 7.1 in OS390. I need to retrieve the FK reference
information, i.e., which PK column a FK is refer to? I tried SYSRELS
table, but it only gives me the reference/parent table information.

I have an 820 iseries on V5R1. I use DB2 connect V7.2 on a linux server.
This week I must migrate the 820 iseries toward  an 620 i5 on V5R3. I would
to know if my DB2 connect V7.2 on linux will be compatible with V5R3 ????
Thanks for your help.

Can anyone tell me if it's possible to write a SQL stored procedure,
passing in some parameters,  that will perform runstats on a table(s)
and be able to call this procedure from a script.  I'm using DB2 on
AIX/Linux v8.2.

At the moment we have a Data warehouse on Windows with UDB 8.1. Now the
warehouse will expand to 1Tb for the 7 fact tables (that is the data only,
without the indexes).
The questions are:

Is it possible to use DB2 Personal Edition to connect to a MySQL database on
another machine and is it possible to load drivers into the program i.e.
ODBC with a connection string to do the same?

I am using Load utility to load data ino a table.
I get following message
BPA0003E: DATASET OPEN FAILED FOR DDNAME: SYSPRINT.                    
BPA0044W: UNABLE TO DEALLOCATE DDNAME: SYSPRINT - RETURN CODE 0000438.

I just read DB2 UDE's license and found that it only restricts the use
of Personal Developer Edition but not the Personal Edition. Does this
mean I can use it for *any* purpose?

Is it possible to define a check constraint on a field that the field value
must exist in another table non-unique field? how to write the create table
DDL?
i.e

It appears that normally each DB2 instance runs under a separate
Unix/Linux userid.  Is it possible to run *multiple* DB2 instances
under a *single* userid?
If so, how can you identify which instance each top-level db2sysc

When a query gets executed as parallel threads, how can we ascertain
how many threads have been created for the query ?
TIA
Hype.

Looking on the IBM website the only prices they have for DB2 UDB 8.1
Workgroup Server Edition include "LIC + SW MAINT 12 MO", which I'm
assuming means "plus 12 months of software maintenance."  Is that like
Microsoft's "Software Assurance" where after those 12 months I have to

I'm investigating partitioned tables using a UNION ALL VIEW and found
the following (see ddl below):
If I create a check constraint like "check (month(tdate) = 1)" DB2
won't do branch elimination for a query like "SELECT * FROM Q1 WHERE

What ever happened to FP8??   Has IBM forgotten about it or is just so bad
IBM does not want to make it available??

I thought we would be able to have indexes in a
separate tablespace from the tables in another
tablespace.  So I went and created a INDEXSPACE1,
only to not see the syntax on how to create index