Can someone confirm if the daemon to start is db2jstrt (or db2jd) on
an OS/390 DB2 host? I have read that this daemon is available on Unix
& linux hosts, can I expect to find it on OS/390 as well?
The DB2 version installed is 7.1.

I have a strange (at least for me) things happening. I am save the
result of an outer join into a file and I read this file and put these
values into a table.
The first row written contains the code page... how comes did I do

I have the following trigger that calls a DB2 stored procedure:
DROP TRIGGER GGWU.TRI_A_MULTI_PROP@
CREATE TRIGGER GGWU.TRI_A_MULTI_PROP AFTER  INSERT  ON
GGWU.MULTIPLIER_PROPERTY  REFERENCING  NEW AS POST  FOR EACH ROW  MODE

     Now this query is making me crazy. Working on it for almost 2 hrs
but no output
Query:
SELECT ACTIONEMAILTRANSID \

OK I'm trying to create a sql query on our as400.  I have a main table
like this:
acct prf      acct no.    sku
AAA           123           ABCD

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.
udb.doc/admin/t0005308.htm
it says that volatile tables (ALTER TABLE mytable VOLATILE
CARDINALITY) do not use statistics. I would just like to clarify this

Hello: We are trying to migrate DB2 Source: DB2 8.1 + Fixed Pack 5 on
Sun Solaris -> Target: DB2 9.X on Red Hat Linux . using db2move
command we are trying out the migration. However one of the tables
contains blob and clob data. What is teh correct way to move such a

I have created a table
CREATE TABLE testschema.player (
 country               VARCHAR(80)  NOT NULL,
 posn                  VARCHAR(2)  not null

my tiny PHP5 test application cannot establish a connection to a
database while I am able to connect to the same database using the DB2
command line tool.
Our server is 64 bit system running SuSE Enterprise Linux 10. The PHP

i am testing my DB for replication.
Now 1 of the table AA is having large records and
during its delete the corresponding CD table is just getting piled
up .

I receive the error code SQL0338N if I try to compile this statement
(part of the statement):
... left outer join lateral
(SELECT * FROM LIZSYSABA.VWZL0359TBS WHERE tbs_name = CASE WHEN

I've a question concerning DB/2, dates and Java-binding-Variables:
CASE WHEN MC.fixed_date_dat IS NULL
THEN ? + MC.rel_shift_NR DAY
ELSE MC.fixed_date_dat END

Hello, Help please,
I use a Cobol program, that based on a DCLGEN input, creates a DDL
file to create a test table.
Typically my DCLGEN's are just a few columns each. The Cobol program

I am running with DB2 UDB V8 on AIX.
I am trying to track down what appears to be a lock issue.  I turned
EVENT MONITOR on with all the options.  It doesnt give me the detailed
information I need for tracking who is holding the lock.  Here is what

i get the following error when running an embedded sql application on
Suse (powerPC):
SQL4903N  The length of parameter "runtime_pid" of function
"sqlastrt_trusted"