A DB2 v. 8 DMS tablespace ran full. Subsequently, almost all data in the
tablespace has been deleted, but "LIST TABLESPACES SHOW DETAIL" keeps
stating that the tablespace has 0 free pages. I've tried running a REORG
on all remaining tables; that didn't help.

DB2 Viper 2 compatibility features
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0707rielau/
It is very interesting and must be usefull.
I want to know the plan when Viper 2 will be available.

Under DB2 v8.1 for LUW, I need to increase the size of the one and
only container for a tablespace.  The tablespace is DMS on a cooked
file system.  While executing the Alter Tablespace command to increase
the size of the container will the tablespace be available for use or

Attempted to download the paper "Testing SOA applications with IBM
Rational quality management solutions"
Filled out the form (First and Last, Email), and was taken to the page
for the download. However, the following message was where the link was

Does anyone else support SAP running onto of DB2 in an unix
environment?   The consultants we have in here are insisting on
creating a different DB2INST owner/userid for each environment and
server.   They say....."In all the installations they have worked on,

I'm attempting to connect to a DB2 database using DBD::DB2 running on
a Linux device.  I'm getting the following error:
** connect: Unable to get  database handle: DBI
connect('p88flaq','ip88flaq',...) failed: [IBM][CLI Driver] SQL1042C

In CLP I want to change the statement termination character from
default to ;(semi colon). I
tried update command options- but didn't work. how to do it????
regards,

I am using db2 9 CLP. When the output of the select command is more
than a page the messages scrolls out of the page. Is it possible to
pause the messages so that they can be viewed one page at a time,
( just like 'set pause on' in Oracle sql prompt). I am unable to find

I am a bit new to db2, and I am unable to find a proper alter table
command syntax where I can remove a not null constraint on a column.
Pls help.
regards,

I'm hoping to use SELECT FROM MERGE in one of my stored procedures,
but have not had any luck running my query. The sample query I'm using
is
SELECT TAPE_ID

I want to tanslate the following Oracle-SQL to DB2, but I'm stuck, any
hints?
Thank you in advance.
UPDATE TBZL0361CSFLQ_AGG CF

Hi Gents,
I'm trying to tune our DBs using the Desing Advisor feature. I'm
interested just in the indexes area.
Following the IBM infocenter I came to this page:

I'm getting entries in the windows event log saying "DB2 is performing
lock escalation" which of course is followed by another entrie saying
"The escalation of 'xxxx' locks on table 'SYSIBM  .SYSCOLDIST' to
lock

I'm running DB2 UDB v8.2 on Windows 2003 SP2.  How do I get a
tablespace out of Roll Forward in Progress state?!  I've tried
everything I can think of, but I'm extremely new to DB2 (more
experience w/MS SQL 2000) and am finding that DB2 doesn't seem to be

I have an update-query using case with exists, db2 responds with the
following error:
SQL0582N
A CASE expression in a VALUES clause, IN predicate, GROUP BY clause,