In my application I'd like to let the user run SQL snippets like:
BEGIN ATOMIC
       DECLARE X BIGINT;
       SET X = 3;

I just downloaded DB2 Enterprise Server Edition evaluation copy.
Installed on Windows 2000 professional.
I want to test 1 physical machine with 1 logical partition.
db2start dbpartitionnum 1 add dbpartitionnum hostname myserver  port 1

DB2 V7 FP14 running Linux.
Our application constantly tests whether the database connection is
still alive before sending new statements to the DB. A "values current
timestamp" statement is issued and, if there is no database exception,

Hi NG,
does IBM Universal Database 8.2 make any difference between actual and
estimated execution plans like in SQL Server ("set showplan_all on" for
estimated execution plan and "set statistics profile on" for actual

I wrote an application that takes snapshots using the snapshot monitor
API (db2gGetSnapshot and db2GetSnapshotSize), every now and then these
methods fail and I get SQL1024N error (A database connection does not
exist.  SQLSTATE=08003).

We're getting ready to roll out a windows server 2003 box running DB2
8.2.2 Express on it.  I'm wondering what special considerations I need
to take in order for ntbackup to correctly back up the system and what
I'll need to do to correctly back up the database.

I need to create a report by extracting data from a table. I am using
the utility EXPORT to pull data from table to a file.
I will need to get the column heading and also if I want to add some
text and report date ..etc

Description of the DB2 Connect problem:
Users of two LTC client-server applications are experiencing intermittent
disconnects from the mainframe. Users of the Retail Workflow application
and the Group LTC Care application are experience SQL errors after

I'm searching for way for to trace currently processed
sql-queries on a db2 instance/database.
I`m searching for a tool which has the following capabilities:
- show a list of all executed queries in the last <n> minutes

I posted this on other user-groups.
Hardly got any responses. Here goes the question:
PLATFORM = DB2 UDB 8.2+ on AIX 5.x, DPF
Two Topics broadly:

I am trying to write a Wrapper for our web wrapping engine, Cameleon.
Currently Cameleon is able to answer certain SQL queries but with a
restriction that all SQL queries must have a predicate. This is very
similar to the BLAST wrapper. For example, Cameleon can answer queries

We're use DB2 with Data propagator. When I open Replication Centre no
config is shown (no capture or apply servers) but everything is still
working like it should. If I try to reconfigure, I get the following
error:

I am trying to create a server on the same machine running the same
instance.
This is v8.1.5 on Windows 2003 Server.
The instance is set to FEDERATED=YES

As I have already posted in this forum, my db2diag.log always shows this
message.
"SQL8017W  The number of processors on this machine exceeds the defined
entitlement of "1" for the product "DB2 Enterprise Server Edition".  The

Could someone confirm if the following reasoning is correct (64-bit DB2
on 64-bit AIX v5.3):
==================================================================
For each connection to DB2 db, AIX will reserve a 64GB shared memory