we are using db2 udb v8.1 , from db2 command window, how can i see the
value which has null in it? cause right now i only see it is blank,
not knowing actually it is a null value, i can only know it is null
value from other database tool, or from the program while reading the

Hey All,
I have searched the web for a definition of the following DB2 services
that are activated on my Win2000 server.
DB2 JDBC Applet Server

I have 1 database that is required for several applications (the data must
be shared ). They also have there own database. Is it possible to combine 2
databases into 1 database in DB2 7.x?

I have noticed something disturbing when retrieving datasets over a  
relatively slow line (multiple T1). I am looking at about 25 seconds to  
retrieve 500 rows via a php-odbc link. This same select from the cli is  
for all intents practicaly instantaneous. After much research I ...

I have an application written for version 8 that uses an INSTEAD OF
trigger, and I need to convert it to support someone that needs it for
v7.  Is there a way to achieve similar functionality in v7.  Here's an
example -

windows 2k with v 8 fix 5, eee set up
when I issue db2_all "db2 get db cfg for <dbname>", I get for each node:
<HOSTANME> : DB2 GET DB CFG FOR <DBNAME> completed RC=0
rah: <HOSTNAME>

The name change to Health monitor,
but when I use Health monitor, it show "Health monitor didnot start on instance"
How can I start it?
Thanks.

Db2 gurus...
 I am fairly knew to DB2.  We just migrated to it from Oracle (not
sure why other than money).  Anyways, we have a situation where one of
our test databases is performing very badly.  It is setup just like

when I execute a
INSERT INTO xxx(...)
SELECT (...)
FROM yyy

Please let me know, Could I get data from DB2 using command SQL: LEFT JOIN
and INNER JOIN in web application PHP?
Thanks
Marcin

The following is a piece of code from my client application which is
trying to call stored procedure SP1:
 String callstmt = "CALL DB2ADMIN.SP1(?,?,?)";
 CallableStatement clst1 = conn.prepareCall(callstmt);

We're starting a project at work moving VSAM to RDBMS. The choice
is between DB2 and Oracle. It seems like the Oracle RAC is a better
cluster choice with it's share everything rather than the DB2
share nothing. Please post some opinions on this and/or other

I am trying to see if backup taken at db2 V7.2 can be restore redirected on V8
any one faced this problem??
regards,
jag

hi, we are using db2 udb v8.1 on windows, if i have a query use where
clause where key > value, the explain sql gives me access path is
table scan, but if i do key = value, it uses index scan, so how can i
force db2 to use index scan when key > value to makes the query run

I want to create a new table based on an existing table, but I don't
want the tables to have any enforced relationship.  Is this possible
without having to do a CREATE TABLE and an INSERT?
create table customer_Temp