Does a classic offline reorg of a table on DB2 V.8 reorg the indexes
associated with the table too?
The command is:
REORG TABLE tabname ALLOW NO ACCESS;

I'm having some trouble getting the backup size for our current
databases from TSM
The environment is Windows
Here is the dsmc command that lists the filespaces

These day I checked the db2diag.log of db2 v8.1 FP 10 on aix and found
the same
error appered every 6 minutes:
2007-10-23-09.43.31.891799-240 I1486C411          LEVEL: Severe

The Administrative API reference manual of DB2 9 (SC10-4231-00) does
noet contain XML data replication info.
The Information Center on the 9.5 beta does not mention XML as a field
type and XML info looks very rare in the Information Center(mentioned

I am facing some issues with the following set of commands.
The last 'Select' statement gives the error
"SQL0511N  The FOR UPDATE clause is not allowed because the table
specified by

I am currently repartitioning 4 partitioned db to single partitioned
db. I have moved all user/application related nodegroups from 4
partitioned to single partition successfully using redistribution
nodegroup uniform.

Linux valinor 2.6.9-22.EL #1 Mon Sep 19 18:20:28 EDT 2005 i686 i686
i386 GNU/Linux
I've tried to install the Linux client and it went fine, but with a
minor error:

I'm trying to do something a little odd, mostly as an experiment. I'm
trying to create a function which will return 'True' if the string
passed in is a valid integer, and 'False' if it is not. I'm doing this
in this way because there is an existing function in the database that

DB2 LUW v8 FP15.  My Database STMTHEAP parameter is 4096 * 4k pages,
so there is plenty of space.
IF:
a) I use Java's and JCC, I am able to run long statements ( > 65K ).

The users logged in my application can run custom reports against a
SQL Server database. We keep in each user profile a preferred sorting
collation so that whenever the user runs a query and chooses to sort
by a character column, the engine automatically adds a something like

   Whenever i am trying to connect to my database this is the error
that i am facing. I a not able to go ahead from thsi point because to
proceed i need to have atleast the connection which i am  not able to
do.

Linux Db2 LUW V8 FP 15
I was readiong Serge´s SQL on Fire presentation (part 2), and there is
a slide that shows how to mass delete data using procedures. Something
like:

I can't find any distribution for db2 9 on Debian (Ubuntu uses Debian).
The standard Linux distribution uses rpm which is not supported in Ubuntu.
This one talks about Debian distribution
http://tldp.org/HOWTO/DB2-HOWTO/ubuntu704.html

I have had a lot of problems installing a DB2 v8.1 Personal Edition on
a RHEL4. Solved most of them by using a JDK-1.4.1 instead of the
default 1.3.1, which comes with DB2. But I still have two problems,
and I think they have something in common:

All,
 Question on Fixpak for UDB client running on AIX
1. Are there alternate Fixpak for Client?
2. If we are using regular fixpak to patch a client,  Does the "apply"