Can someone tell if DB2 8.2 supports NXD's. Googling revealed that
there is some Extender Tk that mangaes XML columns...
Now if some experienced guy could clear this I would be glad...

Is it possible to alter tablespace so that you don't connect to the
database?
The problem I have is this. I got a DB backup from a machine with 16 Gb of
RAM. There was a bufferpool set to use 10 Gb of RAM. Now I have to put it

Is there a way to check the return status from a stored procedure when
called from a OS (Windows) script?
I have a stored procedure that does some checking in the database, and the
return status is set to 0 or -1 if 'OK' or 'not OK' respectively.

I'd like to know whether there is a way to alter the data type of a
VARCHAR FOR BIT DATA column to be simply a VARCHAR column? I executed
an ALTER TABLE statement, similar to,
ALTER TABLE tab_name ALTER COLUMN col_name SET DATA TYPE VARCHAR(100)

I am now doing development using DB2.
Q1.
There is one tablespace to store 5 tables.
But, when in production, there will be one tablespace for EACH of the

       How do we count the total physical disks assigned to a DB2 database
on a RAID 5, solaris environment.
Thank you.

I am doing some mass update on DB2 8.2 FP10 (say 400 to 500 rows on a
5000 row table) with just one commit.  So this is taking lot of
exclusive row locks as expected.   When I run a select on the same
table with a where clause its taking a IS table lock. This is causing

I am sorry for posting this requirement here but someone might get
help
my company is looking for db2 dba
---------------------------------------------------------------------------

Every so often, I'm asked to help people recover data from tables that
were either dropped or where to much data was DELETEed.
The complications related to restoring data are a problem. The SAS users
are laughing because they can (to a certain extend) easily go back to an

I would like to create a data model with a DDL file, is it possible and do
you know so software could do that.
Cheers
Eric

I try to drop a table as:

I got: During SQL processing it returned:
SQL0478N  The object type "TABLE" cannot be dropped because there is

I would like to know the SQL statement for displaying only the column
names of a particular table. For eg. if I have a table by the name
DETAILS and it has three columns FIRST_NAME, LAST_NAME and
DT_OF_BIRTH, using what SQL statement can I display only the column

I have x amount of rows in a db2 table. I want to update an account
number column with a random eight digit number:
This is where I have got
UPDATE zzz2

How can I modify return values?
i.e. I perform a query:
SELECT STATUS
FROM USERS

CASE 1:
The following sentences were copied from the book "Administration
Guide Performance".
"If more pages have been written to disk, recovery of the database is