What is the IBM recommendation for the number of DB2-LUW databases per
instance on AIX?  With Oracle, it is one-to-one.  In DB2 multiple
databases can co-exist in an instance but is this recommended?  What
should be considered in making this decision?

I have a big table (20M rows) whose primary key is composed of 2
columns.  The other 10 columns are all double values.  The queries on
the table are mostly aggregating on the value columns.
In order to improve performance, is it a good idea to add all the 10

A while back I raised a discussion ( http://tinyurl.com/4h3qg7 )
regarding SQL1084C  Shared memory segments cannot be allocated. We
still have this problem, so I thought I should bump the thread.
Current status:

We are reviewing database container design where the storage layer is
an EMC DMX 3 Raid 5 San.
The SAN comprises multiple raid 5 arrays, four disks in each array.
We have been allocated 8 gig virtual hypervolumes(LUNS) each mapped

In 9.1 and 9.5 (Linux 64 bit) when a buffer pool is set to self-
tuning, how are blocks configured in respect to blocked vs non-blocked
when self-tuning is set to on?
(ie) I have one bufferpool that is 16k that the IBMDEFAULTBP is shared

People,
Environment: Linux AS4
I have just installed db2 v9.5  +  Fixpak 2 on a machine that has db2
v8 up and running, but I am unable to create and instance:

I have a file TABLE1.IXF and want to know how many rows are in there.
How to do it?
Thanks and best regards,
    Kovi

Good morning,
I have a table like (Date, Hour, Value) where Date can be any date,
Hour is always between 6 (6am) to 22 (10pm) and Value is an integer.
E.G.

Changing the DB2 interface language requires to change the regional
settings of Windows. Is there another way?

I have 2 tables:
OLD_FAMILY
SSN                NAME
-----------------   -------------------

I have a question (dont know if its dumb or not) related to how DB2
manages connections. Can I have two active java threads use a single
DB2 connection at the same time. Is it possible to have two
independent statements running on the same DB2 connection at the same

Will flush package cache dynamic executed from a client flush the
package cache on the remote server and how do I check.
e.g.
connect to remote aix server from windows client.

Indexes cause inserts/load to slow down.  Is there anyway to drop
indexes on one partition of a partioned table?  From what I read this
is not possible.  I know Oracle has the option to disable local
indexes.  Is there anything similar in db2??

Just want to confirm, for a given RAM size on a server, if we increase
the sheapthresh, we have to decrease bufferpool size (keeping other
parameters same)? Please make it clear , i am new to db2. Thanks in
advance

I am running dpf on v95.
when checking my query plans, sometimes there is a "^" symbol before
the operators,
for example   Hashjoin becomes "^Hashjoin".  I am wondering if this ^