In Oracle you can restrict the number of rows returned by specifying 'WHERE
ROWNUM < 10'.  Can you do this in DB2 as well?

I am  using Windows,
Database territory                                      = US
Database code page                                      = 1252
Database code set                                       = IBM-1252

Can I put DB2 into maintenance mode to keep all connections closed
except the instance owner?.
DB2 7.2

I just did some replication operations between remote DB on linux and
local DB on windows yesterday
It gave me such errors when I perform db connection via command line
windows (local DB on windows)

Hello All,
Whether supports DB2 UDB 8.2 FP7 for Linux the ODBC-driver ?
If yes, whether that enters this driver into delivery DB2 UDB 8.2 FP7
for Linux ?

Hi out there,
we take our db2 backups with tsm.
From time to time we delete old backups and prune the recovery history
file.

System scenario: Linux DB2 Workgroup Server V7 FixPack 13.
I have a java application (JDBC v2 driver) that reads into memory a
considerable amount of data (100k-300k rows), summarizes
the results and then deletes data from the DB. This is done hourly.

I installed Db2 NSE 8.2 on my Db2 UDB workgroup server edition 8.2.2 on
windows
machine. After installation, in order to verify the
installation is correct or not, I issued command as:

Hello to anyone,
We operateing one of the largest mainframe in our areas and we are using an
old version of datapropagator for z/os. Our machines has reached the max
DASD and cannot keep up with the logs of db2 to store. Is there a new

I have a performance problem with the following  query and variations on the
subselect. The   EXISTS  version of the first example will complete in ~10
minutes.  The NOT logic in both the examples makes them both keep running
long enough that a communications error is the only ...

I am trying to add a line to the db2cli.ini file. I want to add a [common]
section with the line disableunicode=1. I am able to make the changes - but
I am not certain DB2 Connect is picking up the changes. So I added some
trace statements - and indeed - no trace file. Is there a ...

Folks
Not sure how to tackle this in DB2...
I'd like to have a query that would check for the presence of a given
token in a text string and return the next "word".

I'm after some guidelines on general memory allocations for DB2 8.2.2
ESE on Win2k Server FP4 with 4gb physical memory.
Seeing as everything is 32bit and win2k server does not support /3gb
switch, we are restricted memory wise for allocating memory to