Maybe this has been asked and answered - but I have been looking through
old archives for quite some time....
Typical Java app running from Websphere connected to DB2 V8.2FP15 on
Linux using JDBC Type 4 drivers. Programmers use mostly PREPARE/EXECUTE

Hi, Friends,
I need to know how to stop all database process even after db2stop.
How can I stop all database processes?
I have finished upgraded our system test and UAT region from 32-bit to

I did a test on running db2 database java code on 32-bit and 64-bit
db2 instance.
It seams that java application with 32-bit JVM couldn't run at 64-bit
db2 instance.

I have some questions about DB2 range parition and I cannot find the
answer from the document.
1. Can I name the partition name for every partition in a range
partition? For example, p2008jan for data of Jan, 2008?

I would like to copy a row from one table to another (this is a
simplification of the real problem).  I do this in a stored procedure
where the output parameter is the last row's identity value.  Here is
a snippet:

I was expecting the following statement to return the hex value of
10010000. As you can see below, it doesn't. Any idea why not?
$ db2 "select hex(268500992) from sysibm.sysdummy1"
1

Guys,
For several reasons, I have a RedHat Linux AS4 64 bits SO, with a DB2
v8 FP15 installed with a 32 bit media (CDROM).
I do have access to 64 bit DB2 media, and need to migrate this

Is it possible to run DB2 8.2 on AIX 6.
Thanks,
Sam.

In my installation we have DB2 on a mainframe computer. I am able to
access DB2 from my PC (WinXP) using some utilities. I wrote a Java
program to access DB2, but I am getting errors.
After command:

Can you please clear the details and fee structure of IBM DB2
certifications.Tell me the duration,material to refer and the fee
structure of full programme.
Thanks & Regards

Here is SQL_TEXT column in SQL_DATA TABLE:
SQL_TEXT      
------------------------------------------------------------------------
SELECT RC_L_NAME1,

Hi All;
I have tried to find this info on the IBM site, but alas... We are
running DB2 v9.1.1 and making extensive use of Information Integrator
(now known as Websphere Federation Server?!) to access Oracle and

OSName:   AIX
NodeName: dr_aixdb01
Version:  5
Release:  3

A connection is made to a z/OS system  and the following command is
issued.
db2 => call TESTDB.TESTPROC('STRING,99,?,?)
SQL0444N  Routine "TESTPROC" (specific name "") is implemented with

Is there a way to tell DB2 to continue on error and then to insert
tuples that don't exist in a table?
I'd like to modify the following SQL statement to do that. Executing
this statement results in a SQL0803N error.