http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleI
d=9017838
IBM to open its midrange systems to MySQL's database
April 25, 2007 (Computerworld) -- SANTA CLARA, Calif. -- MySQL AB and IBM
announced Wednesday that users of the latter's System i hardware ...

I have this table:
create table my_table (file_id int not null, property_id int not null,
property_value varchar(255));
In some instances the property_value is a string representing an

I am trying the execute and admittedly large SQL query against our DB2
database. The query pasted into MS-Word has 2800 words, 21000
characters (w/o spaces), 26000 (w/ spaces) and 1000 lines. There are
UNION ALLS, and subqueries LEFT JOINing to other subqueries. That

Database was no responding when user did some query operation. I
checked db2diag.log and found EDU error mentioned in it. I pasted them
below. I am not sure how to sovle it. Any advice? Thanks in advance!!
James

I just installed the free DB2 Express. I am going through the wizard
and I am unable to create a database. I keep getting the error "create
database path does not exist". The log file says "An attempt is made
to create a database on a path without first enabling this feature

v8.2.7, windows xp.
---
create procedure cursor_test()
language sql

At work, some people have found IBM's Migration Toolkit (MTK) to be a
nice tool for copying data from one table (in another DBMS product) to
DB2.
Now, they want to do the same thing from one DB2 database to another DB2

i try to find a query for selecting one arbitrarily chosen row from
each group of rows.
Example:
$ db2 "select * from T"

My old laptop has DB2 V7 thereon. The only fixpaks I ever applied were
FP1 (although I cant truly remember if I actually did this one) and
FP2. Because it/they entirely satisfied my needs I applied no more
fixpaks. And I didn't keep FP1 or FP2:-( but we're going back six or

I installed DB2 V9.1 FP2 on RHEL AS V4 (DB2 Server) and Win XP SP2
(DB2 Client).
The strange thing, there were two database aliases TOOLS0 & TOOLS1 in
the DB2 Client that were mapping to the same remote tools catalog

I'm trying to create a testdatabase from a productiondatabase. The steps
I've gone through so far are:
export data with certain criteria from roughly 150 tables
drop f.k pointing to these tables

Some users are frustrated by DB2 locking their database operations (most
recently: a table drop took forever, probably because of a lock).
The natural and sane question I'm being asked:
Is there a way for a user to see if a query is stuck waiting for a lock,

I am looking for SQL syntax that will enable me to subtract quarters
from timestamps.  Any suggestions?
Pseudo-code example -
YEAR( timestamp_column - 9 Quarters)

I have a database backup with coding cp1252 and I want to convert it
into utf-8.
How can I do that ?
Best regards,

When I am running a SELECT statement form command line processor, is
there any performance benefit in including "for read only" cluase on
the SELECT statement ? I am not talking about any cursors though.
- Thanks