Newbie question
Is there a way using SQL to see which tables use a particular
tablespace?

All,
I came across a strange situation in my query. Basically here is the
result of my query.
col1     col2     col3     col4  col5     col6    col7

When I explain the following SQL, the optimizer conjures up two columns
$C0 and $C1. It appears that they might refer to min and max values for
the range of values returned by the sub-select. Is that correct?
From the access plan graph it appears that, SIEBEL.S_EVT_ACT is the

I am facing a problem whle importing the DEL files ( encoding: Unicode)
into a Unicode database.The DEL files have French Characters.I observed
that the French Character é has been converted to é.
To avoid this conversion, I used MODIFIED BY CODEPAGE=1208 in the

So I've updated the alternate server on our db server.  What do I have
to do in order for a remote db catalog to pick up that remote server?
DB2 won't allow me to update alternate server on the client side.  I've
read something about LDAP being involved, but I'm not sure where to

I am having an issue where inserts are taking a lot longer than I would
expect.  So far it seem that it is just the first insert. (Although, I
have other people telling me it is happening more than just the firs
time)  The times for a single insert are anywhere from 2-10 seconds.  I

How can we find which SQL statement is executing when "list application
show detail" shows "UOW Executing" against an application.
This topic was touched upon earlier by one of the member. That time
responses were to use SNAPSHOT Monitor and a tool called db2top which

hi all. im having a problem and wondering if anyone an help. i have the
following tables along with column names (too many columns so im just
including the relevent ones):
folders

I have an application compiled using gcc under DB2 v8 for Windows
Fixpak 12. It works fine for this fixpak.
However, if I move the application to a different DB2 fixpak (on
Windows), it does not run. (Basically it complains that "Procedure

Here's a question I posted to the VSE list.  I know there are few if any VSE
users around here, but I thought a z/OS person (or even another OS) might be
able to answer...
Still pondering VSE and DB2.  Don't have DB2 Server for VSE up yet to

There's nothing special in this query:
SELECT tbla.* FROM tbla, tblx WHERE tbla.cola = tblx.cola ORDER BY
tblx.colz
except that I'm creating tblx in application. It's a small array with

I installed DB2 in linux, the tool I can use is db2gov.
I'm wondering, how to set the idle time out, so all java app never time
out?
It's very simple in Mysql, in console, just set wait_time_out=0

Just to help somebody else if they are looking, we wasted 2 hours last
night trying to figure out the problem. (With a manager over our shoulder)
We upgraded our 8.1 FP11 instance to FP13. Instructions first say that
there are no instruction changes from FP11 to FP13. Great, so we ...

Lets say we have two tables:
Customer:
  Customer_number : Decimal(15)
  Name            : Char(30)

Folks,
 I spent better part of morning debugging a problem and it turned out to be
 DB2_USE_ALTERNATE_PAGE_CLEANING registry variable.
 I am running DB2 8.2 on AIX 5.3 system: