Ok so I was using update to flip-flop some data in one of our fact
event tables.  It was chugging OK, but I thought it could have been
faster.  I ceased the update script and ran runstats on the table.
After it completed runstats, its updating even SLOWER!!!

We have DB2 EE version 7 and we are trying to backup our databases to
tape (up to now we were backing them up to file without problems) with
"db2 backup" command.
Our problem is that we get this error message:

DB2/SUN 8.1.6
I have a PROCEDURE that worked until i modified it by adding a FUNCTION
call in some of the queries. Then i started to get:
SQL0901N  The SQL statement failed because of a non-severe system

Given I have binary input which is to be stored in one table, and it
may consist of any size -- ie, VARCHAR(n) FOR BIT DATA, WHERE THE n is
less than 32K, or the n is bigger such that it is a BLOB ...
Given that I have a LOB table too, named LOBTABLE,

Hey All..
What's the easiest way to query all the tables that are in a integrity
pending state?

Dear Guru's
Can anyone please direct me to articles, documents or indeed help
explain in 'english' the benefits and advantages of using TYPEs,
HEIRARCHYs, TYPE TABLEs and METHODs ?

Begin Atomic
Declare  a integer;
Set a=(select count(1)  from claims.table1);
if a<>0 then

Running on Windows 2003 Advanced server I tried to configure
clustering with DB2 ESE (FP10) with the DB2MSCS utility. Defining the
cluster resources seems to be succesfull but the DB2 resource can't
be brought online.

I have graph
x y
- -
1 2

Hi to all Ng
Sorry for my bad english.
I have got a problem. I understand if a user try to update more than 10 row in a table.
So I think to create a trigger that by a row_count I 'll able to trap this event. for example

I have the following simple question:
Once connected to a database (possibly with an alias), how can I get
the actual database name?

I'm trying to change sequence name like this:
CREATE SEQUENCE seq_transid
    START WITH (VALUES NEXTVAL FOR transid_seq+1)
    INCREMENT BY 1

I'm going to use cursor load to load 200GB data in my production
database.
My database has 2 partitions.
but I cannot find more info in the manual about this cursor load.

I have a table defined as follows:
CREATE TABLE "LOGINS"  (
-- UID
  "PK_NUMBER" INT GENERATED ALWAYS AS IDENTITY (START WITH 1),

we have a little problem with the dependencies of an application (MKS)
that we want to upgrade to a new version.
The application now runs on a Suse Linux 7.3 system with 2.4 kernel and
DB2 7.2. We want to upgrade this application to the recent version and