Environment:
$ uname -a
AIX <withheld> 2 5 000100614C00
$ db2level

I would like to write a SQL select statement that would fetch rows
numbered 50 to 100.
Let me clarify, if i say "fetch first 10 rows only", it returns the
first 10 rows from the resultset.  how do I get a specific subset of

DB2 LUW 8.2 FP14 Red Hat AS 2.1
Can I use SYSPROC.ALTOBJ() to simply rename a table that has complex
dependencies (RI, functions, triggers, etc...)?
Seems like all the logic is in there to tear down all the dependencies,

I have a custom task manager application that makes a call to a stored
procedure with an output parameter.
To achieve this, I constructed the stored procedure in an atomic
statement as follows:

My dev team is getting this error when they run big load program :
COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0601E  Invalid
statement handle or statement is closed. SQLSTATE=S1000
.

Just wondering if its possible get more descriptive error messages in
to  com.ibm.db2.jcc.b.SqlException. getMessge or toString() methods
gives only SQL-error codes like:
SQLCODE: -1218, SQLSTATE: 57011, SQLERRMC: 4096

While we are going huge amount of inserts (like 70K with commits after
500 records) I get this error on the db2diag.log and the application
starts failing :
2007-01-19-08.48.34.964633-360 I402779C467        LEVEL: Warning

I m trying to use coalesce but i m getting this error below, btw i m
using db2 8.2.
what i m doing is;
...

I'm curious how people decide the amount of memory available to db2.
For example, we have a machine running AIX 5.3 with 32GB of memory.
Assuming that the machine is dedicated to DB2 how much memory can DB2
use on this box without incurring paging?  Does anyone know of any rule

I am trying to create a incrementally updatable Materialized Query
Table on our as400 v5r3 per examples found on the internet. Shown
below.
create tABLE SQLLIB.INVMAST_MQT AS (SELECT * FROM SQLLIB.INVMAST) DATA

If I do
Begin transaction
Stmt 1: select count(*) from tableA
If the count is zero, then proceed to the following

On my local installation of DB2 on AS/400 (BTW., how do I find out
which version od DB2 I have?) I have created these SQL statements:
CREATE SEQUENCE a.seq AS INTEGER
      START WITH 8955

We have deadlocks involving DELETEs, and I was hoping that
DB2_SKIPDELETED might be able to help in the short term.
I was looking at the following link:
"http://publib.boulder.ibm.com/infocenter/cmgmt/v8r3m0/index.jsp?topic=/com.ibm.c
mgmtreadmefp.doc/d104742.htm"

I have some DB2 tables where the primary key is usually unique, but can
be duplicate.
I want to find the duplicates only.
For example, suppose the primary key has these values:

I need to get an overview of all my tablespaces, how full they are, and
which containers are connected to them.
I know of LIST TABLESPACE CONTAINERS, but it's annoying to have to look up
the tablespace ID before LIST TABLESPACE CONTAINERS can be used. And LIST