Consider a scenario of (let's say) total of 8 MLNs.
How can I change BP size (which is defined over all of these 8 MLNs)
on one particular node (or subset of nodes). I understand that there
are bunch of way one could achieve this.

I'm getting soo frustrated...desperate...depressed...
Have installed DB2 v8.1.0.36
Been writing some stored procedures, and when trying to build them, I
can't get db2 to understand that I have Visual Studio 6.0 installed. If I

just downloading FP7, release notes have this as v8.2
does FP7 include all of the stinger features? in particular CIO support for
AIX 5.2.

Is "MERGE INTO..." statement allowed to be executed in a dynamic SQL
statement, inside an SQL Stored Procedure?
I am using DB2 UDB 8.1.2 on Windows.
If it is not allowed (as I suspect), how do I go about converting an

Any ideas on why my the result 'green' row
column DELTA does not yield -1 for?
That is not how I expected COALESCE( ... )  to work.
Every other row for DELTA (including 'black')

I have two tables :
CREATE TABLE animals
 (
  BHID             BIGINT          NOT NULL,

Does COM.ibm.db2.jdbc.DB2DataSource, (which supports connection
pooling) need to be run within a J2EE container environment before the
connection pooling facility is actually available to a user?
Thanks John

DB2 users - I have recently acquired some new job responsibilites that
require a basic understanding of DB2 - any advice on a book or primer
that would be useful for a general introduction - I am not an engineer
but have a fundamental understanding of distributed computing.

Sorry for my bad english, I am french speaking
..
I have been tasked to write a UDF in order to return the maximum value
of an integer column in a given table and increment it by 1.

I was wondering if there is a way to determine the tablespace id of
each tablespace on a backup image.  I want to perform a redirected
restore  pointing the tablespace containers to different locations
than the ones defined on the backup image.

Id like to connect to a table in a different database in the same instance.
Create database db1
Create database db2
Connect to db1....

my db2 V8.1 stopped just without any reason. Now I am wondering where I
con find a log file which explains this behaviour... I cant find
anything in the instance directory.
The database is running on a Linux system

The V8.2 Information Center states "udf_mem_sz : UDFs no longer pass data in
shared memory, so this parameter is not supported". But you find some
programs displaying the udf_mem_sz still as a DBM CFG parameter.
I have tried to search more on the support site, but I get "No results

We're having some problems trying to get the Control Center app working
across a firewall.
I've opened up TCP port 50000 as per the instructions I received, but I'm
still not able to connect. Are there any other ports (either TCP or UDP)

He have an AIX box with Version 4.3.3 and DB2 V7.2 FP6.
We need to upgrade the AIX to 5.1.
Does DB2 need to be reinstalled. Are there DB2 installation images
specifically for AIX 5.1.