If RUNSTATS is called directly, we can specify UTIL_IMPACT_PRIORITY to
limit CPU consumption.  For automatic runstats, there is no place to
specify this paramater.  Will it use the DBM value of UTIL_IMPACT_LIM?
Thanks in advance,

First some background, we are currently using V8.2 but is planning to
move to 9.5 for the next next release of our application (within a
year or so). In our development environment we have a lot of
databases. This is due to the fact that each developer can create a

I'm actually trying to extend Control Center with a plug-in.
I tried to add a new menu to the CC menu but i'm not able...
I've add a menu to a database-object but can't do it as a simple menu
when Control Center starts.

I have some indexes that I don't believe is being used.
What is the best way to determne if this is the case.

Setup: DB2 v. 9.5 on Linux (64 bit).
I'm loading a rather large amount of data from some import-/staging-
tables into some writable views which point to the end production tables.
A set of of triggers are attached to the views in order to perform

I just recently tried to use a multi-row insert on a table that contains a
timestamp column, but I get SQLCODE -180 even though I'm positive that the
value that I'm trying to insert is correct. The error message is : " THE DATE,
TIME, OR TIMESTAMP VALUE *N IS INVALID". Any ideas?

 Total Cost:       43.712
  Query Degree:     1
             Rows
            RETURN

Is there any additional information that can be retrieved using GET
DIAGNOSTICS other than DB2_RETURNED_SQLCODE, RETURNED_SQLSTATE, and
MESSAGE_TEXT?

In our change mgmt process, to production from test, moving PLI object
code + the dbrm file, part of the process is to confirm that the
contokens match. Years ago, the contoken string was identical.  Then
with a new compiler, the contoken in the object code was split in

Helpful folks,
We have recently migrated from V7 to V8 of UDB on Windows 2003. We are
now in the process of setting up a rollout deployment to upgrade all
of our user clent PC's from the V7 client to the V8 client using a

Here is my input table:
  TUE         MON        
----------- -----------
         2           -

I've a problem.
The query select mo_qta from oobjm.movoptittraded where mo_opzione =
'1,253CEUUS16M08' gives:
MO_QTA

I would like to know :
1.how to find all the schema in my DB2 database on Main frame
machine .
2. How to see all the tables for a given schema .

Consider the following SQL.  I expect the last column of the results
to contain a calculated percentage.  Instead, the column contains all
zeros except when the profit margin is negative,where I get a number
in multiples of 100 (300, 700, 1600, etc)?

This is an excerpt from the Oracle documentation:"...ORACLE SQL*Plus
BREAK command creates a subset of records and add space and/or summary
lines after each subset. The column you specify in a BREAK command is
called a break column which suppresses duplicate values. For example