Hello, When I use db2exfmt to generate the explain plan, under the
Operator section I can see the following arguments listed
[1] EARLYOUT
[2] FETCHMAX

I'm integrating a database server running Linux and DB2 V9.1 into an
LDAP based authentication system.
Unfortunately, this will include changing the location of the DB2
instance home directories (it remains the same physical partition, it's

After setting the netbackup, it is found that there is below error.
SQL2062N  An error occurred while accessing media
"/usr/openv/netbackup/bin/nbdb2.sl".  Reason code: "513"
DB version: v8 FP14

I wish to put a number of .db2  scripts in my makefile. However,
some of the db2 scripts tries to revoke privileges from users that
might do not have that privilege already, thus returns an error to
the

DB2 LUW v8.2 FP 14  RHAS 2.1
Not trying to start a flame war or anything, but does anyone have an
opinion regarding whether to use Raid 5 or Raid 10 w/ DB2?
We have an EMC SAN (a Clariion CX600 I believe).  My SysAdmin and I

I'm CERTAIN that at the last place I was at, I had a way to update
syscat.tabconst and set "enforced" to "N" and back to "y" to allow imports
of RI dependant tables.
The steps were :

My company is switching from Microsoft SQL 2005 to IBM DB2 UDB 9.1.
I've been playing around with the environment on and off for about two
weeks now in my spare time, and have a bunch of questions. I've read
through this group, it has helped a bit, but I'm definitely still

diff -u /home/system/db2inst1/nya/bin/db2filter.py ./db2filter.py
--- /home/system/db2inst1/nya/bin/db2filter.py  2007-01-12
15:23:34.000000000 +0100
+++ ./db2filter.py      2007-04-14 02:31:58.000000000 +0200

I see a bunch of packages where valid <> 'Y'. What I cant figure out is
how to relate the package to a procedure, function or whatever. Does
anyone have a reference to share on the relationship between, say
syscat.packages and syscat.routines. If anyone have sql for this I can

I am trying to collect a few examples of SQL queries that were done
with a "procedural mindset" and another solution done with a "set-
oriented mindset".  I have a short article at
http://www.dbazine.com/ofinterest/oi-articles/celko5

Hi every,
   Recently I'm translating some SQL Server query into DB2 query. But
some problems blocked me. Who can help me?
1. How to set a null for a new column in DB2?

I think I am not the only one to have some problems to access online
Information Center ... It would be nice to have a service that responds
quicker, without interruption, that is I guess the minimum we can expect
from an "Online" help. Sometimes, it's (too often) terrible !

Recieved the message: SQL0954C  Not enough storage is available in the
application heap to process
the statement.  SQLSTATE=57011
After viewing other posts, they recommended changing the applheapsz

Currently I am embarked on a project that requires me to define and
pass array to stored procedure, and I found out that there is no
direct way to do this. I wonder if a combination of UDF and java code
should be able to accomplish this. Has anyone accomplish this before?

  I am having a requirement to create a db in 2 out of 8 partitiones.
I have the following doubts.
1. should I create a new instance in 2 partitions alone (the present
instance spans 8 nodes)