I ran the following bit of SQL and my PRIMARY KEY wound up in schema
SYSIBM called SQL.... not schema is3 called primary. The index
registation did wind up there. Obviously there's something I don't
understand or see. If you have some insight into this problem that you

Can somebody explain how to get the tablespace out of quiesce mode?
I am executing on each node of my EEE Win2K system:
db2 quiesece tablespace for table schema.tablename RESET
I get the confirmation that the SQL command has executed successfully

The problem mentioned below has been faced while trying to execute a
stored procedure.
In this case they have deployed an SP and then trying to make changes
to the out parameters but the changes made are not reflected on the

I am facing one problem w.r.t DB2,
When i launch my first instance of my client exe.
(written using Delphi 7)
and perform an action on Table A. (one of the row is in Transaction mode)

I have a database on DB2 server 8.1.
One of the databases in the same instance has the following problems,
while the others are working ok.
1. cannot connect to the database no matter from CLP or Control

Howdy
I'm new to working with DB2 Universal, so I'm not very familiar with
the tools.  I usually only use the Java Control Center and
Configuration Assistant.

I have a pair of tables which have foreign key dependencies on each
other. Is there any better way to define them than to create both of
them then, after both are defined, 'alter add' the constraints? I have
basic distrust of separating the table creations from the constraint

I just completed the installation of DB2 UDB free 1 client version on my
Windows XP Professional pc. When I want to create the sample database, I
receive an error telling me "Jean-Pierre Schnyder is not a correct
authorization id SQLSTATE=42602". This is stange since I recently ...

I want to define some kind of datatypes. First of all I don't know how to
define datatypes which have the same check constraints like in a common
create table stmt:
create table temp(ttt int check (ttt between 0 and 9348) not null, ...)

I get this error in my diag log after upgrading from 6.1 to 7.2
about every min.
No one is complaning!
Anyone have an idea where to look for this error?

i have a performance problem with the following query:
SELECT IMMAND,IPROD,IDESC IIM WHERE IMMAND = 188 ORDER BY IMMAND,
IPROD
I user DB2 V 8.1

This should be a rather ROUTINE procedure for you DBAs.
I keep hearing at technical conferences and user groups the phrase
"then rebind all your plans and packages" (after reorg, load, &
runstats, etc).  Obviously those plans and packages that need

After searching a lot on the ibmsite and googling a lot, i still dont
know how to execute a memberfunction in an udf.
Example:
-----------A.h --------------

  We are running java applications which uses DB2 as the data store.
But sometimes we get the following exception:
2004-04-25 22:51:39,478 FATAL [VBJ ThreadPool Worker]
LogService.logFatal(LogSer

I hope someone can give hint on this, I'm very confused right now.
Our program runs on a DB2-AS/400-System, we're connecting via an
EasyCom-IDAPI-BDE (Borland Database Engine)-Driver.
We're now executing a prepared query with parameters