Greetings.  I'm trying to execute a DB2 command such as:
  SELECT         P.ITEM_NO,
                 D.FILE_NAME
  FROM              PRODDB2.PART    P

I have 2 databases in two different instances that I am doing one-way
replication to. I will be cold starting the replication when I first
initialize it. But I do not want the target table to be refreshed. I
have sychronized the capture side and apply side tables using export-

Is there a query from a snapshot table, or some other method, to
monitor that a database is using trusted context connections?  My
company is requesting that I run a report from our monitoring server
and report any non-compliant databases.  Any assistance would be

With Cloud Computing as an emerging style of Information Technology
infrastructure designed for rapid delivery of computing resources. Now
more than ever, you need to know why Cloud matters to maintain
business growth, streamline operations and deliver unique business

For traditional reporting, the dimensions of who, what, and when
(customer, product, time), are well covered, however, the "Where" gets
little attention.  Location Intelligence, the mashup of Business
Intelligence with GIS, brings visibility to the "where".

On my XP sp3 box, I tred to upgrade my DB2 Express C 9.5 to 9.71, but I
received the error SQL5055C during the DB2EXTSEC phase.
Now I  can't open neither the command center, nor the CLP, receiving the
same SQL error.

I installed DB2 9.5.1 a while back on Windows XP. After completing that
installation, whenever I open Firefox, I get asked which profile I want to
use for Firefox, my default one or DB2_LP.
Why did the DB2 installation create this DB2_LP profile and what is the

I have a Primary Key Index that has 11 columns in it.  80 million row
table.
The index is 100% clustered and has nlevels = 4.
We have an Update statement that should use this index but chooses not

Setup: 9.7.1 (64 bit) running on x86_64 Red Hat Enterprise Linux 5.4.
Often, when I take look at the list of applications, I see a session with
application name "db2lused" in a state of "UOW Executing". Example:
http://troels.arvin.dk/db/db2/db2lused/db2lused.txt

I have a query that returns the following results. We get multiple
rows back, with all the same info except for the Function.
ID    NAME        FUNCTION
001     Greg Johnson    Administration

A while ago I discovered a transaction that had been active for a long
time. The statement where against a infrequently accessed table, and
caused no problem except that the transaction log continued to be
active. So I started looking at how to detect such things for the

Setup:
- Server with data residing on an XIV storage system. The XIV storage
  system spreads data over all available disks with no knobs to control
  priorities, cache-pools, etc. (This is by design.)