I only want to do second join if the first was unsuccessful and was
wondering if something like the following would be valid:
select t1.*, t2.*, t3.*
  from t1

is there any way in db2 v8.2.3 (fp10) on aix 5.3 to know if indexes on table
are used.
The only method i know is to create an event monitor on statement and then
pass this worload to the design advisor. Is there a faster way.

I have just started working with DB2 Data Partition Feature.. Given a
table
name, how can I find out the partitioning key of that table? Is there a
SYSIBM.*

Is there a way to export the data from some tables, along with their
corresponding column names? I know I can use "export" command to export
the data from a table to a DEL file (the users need to be able to read
the file directly, which leaves the choice of a DEL file), but only the

I am trying to connect, at the same time, to a DB2 V7 database and to a
DB2 V8 database in Java.
Here is some sample code:
import java.sql.DriverManager;

I have just successfully installed DB2 8.2 under SLES8.2 and when
trying to create a new database I get the following error:
db2inst1@pjbrlnx:~> db2start
SQL6036N  START or STOP DATABASE MANAGER command is already in

Hi All !!
   I just want to know other's experiences in migrating from DB2 UDB
6.1 for Workgroup to DB2 UDB 8.2 Express Edition, is it possible to
migrate the databases ?  Will 8.2 Express accept to restore an 6.1

The following sql is expanded from an example from Tonkuma to my
complete application. It runs for over 6 minutes when my separate sql
statements wrapped with some PHP code can do the same thing in less than
3 seconds. For reasons which I need not go into here, I need to do this

Trying to do an offline backup (no database connections, no programs
running) shows an error in the db2diag.log as follows:
Obj={pool:0;obj:24;type:0} State=x27 Page=5728 Cont=0 Offset=5728
BlkSize=12 BadPage

Does anyone know how to correctly setup the Administration DB for fail
over clustering on a MSCS server running DB2.
Problem I have when I follow IBM's docs is that I install the Tools
catalog on the first node but when I failover the cluster to the second

I have 2 same windows machine, same instance configure and Database ,
all run DB2 UDB V8.1.5
Test 1 :
create table OUT_1 (LINE VARCHAR(350), LINENUMBER INTEGER NOT NULL

Running DB2 8.1.1 on AIX 5.1
We are trying to determine heavy hit tables for tuning purposes. We
have been able to extract information concerning the numbers of
inserts, deletes and updates for each table.

I need to submit some SQL statements through VB code via ODBC. My
question is can I submit something like:
DECLARE vOne VARCHAR(40);
SET vOne = ' World'

Moved a working MS Access application from Win2000 (version 5.0 SP 3)
OS with MS Access 2000 and DB2 Run-time client v7.1 FP 4 to XP (version
5.1, SP 2) OS with MS Access 2003 and DB2 Run-time client v8.1 FP 5.
This application has linked in objects some of which are Access tables

To come back to the online DB2 Information Center that is the only one
updated documentation, it should be nice that publib.boulder.ibm.com not be
down when we need it :-)
Regards,