Is there a way to retrieve or reconstruct the SQL that was used to
create a particular table in DB2? I'm looking for something similar to
the contents of the 'SYSCAT.ROUTINES.TEXT', but for tables.
Thanks,

PUBLIC NOTICE:
I have no blog.  I have never had a blog.  I have no idea who is using
my name, postings and likeness on that "SQL Apprentice" blog.

How can you reduce high water mark of a DMS tablespace? I have
tablespace quite huge, but I dont need it thatt size anymore. There is
no way though to reduce the ts size as the highwater mark is close to
the max TS size. If nybody knows how let me know. Thanks

I have a very big table in a DMS tablespace (with one LONG VARCHAR
column). It is close to 250G in size now and almost reaching the
tablespace size limitation. I deleted a whole bunch of historic data
from the table (about 20% of the data). But the problem is there was no

How to give database creation privelege to a user on Windows?
Regards,
Jatinder

I am looking for some insight into a backup problem for an online
database backup performed each night on my Linux Instance (SuSe 9
kernel 2.6) of DB2 DPF 8.2.  The backup is initiated using a script
that does a db2_all, first to the catalog partition and then to the

I am trying to grant connect privilege to a user present on my O.S.
(Windows) using following statement.
GRANT CONNECT ON DATABASE TO user "user1"
now when I execute this statemnt from db2 clp(ofcourse prefixing db2)

I do not know if this can be done in standard SQL and if not this is
an answer too!
We have a table that holds the history of our cash dispensers with
their location and number of cassettes.

[this is the followup of the "DB2 UDF timeout"
thead - i've decided to replace the subject
though because of the new topic]
A note: by thread i always mean the worker thread on which SP is

we i get a snapshot for lock on db i'm getting
LOCK_LIST_IN_USE =5560
and
my  LOCKLIST parameter = 50,

After 3 years of using DB2 on Linux, I'm leaving my current employers
to go work for a SQL Server shop instead.  In order to find my
replacement, they're trying to put together a set of questions to get
both some understanding of how wide candidates knowledge is, and how

Given the following:
----------------
String lockSubscriptionQuery =
  "SELECT subscriptionId FROM subscription WHERE subscriptionId = ?

I have a pretty urgent problem I need to solve, so if anyone has an idea
over this....
I am to check whether all the indices over foreign keys are properly
defined and I still cannot find where DB2 holds this particular data?

1) On UDF timeout the timeout error is return to the caller, but what
happens
with the UDF's thread? - does it terminated via Windows
TerminateThread() or

Is there any reason why a CREATE NICKNAME statement fails if the remote
object is an ALIAS ?
I actually have an ALIAS that is used to point to the correct table in the
remote DB, and would like the nickname to point to this alias, avoiding the