SQL:  select talble1.c1
from table1,table2
where table1.c2=table2.c2
so if talbe1 has 1000 records,table2 has 100 records

I have a column in db2 with an index. When I search using LIKE
predicate,
sometimes it gives results very slow (about 3 to 5 mins). But after
the initial hit,

I have got:
SELECT char(week_iso(current date)) FROM sysibm.sysdummy1
+------------+

When executing the command :  db2fm -D
I received the error:
Failed to find the default instance. Environment variable $DB2INSTANCE
not set properly.

I have a query running on a federated database that takes the form
select col1, col2
from nickname1
where <conditions exist>

I Have problem connect to a database, it takes lot of time connecting.
So i took a snapshot and found out
Memory Pool Type                           = Lock Manager Heap
      Current size (bytes)                    = 176668672

I ran the scripts in a file from Command Line Processor and it gave
the error for all the constraints being added, but not the indexes
being added.
For a simple statement like

I was trying to access www.ibm.com/developerworks/db2.  "Waiting for
www.ibm.com ...".
Performance download for Redbooks is not very good either.
Pretty pissed off because this happens many times.

Hi, all.
I'm running 8.2 on Windows.
This is a development platform for a project whose production
environment is running on a mainframe.

I am wondering if someone have done comparison of loading data using
cursor VS. Pipe.
Please share your experience. which one is faster ?
regards

I'm trying to create a before trigger to track who initiated Delete
DML.
I know I can grab CURRENT USER, but because of the way we have
implemented our software I have to know the OS ID. I know I can grab

I written simple stored procedure to delete in chunks and getting
error while creating it
can someone help what could be the issue  ?
=================================================

we have a table with many layers of hierarchy information (child-
parent-grandparent-grandgrandparent-grandgrandgrandparent-...).
Relationship built based on two columns (ID, and Parent_ID columns)
While the data model correct and allows us have data like this,

Is there an option with db2look to create the create tables only?
Looking to keep the primary keys / indexes out of the mix for right
now...

In my web application we are using com.ibm.db2.jcc.DB2Driver driver to
connection DB2 data base. Application is running on linux environment
App server is : jakarta-tomcat-4.1.29
when we execute a procedure we get following error..