We want to create a web application that storing data to DB2 UDB 8.1 of AIX 5.
1 server. what are the possible tools to enable the full text search
functionality on the database content? Please tell me the pros and cons.
Thanks!

I have been asked to start positioning from DB2 on Windows to helping
maintain another DB2 database on the mainframe (AS/400).  I am
comfortable in DB2 but have never used the green screens and all.
To get my footing during the transition phase, I have been trying to

We are using ASCII-Tablespaces with the Codepage 819 on z/OS. We're now
having a problem with the EURO symbol. The data is inserted from a
Windows-Client, running Codepage 1252. The Euro symbol is not part of
the Codepage 819 which leads to a converting of the Euro Symbol to

db2_all "db2 update db cfg for sample using tsm_mgmtclass \'\'";
ksh: syntax error at line 1 : `{' unmatched
ksh: syntax error at line 1 : `{' unmatched
ksh: syntax error at line 1 : `{' unmatched

I am re-doing a database onto V8.7 on a RAID 5 0 array.
That is, in this wildly-striped system, which I'll never understand,
there is one Container in each Tablespace.  Most tablespaces are DMS.
ExtentSize is "the number of pages that will be written to a container

HERE I HAVE MADE USE OF SAME CURSOR DECLARATIONS AND USAGE IN THE
FOLLOWING TWO DB2 CODES .
BUT I AM GETTING AN ERROR IN THE FIRST CASE i.e CURSOR IN A SIMPLE
BLOCK.

I was wondering if anyone could tell me if there was a way to run JOINs
and UNIONs on data located on different DB2 UDB instances that wouldn't
involve implementing a federated database solution. Is this at all
possible?

Does anybody know where I can download the DB2 version 7 JDBC drivers
for windows... The DB2 system is running on zOs. We don't upgrade to
version 8 for a month and developerWorks only has downloads for current
versions.

I am running my DB2 Version 8 Fixpack 7 on a Windows 2003 Enterprise
Server.  I have an odd security need.  I have a user that needs read
access to the test database and I want to give him Create access only
to a certain table space/schema.  Is this posable?

I'm sure that there is a simple answer to this but I was wondering if
there was an elegant way to change the definition of the functions like
year, month and day such that they are effectively run for a different
time zone without changing the server time/timezone.  When you run say ...

Is there any way to make a select in DB2 to output in the following manner:
Attr1    value1
Attr2    value2
Attr3    value3

I made up this trivial example to show up a bug that I encountered in a more complex
application.
When a subquery is used as an inline table which is sorted by one column, the first
nn lines of the result chosen and then sorted by another column, DB2 incorrectly

DB2 7.1 FP11
Windows 2000
Earlier this evening, after dropping and recreating a trigger, DB2 locked
up. I am not entirely sure that the cause of the problem was the replacing

I'd like to create a script/program that can locate all servers running
DB2, finding out which instances are running/created and what databases
are running under them but have been told but IBM support that this
isn't currently possible for a client to do.  I'd like to get a second

I set up DB2 Personal Edition on Fedora C4 Linux. During the
Installprocess everything looks fine. But if I try to create a Database
DB2 says: "Routine "db2spcat" (specific name SQL050805133333590) is
implemented with code in library or path "\db2spcat", function