I have a table which is partitioned on 4nodes. I've loaded some rows
into this table. How do i view the "table data" partition-wise ?

I've put together a few SPs to produce a BOM (bill of materials)
listing, which together use a couple of global temp tables, and return
the results from a cursor. Here's the code:
-- Initialize the temp tables............

I was doing a load into a table and it was taking way too long
(previous loads took 20 mins, this one was at 3+ hours with similar
number of rows) so I tried to cancel it.  After clicking the cancel
button in control center, everything pretty much hung and I had to kill

Can anyone suggest me how to determine the optimised size for the
following:
1.Extends
2.Tablespaces

There are two packages for download (Linux):
DB2 9 client (240 MB)
DB2 runtime client (105 MB)
What's the difference?

Can't seem to figure out how to do this and have been reading for some
time now......
I want to select a row count from a table name in SYSTABLES.
This statement does not return what I needed, but can help explain what

Friends:
Say I have a simple table like so:
REGION (CHAR(3)
SSN CHAR(9)

I'm trying to call one stored procedure inside another.
I was wondering if this is possible
Some ideas I was toying with is putting the first stored procedure
inside of a temp table but haven't been able to get this idea to work.

Can someone point me out a function that return the multiplication of
all row contents from a column?
It should work like the sum() function, but instead of the summary.. it
will return the chain multiplication result. Here is what I need it to

I would like to ask if there are any differences between DB2 in these
versions (e.g. support of triggers, Java stored procedures and such).
Also, does anyone know from which DB2 AS/400 version is Java officially
supported?

I have an annoying problem on a particular server.
DB2 V8 FP12 on Windows 2003.
The database is catalogued on a local drive.  From the CLI a connect to
the database without the userid/password works fine.  When connecting

Can anyone suggest me a link for more info on db2 parameters and
performance optimisation.

1) Is it possible to force the join order of the tables in a  query
(similar to "hints" in Sybase, etc) ?
For Example,  I am joining 3 tables - A,B & C in my SELECT stmt,  and I
would like to force the  optimizer to always join A & B first and the

What is the quickest way to drop all the foreign keys in a database?
Only FKs, not PKs.
Cheers,
San.

Is there any command (alter table ...?) to drop 'Not Null' constraint
on a column? I have a column CODE which has 'Not Null' constraint
defined and I want to drop 'Not Null'. Please let me know.
Droping the table and recreating would be my last option...