http://www.ibm.com/software/data/db2/9/
DB2 9 Express C should be coming online soon.
Hope to see you there soon :-)
Serge

I have a parent table(x_orders) and a child table(x_orders_contents)
with a cascade delete on the child table. In a after delete trigger o
the x_orders_contents table I'm updating a field in the x_order
corresponding row. This works when I delete a row directly fro

I tried
http://www.ibm.com/developerworks/forums/dw_forum.jsp?forum=805&cat=19
to access the Express C forum, but I got no content and no timeout.
I wanted to search for a problem with install of Version 9.1. When using

when i run db2 get snapshot for bufferpools on <db_name>,
it shows "NOT COLLECTED" for most of the parameter, what could be the
problem.
is there any register variable or parameter to be enabled??

Dear Friends
Let me explain my problem clearly
1. My Database is running on DB2 v8.1.10.812 Fix pak 10 on Windows 2000
sp1

How to get the list of all users/clients who are connected to my DB2
UDB database v 8.2 server in RHEL?
Please help me out...

Hi all. I would like to know what the fastest, lightest weight
query/SQL a client can send to the DBMS. I want to do this
occasionally from a Java client to verify the current health
of an otherwise idle connection. In Oracle we can select from

Friends:
I have a stored procedure declared as:
CREATE PROCEDURE X.Y
    LANGUAGE SQL

DB2 8.1.3,Windows
I have 2 databases in a single instance, say DB_1 and DB_2.I need to query
a table from DB_1 in DB_2.I am try to use a nickname for it.But nickname
creation is not possible until federated server is made.Please tell me how

I need to execute a set of LOAD commands non-interactively. I used the
following:
db2cmd /c /w /i  db2 < ./db2audit.txt >db2audit.log
This db2audit.txt contains db connection and load command. But somehow

I'm getting the following error when creating a table with 250 columns
. I have tried creating it in a 32K tablespace , still the same issue.
Is this a limitation in DB2? I am using DB2 v8.2 FP 9a.
SQL0670N  The row length of the table exceeded a limit of "32677"

if I accidentally use a TAKEOVER command with BY FORCE clause while
primary and standby are in peer state I'll end up with two primary's
(at least with FP10 and Windows). Is this works  as designed or a bug ?
Manuals say that the standby will inform the primary about the takeover

Is there any command to get the size of a DB2 database?

DB2 V8.2 (not Viper yet and no range partitioning!!)
I have created a table T1 (col1, col2) with col1 as the primary key.
When I try to create a partitioning key on col2, it gives me error that it
should have all primary keys included.

How do I (syntax please) write a query which returns the invoice header
data and the amount due which is the SUM(qty*each) from the details rows
with the same invoice number for all invoices in the header table?
create table invoices(