In the situation where
   all tables are managed by system, and
   Windows 2003 Server, and
   DB2 v8.2, and

I am a database Ph.D. student who is currently looking for research
topics for my thesis. I am very interested in identifying and solving
real problems faced by database users. Unfortunately, due to
environmental constraints, I don't have much chance to interact with

Is there any known limitation with DB2 Generate DDL Command (from
Command Center).   This makes use of DB2LOOK program to generate the
scripts.
The generated script is only having first 30 tables.  The remaining

In DB2 8.2 on Linux is it possible to do sub select statements.
Statements like select col1, col2 from ( select col3, col4 from table
2 ) .....?
Also does DB2 8.2 have UNION, MINUS etc like Oracle?

Is  DB2 Development Center an addon product that I have to download or
purchase separately?  I can't seem to find it in any of my downloads
or on any of my CDs.  Is it available for all versions of DB2?
I currently have two versions of DB2.  My production environment is

I'm getting a weird error from the CLI Driver.
   [IBM][CLI Driver][AS] SQL0100W  No row was found for FETCH,
                                   UPDATE or DELETE
The weird part is that i just updated the record it now says that it can't

How prevalent are 'types' used in oltp/olap systems using DB2 UDB? Is
their use primarily used for logical modeling? I rarely see references
to types.
for example, the Employee and Student are a type of Person. Manager

i want to get the server date in sql server i got this s.p
CREATE SP GETDATE()
select get date;
it returns me the date but now in db2 i dont know how to do it, thanks in advance.

Hi anyone been using a tool for logging ALL sql statements processed on DB?
I run DB2 8.2 express on LInux
Thank you,
Christos Kalantzis

Pulling our hair out over this one. We have two databases. One is used
for OLTP. The other hosts old closed transactions and is mainly used
for reporting. Every month we identify rows in the primary (OLTP)
database that are eligible to be moved and ship them over. Been doing

I create my database and a number of tables from within a .bat file.
When I set the FULL_TXT field to 3800 or less, all is well. Above
3800, I get
SQL0286N  A default table space could not be found with a page size of

want to use the com.ibm.db2.jcc.DB2Driver (Universal Jdbc Driver) ...
In witch db2 distribution can i find it ? and version ?
(for type2 and type4)
thx

DB2 8.1
-------
db2 => create table test (COL1 VARCHAR(10))
db2 => insert into test values ('A')

I had created something similar to this example from an IBM site
http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.ud
b.doc/ad/samples/sqlproc/s-tbfn-db2.htm
As you can see, DB2 8.1.3 is not happy with this.  But if I take out
the MODIFIES SQL DATA line, ...

From snapshot,
Total sorts                                = 4
Total sort time (ms)                       = 5240
Sort overflows                             = 1