In 32 bits DB2 environment, is it meaningful to set sheapthres larger
than 256MB for the following case..
1. Intra-parallel is ON
2. Intra-parallel is OFF

(Thanks to Bernd, Ian, Phil last time for their detailed answers last
time)  Now I try to call JDBC driver
without giving the username and password as they suggested. I am using
DB2 jdbc on SunOS 5.8  with db2 version  7.2.0.  When I am using the

ENVIRONMENT:
============
(1) AIX 5.2 ML 8 and AIX 5.3 TL 4.
(2) DB2 ESE on some servers and DB2 Connect Enterprise Edition on

I'm new in db2, I'm trying to execute EXPLAIN command on some queries
but i have error like: [Error Code: -104, SQL State: 42601]
[SQL0104]
And message similar to: Token EXPLAIN is not valid, valid tokens ( END

We are attempting to load a DB2 v9 table with SQL Server Integration
Services.  The DB2 data exists on AIX and is built with a codeset of
1252.  The SSIS server has the DB2 V9 client and we are using the OLE/
DB driver.  When we try and connect the two SSIS insists that we have

Ok Guys you have to bear with me, I'm winging it abit
Im installing DB2 8.2
I need to have 8.1 FP10
8.2 is 8.1 with FP7

==============================
The agent private memory set consist of the following memory pools.
Their sizes are specified in the database configuration parameters

I'm interested in the application handle the session has.
Is there a way to return it (UDF) so I can protocol it into a table
(or something like that)?
e.g. "values myapphandle()"

 I have a simple question. In db2 v7, AIX platform, is db2wdog or
which process is responsible for restarting db2 automatically in case
of a instance problem?
 And in the case of db2 process being restarted automatically by

could anyone provide me with a link or information if there exists a
WebApp I could deploy to a WebSphere Server and connect to a DB2 using
DB connections provided by the WebSphere Server? The interface should
give me a command line or something to write my own SQL-Querys, send

Hello world,
my program connects to a db2 database and needs to find out the column
names and data types for a specific table.
The code works fine with mysql and derby, but returns an empty

When using embedded SQL for db2 under solaris, you do not need to give
username and password since the system will use your unix-login as
default credential. However, with JDBC seems I always need to provide
username and password, the Java API

i do ve doubt in following
my old dev server (winnt,db2 ver7.1) has upgraded to win2003 and db2
ver 8.1
all the scripts are running fine

I am unable to start the 'db2fs' after successful installation of Db2
Express-C software on `fedora Core 5`. Before that I installed Java
JRE from Sun in "/usr/java/jre1.5.0_11/". I also issued below commands
as instance owner...

Is it possible to invoke a stored procedure from a jdbc statement
interface?  are there any
examples on that topic? thanks