I have an INSERT stattement like this:
insert into ELIGIBLE_PAY
 select from ELIGIBLE_PAY_B
  where cust_id = 999999;

I am relatively new to DB2 LUW (v9.1).
I have been asked to prove the history of patches to the database.  I know I
didn't apply any (we started on fix pack #1), and that we are testing fix
pack #4, but how do I prove this?   Is there a hidden (or not hidden) file

I was trying to find the size of a schema (Size of all the tables in a
schema). Can some one tell me an easy way to do this. There are more
than 200 tables in my schema and it is very tedious job for me to
calculate each table size manually.

I would like to write an UDF function that returns table A or table B
based on a value passed as argument.
Something like:
CREATE FUNCTION my_func(my_value INTEGER)

DB2 8.2 Workgroup Server Edition is supposed to be limited to servers with 4
CPU's and 16 GB of memory. It can be licensed by user, or by number of
CPU's.
Are these limitations hard or soft? In other words, if the server with WSE

The DB2 development team has compiled a set of best practices for DB2
for LUW which can be found here:
http://www.ibm.com/developerworks/db2/bestpractices/
Feedback (completeness, too much, too little, consumability, ...) much

DB2 v.8.2. on Windows.
I'm developing with Borland Delphi 7 + DB2.
When my Delphi application (orders management) is running, i see that
my Application doesn't lock any table. (i see this with control

DB2 9.5
I keep geting the message.
SQL0101N  The statement is too long or too complex.  SQLSTATE=54001
When one of my sql statements takes over 60 seconds to compile the sql

I created one function and wish to assign it to some users. however,
even though
"grant execute on function"  succceeded, that user can still not use
it. i am wondering if

I am trying to find an efficient way to perform a special query.  Let
me explain what I want.
Let's say we are looking for all description that match "this is the
target".  In fact, I want to find records that match those 4 words in

<fe715a94-6138-4934-9ff7-aa4e4d2f5e7e@c19g2000prf.googlegroups.com>,
machineghost<machineghost@gmail.com> wrote:

I have a sql that goes like
select ............... from table (select ....... from table t where
<>) as x
Now this temp table x is supposed to keep 10 K rows at a point of

I am trying to get a SQL stored procedure to use user maintained MQT
implicitly which raises questions on when they are used or not used.
In theory you would expect the stored procedure to pick up the MQT at
the time it is bound on the creation of the static SQL.  This raises

Does anybody know why i get this error:
SQL0176N  The second, third or fourth argument of the TRANSLATE scalar
function is incorrect.  SQLSTATE=42815
with this query:

Running DB2 9.1 on Redhat Linux 4.1.
Storage management indicates that the pages stored in a file based SMS
container occupy 7 gig of the total space allocated which is 50gig.  I
wrote a script to reorg and runstat all the tables in the tablespace