We are using DB2 v8.2 and are planning to migrate to DB2 v9.5. The
settings of our servers are as follows:
OS: WIN (4 servers) , AIX(1 server)
RAM: 3GB

Does someone happen to know the last version of DB2 running on Solaris
8?
I planned to install V8.1 FP12 (need to setup a test system that's
similar to the productive one), but that doesn't work.

On a z/OS DB2 v8 platform, this refers to formatting a SMALLINT field as
two zoned-decimal (character) numerics, with a leading zero when there
is only one significant digit.  I tried several different CAST formats
with no luck.

I have to move a 40 GB database from one windows server to another.
The db has
logretain = recovery
userexit = off

We have a stored procedure that dynamically builds a sql statement.
Is there an example of how to get the SP to return the result set of a
dynamically generated sql statement.
here is an oversimplified sql statement - just to prove the point:

  im not a db2 person, please forgive me for asking a simple
question..
i would like to restore a tablespace from a current database to a new
database in the same server how do i accomplish this task.  I use tsm

Is it true that the following query:
   SELECT emp.empno, emp.lastname, dept.deptname
    FROM emp LEFT OUTER JOIN dept
         ON emp.workdept = dept.deptno

I found this query on older thread and i can not uderstand output interval
pairs:
How to find min and max values in date intervals:
--------------------------------------------------

Friends:
I'm in the unenviable position of having to retrieve rows based on a
deep-dive into a CLOB, searching for a particular constant.
I've tried different options of predicates and their placement, and

We've noticed NULLID.SYSSH200 has been executing on the mainframe like 500K
times a minute. What is this thing and what would make it run so often? It is
causing our SMF history to be useless.

I run this 2 queries on my Home PC - DB2 9.5C
EXPLAIN PLAN SET QUERYNO = 1 FOR
SELECT * FROM STAFF
WHERE ID > ?;

Running db2 8.2 ON aIX 5.3.
We have a third party USEREXIT program that periodically hangs for
some unknown reason.
Db2 generates error message to the diag log.

we are building a Java webapplication using JSF, running on websphere,
querying a DB2 9 on Suse Enterprise 10. The app uses JDBC and
PreparedStatements only (aka dynamic SQL). Every night, there is a ETL
which deletes most of the data in the database and fills it all new.

I  got a dumb question on the merge statement.  I read the following
example of merge statement at the IBM page:
http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.
udb.admin.doc/doc/r0010873.htm:
 MERGE INTO archive ar