Is SSL protocol in LUW only supported for IBM DB2 Driver for JDBC and SQLJ
type 4 ?
I want my NATIVE DB2 client to connect to DB2 server using SSL protocol (not
using SQLJ/JDBC)

I didn't know how to title this post because I can't think of a name for
what I am trying to do.
I have a table calltrak.calls which has a row for each call a customer
makes.  I want to return all of the rows only for customers who have made

DB2 V9 runtime client acessing a DB2 UDB 8.2 FP 15 on LUW
According to this thread: (http://www.dbtalk.net/comp-databases-ibm-
db2/running-long-statements-java-c-406862.html), we could execute
statements with up to 2MB size.

Has anyone any experience in using SolidDB as a cache for DB2? I'm
mostly interested in how much - if any - sql that had to be rewritten
because it was not supported. The database I'm considering is small,
but the queries against it involves CTE's, OLAP functions etc. I'm in

In oracle, there is a performance improvement if scalar subqueries are
used instead of joins. Does this hold good for Db2 (8.2) too?

I have the following trigger:
--#SET TERMINATOR !
CREATE TRIGGER CROSS_REFF_TRIG  
   AFTER INSERT ON NEW_CATALOG

can we create 1 new db on a machine where only db2 client is
installed. I want a db on local also ... any suggestions for that
Thanks
sandy

Hi , all
We have hundreds of tables in on tablespace ,
but I'm planning to change as one table per one tablespace. .
I wonder how  other shops does ?

What is the syntax to overlap partitions?  Lets assume I want a year
split amount 4 months (3 partitions for a year) and later adding an
additional set of partitions for every 6 months.  Plus giving us the
option to detach old partitions.

sysproc.snapshot_tbreorg  result shows me REORG_STATUS as '4'
Does anyone know what does  it means ?
Regards
Myoungsoo

I want to create and populate a temporary table into a DB2 database from
a Java web application. This is all fine and good and works. However, I
would then like to reference the temporary table from a Stored Procedure
from the same connection.

I have a solaris box on which the LDAP authentication is configured. I
have installed DB2 on it . I have granted connect privilage to a LDAP
user. When i try to connect to the database using that LDAP user it
says User ID not valid.

Hi Everebody:
I have a table:
CREATE TABLE CROSS_REFERENCE
(ROW# INTEGER NOT NULL

with db2 snapshot I know the lock waits number but I can not see the
tables with locks an I can not see queries that produces locks.
How can I know those details?
Thanks

I'm on  DB2 9.5.0.1  on Linux AMD 64 and the database has four
partitions
where catalog is on partion 0 and  user data on 1 thru 3.
After a load failure (path to load file was wrong) I cannot access the