In my shop, we have database in diverse platforms like mainframe,
Linux, Windows 2000. We are planning to consolidate all iDB in a single
platform and build one big monster DB, this monster DB is going be a
DB2 UDD V8, running on Linux server.

We are about to use Clustered Environment in db2 v8.2 .I have a few basic
queries about it.
1.What are the system software requirements for cluster environment?
2.How to configure database for cluster / distributed environment?

I'm using DB2 PE v8.2.3 for linux.  I've defined a database with the
following schema:
ANNOTATION(ID,AUTHOR,TEXT)
ANNOTATION_BOOK(ANNOTATION_ID,OBJECT_ID)

I have a problem with simple query like this (PK - Primary key)
select  t1.*, t2.col1, t3.col2
from
    T1

I wonder if there is an sql command that increases a sequence value by
one and returns such a value.  I would like to manage an id inside a
program that connects to the database through jdbc.  I know that there
is a command like:

Hi DB2 gurus!  Question for you all.  Is the following possible (mainly
the last two bullets)?
*  Already have table called XYZ of information keyed by SSNs.
*  Create an xref table for SSNs to employee numbers.  We'll call this

I have db2 client installed in my machine.I wanted to see which client it
is-Runtime or administration or application development client.
Please tell me how to ensure this. I tried using db2level but it showed me
this information.

DB2 documentation refers to a interesting way to integrate with
Directory Server technology.
Does anybody have experimented/experience with it?

I am running a stored procedure in a loop -- this Stored procedure
inserts one record at a time.
After inserting about 1326 records, my thread crashes and I get the
following error:

I'm quite new to DB2. I've created a db scheme with DBDesigner4 and then
I created an export file with all the sql statements. Now I'm wondering
if at all and if yes how it is possible to create tables from a sql
dump. Or should I use other tools?

I have the opportunity to get UDB training however, It's all OS/390 and
I am using DB2 on Unix. I really have no idea what the differences
between DB2 on different platforms is. If I learn the optimzer and
tools on one platform, is that knowledge transferable?

We are on db2 udb v8.2  64 bit,partitioned (5 nodes)
on AIX 5.2 ( intra parllelism is enabled).
I have a question, i am trying to find the memory usage on my
production machine, we 32 gb memory and the memory used bufferpools is

I installed DB2 in Linux OS. I tried to create database and I am
getting the following error message:
SQL0444N  Routine "db2spcat" (specific name "SQL060216094049640") is
implemented with code in library or path

I am receiving what appears to me to be an inapplicable message from the
query below. The message is also below. I see no VALUES clause nor a set
operator (INTERSECT, DIFFERENCE, UNION) in the query. What am I missing?
SQL0415N The data types of corresponding columns are not ...

Sorry if my question is elementary. I've searched google, but can't
seem to find exactly what I'm looking for.
My client is using db2 8.2. They have 2 companies and each company has
a different database running under the same instance. I have created a