DB2 WSE 8.1 FP5
Red Hat Linux AS 2.1
I have simple view definition like:
create view B as

Here is Mark Townsend's (Oracle Product Manager) explanation and
justification for posting in the DB2 newsgroup, as posted on the Oracle
newsgroup, and my response:
"Mark Townsend" <markbtownsend@comcast.net> wrote in message

My client is going through a large project to replace existing data
warehouse physical infastructure which is running DB2 8.1.6.  In the
past we had a much more distributed environment where we had certain
portions of the data warehouse on a physically different server.  We

we are using db2 udb v8.2 Express edition on windows 2003,we use third
party vendor software to help replicate one server to another.
Production server has three instances, each instances has one database
under it. So we would see three folders on D drive: DB2 folder, TEST

My apologies in advance if my terminology is slightly confused, I am
new to all this.
We have previously been running some SQL on DB2 (v7) utilising a type 3
driver, and have made the change to DB2 v8 with a type 2 DB2 Universal

I'm looking to purge rows from a DB2 table that contains both a CLOB
(1M) and BLOB (51K), but our DBA is not familiar with LOBs. I work on a
mainframe (z/OS), and we don't normally use LOBs in our shop. These
LOBs were set up by a vendor. Our DBA mentioned that a simple DELETE

I want to write
SELECT something FROM table GROUP BY hour(timestamp)
where "something" definitely has to contain "hour(timestamp)".
I get an error SQL0104N.

Hello, everyone.
Does anyone know what potential security issues when running DB2
services (start-up) using local system account instead of the DB2 admin
account?

I have 18 years of mainframe DB2, and I just starting working with UDB LUW
V8.1 FixPack 6 on Sun Solaris last week.
I have been dismayed on the lack of detailed info available in the manuals
on tuning and monitoring REORGS on large tables. I am used to the wealth

 Here are the two update statement.
UPDATE stock SET status=NULL, quantity=0, price=0 WHERE type <> 'S'
UPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE type
<> 'S'

I have been reading up on triggers and I am still unclear as to the
best way to accomplish the following:
Each row in table A has an account number field. After insert of record
1 into table A, if the value of the acccount number exists in table B,

I am using DB2 v8.1 on UNIX.
At times the database shows extremely poor performance.
I do not have dba/admin rights nor do I have the web based client for
db2 v8.1.

I have ntoiced something peculiar happening on our db2 instance.
It serves as the backend rdbms for a java application that is hosted on
websphere app server. The app server has a connection pool that can
grow upto 250 connection.

When I run the following vb.net code, I'm not able to acces the my database
AMFLIB.
I use to be able to access AMFLIB with the old ODBC driver from IBM iSeries
Access but now I want to use the new managed IBM.Data.DB2.iSeries data

 We have a database made with Java. The format of the database is the
same to DB2. We are concerned about the performance when the database
size growing. Our computer configuration is: windows XP, 512M RAM,
Intel P3.