At one of the clinets I am working with, we are having a debate about
the use of MQTs or go with traditional way of creating aggregate
tables and populating them. I would go with the MQTs instead of the
traditional way.

Can anyone help me to slove this problems :)-
Message form db2diag.log, it happen every min.
Thanks
AK

This is the first simple SQL PL stored procedure that I tried on UDB
(UDB
PE on XP):
CREATE PROCEDURE SQLSP1

I am posting this message through Google groups. It has been my
experience that my messages appear on this Google group, quite a few
hours after I have posted them. Sometimes, what we need is an urgent
response, which is obviously not there because of the time lag between

I have the following question.
As a join clause on Oracle we use " table1.field1 = table2.field1 (+) "
On SQL Server we use  " table1.field1 *= table2.field1 "
Does DB2 have the same type of operator, without using the OUTER JOIN

We have just managed to compile our first stored procedure. It took us
some time to do this as we had to figure out, that we need to download
the DB2 Application Development Client and later configure a C
compiler for Building DB2 Stored Procedure.

DB2I.PROCEDURE1 - Build started.
C:\SQLLIB\java\jdk\bin\javac -classpath
".;C:\SQLLIB\java\db2java.zip;C:\SQLLIB\java\runtime.zip;C:\SQLLIB\java\sqlj.zip"
"PROCEDURE1.java"

I´ve a problem. I have two  diffrent databases. And I want to update
database B with database A. But when a column is missing in the B it
won´t be insert with the update of A. Whole tables will be created but
not columns.

Dear DB2 gurus,
I have currently being trying to find any organized
documentation/checklist/guidelines pertaining on securing DB2 in either
Unix or Windows environments. After reading all of the redbooks and IBM

This is my first time with DB2 UDB
We have installed the DB2 UDB v8.1.3 Enterprise Edition.
We need to write Stored Procedures for our Project, for that we found
that we need to install the DB2 UDB Application

I have a problem while colling the dxxGenXML() method. I got the
following
error:
SQL0301N  The value of input host variable or parameter number "1"

Is there an Admin API specifically for DB2 on OS/390 ? I know that
there is one for UDB on Win/Unix .. I need to get database/subsystem
configuration params from my application. Any help/pointers would be
greatly appreciated..

I am reading a book called adavanced db2 dba certification guide by
Thomas Phan..this is the only db2 book available in india..There they
are talking about tablespace reblance when a new container is added to
a tablespace..I am not quite getting it..what does the DBA have to do

Is this possible to use embedded SQL for external C UDF?

I ever remember there's some question very similar appeared some days ago,
but I failed to get the final answer.
update DB2 7.1(WSE) to 8.1(WSE) on R6000, after backup and install the 8.1
DB2, when try to restore the database we met with error below: