I am right in assuming to recover a database where logretain is on.
That I only need the logs that are reported in the list history.. for
instance;
db2 list history backup since 20040228190050 for db trdb

I have db2 database installed in a Solaris machine. I am now running a
java program and trying to access the database.
I use java:db2//servername:portname/databasename  as the URL to
connect to the database.

hello..
i am tryin' to connect a java program with db2..while doing so, i am
getting the following error,
Exception in thread "main" java.sql.SQLException:

Hi when I try to run LIST ACTIVE DATABASES AT DBPARTITIONNUM <partnum>
or LIST ACTIVE DATABASES GLOBAL, I always get an error message. Does
anyone know why? I'm on v8 fp 5
output :

I tried to google "skip scan DB2" but came up with nothing.
Does DB2 have the feature under a different name?

We are a small consulting firm in the Washington, DC suburbs looking
for DB2(UNIX and NT based)experience. The ideal candidate is an
independent consultant that is willing to take on full and part time
projects as they arise. All projects are contract based. Extensive

In Version 7 there was a nice, brief manual called "SQL Getting
Started", SC09-2973-00. Is there a counterpart to this manual in V8.1 ?
N. Shamsundar
University of Houston

The SNAPSHOT_STATEMENT table function gives the CPU used rows read etc
information. How do I know the total number of time the particular
statement was executed (as in snapshot_dyn_sql's num_executions)?
Also, is the value "STMT_USR_CPU_TIME_S"  etc cumulative?

When doing a UPDATE on a very large table it can take quite a long time due
to the commit/rollback option.
Is there any way on the client side to disable the commit/rollback option so
that UPDATE will make any changes

Need a help in rewritting the folwoing SQL which is taking more than a
day to give resultset. Is there anything wrong in this SQL coding ?
SELECT DISTINCT 214 AS BATCH_ID,
               TAB1.customer_sk,

i am looking for a tool which could simulate many transactions to the
database, thus stressing the database. Also I am looking for a
performance monitor tool for database. Please let me know if there are
any freely available tools.

I need to create an application that will connect to DB2 on OS/390. We
have Websphere 5 with IBM HTTP Server 1.3.26.
I was wondering if there is any way to check that db2www is installed
with it or not?

i am a newbie of db2.
I need guidance in the following thing..
where can i find all the log files in linux (i am using db2 v8.1,
RedHat Linux v8)..specifically i am interested in finding out the time

we install a DB2 version about two or three times a month at a new customer
site. Installing the FixPacks is time consuming.
Windows 2000 or Windows XP or Windows 2003
DB2 Version 7.0 Server