I am getting this error while selecting some information from
syscat.columns in DB2.
DB2LEVEL is
db2level

Everything I read on DB2 indicates that the bufferpool is a pool of
database pages used to speed up database access.   It is controlled by
us, when we specify how many pages we would like to have allocated.
My question is:

  I am running DB2 version v8.1.3.88 on a Sun v40z server running
RedHat Linux AS 4 kernel version 2.6.9. My problem is that the
db2diag.log file is growing without bounds (I just deleted a 1.7
terabytes file!). I have tried setting the DIAGLEVEL parameter to low

I would like to retrieve all records from a table except these where
the (a, b) combination has one of a series of specific values. For
example, in MySQL I can given the table:
a   b

DB2 LUW 8.2
I need to have a combination of varchar columns, whose length is >1100,
as primary key, foreign key and unique index column.
When I try this, I get the error: SQL0613N  The primary key or a unique

Please explain tome why the third row of my result is not the fourth
row. In most Western alphabets 'dd'>'c'.

 SELECT t1.*,

If I have ESE 8.2.5, I assume v9 will be able to take such an
installation and upgrade same without problems ? [when available of
course]
I'm investigating whether we can also use Express C as a development /

IBM has a product for the VSE operating system called the VSAM Redirector.
It allows you to use VSAM to access RDBMS tables/views as if they were
actual VSAM files.  We're doing a comparison right now between Oracle, which
we've been running in production for many years, and DB2, ...

I just installed Express C and am getting the following messag
erepeated every three minutes, can someone please advise or help figure
out what this is.
Cheers,

is it possible to create a 32-bit DB2 V9 instance on a p5 box running AIX
V5.2 (TL09) with 64-bit Kernel?
The command that used to set the bit-width of the DB2 instance - "db2icrt" -
doesn't support the "-w" switch anymore and instead uses the system

select 'y' value from sysibm.sysdummy1 where 1=1
union
select 'x' value from sysibm.sysdummy1 where 1=2
Why is it that this will not return 'y'.  It seem to return nothing

Hey guys quick question:
Ive got the following trigger and error message Im having problems with
CREATE TRIGGER DB2INST1."AI_DOPORDM0" AFTER INSERT ON
DB2INST1.HMILDVL1_MCCSDTA_DOPORDM0

Ive got a script Ive built which runs reorgs on all tables needing it
based on output of reorgchk.  The reorgs are ran inline.  This past
weekend, the reorgs were running against 450 tables on a database that
is about 250 GB in size.  The reorgs took all weekend and  bled into

Hai everyone....
           When i am trying to access the DB2 from Crystal reports
10.0 in windows Operating system it is giving me the following
Error................

We have a user who is trying to generate a report from a db2 database. He is
using a tool from a third party vendor, where he first designs the report
and the tool then generates the SQL from the choices made by the user. When
this report is generated in our test environment it ...