We ran into a very annoying optimizer problem recently. We had added a
new key and self-join relation to a large production table. That key
will be filled very rarely and having just being added was practically
never filled in when the first user tried to delete a row from the ...

After running db2setup for the first time, what is the best way to
create additional instances on the same host? Is running db2setup
again better or running the db2icrt CLI command better? Please inform.
Thanks,

I was given a heads-up about some security flaws in DB2, which are
"documented" at :
http://searchdatabase.techtarget.com/originalContent/0,289142,sid13
_gci1013055,00.html

I have got a problem with resizing the bufferpool of a DB2 v.8.2
instance.
The DB2 runs on an AIX 5.x platform.
Problem is that an "ALTER BUFFERPOOL ..." command is not persistent if

Is it possible to see all kinds of executed SQL-statements in a logfile? If
yes, how do I do that and how much information does it log?
Thanks, Kenneth

Is it possbile to replicate two ways to keep two tables in sync, where
inserts, updates and deltes may applied to each table by different
applicaiton programs? Or would this cause a continous loop?

could anyone give me a clou about the above reason code?
(Database Version 7.2 UDB on a Windows 2000 Machine)
This is what i did:
<Begin-Quote>

Environment:
Linux version 2.4.21-15.ELsmp (bhcompile@bugs.build.redhat.com) (gcc
version 3.2.3 20030502 (Red Hat Linux 3.2.3-34)) #1 SMP Thu Apr 22
00:18:24 EDT 2004

Can I construct a restricted view and grant select access on it to a
user without granting select access to the underlying tables and views?
This seems to be an easy way to restrict a user to just 'his part' of
the database.

Here is a description of automatic client reroute in DB2 V8.2
"The automatic client reroute feature allows client applications to
recover from a loss of communication with the server so that they can
continue to work with minimal interruption. After a loss of

With which User-ID sends DB2 mails via the SMTP-Server?
I configured an SMTP-Server with "db2 update admin cfg...". But our
SMTP-Server allows only known users to sent mails. So I need to set up
an User-ID in our SMTP-Server. But I don't know which User-ID I have

I have a table whose rowsize is nearing 4005 bytes and I want to
increase the length of one column. I know I have two ways to do this.
I can either increase the tablespace pagesize from 4K to 8K, or change
the column from being a varchar to longvarchar. Which is

required to run/administer DB2 Connect?    I installed Version 8.1
onto AIX 5.1 and was able to configure DB2 Connect without any
problem.   I then did the installation on another box and the I
believe the DAS instance is causing problems.    Is it required to

I was so lost in Google Desktop Search last night, I kept on dreaming
about the endless possiblisties of Google Search Technology.
All DB-2 now needs is a Google DB Search Engine which will throw its
competitors years behind. So are IBM folks listening ?

DB2 WSE 8.1 FP 5
Red Hat Linux AS 2.1
(LUW)
I am looking to write a stored procedure