I am wondering, is the disk limit constraint in db2advis on
a) The space of the recommended indexes and materialized views.
b) The space of the recommended indexes and materialized views, as well
as the space of current indexes and materialized views.

[Note] this question is cross-posted to 3 unrelated ngs. Please followup
only to 1.
Hi,
How can I do this:

Folks,
 We have an SQL statement that was coded in an application many years ago
 (starting with DB V2 I think). When I upgraded to UDB 8.2, the optimizer
 does not use optimal path to access the data.

"Administrator Guide Implementation" DB2 8.2, chapter 7, section
"Indirect privileges through a package" states:
(highlight >>>>!!!<<<<)
"Privileges granted to individuals binding the package and to PUBLIC

I am having a problem. While debugging a procedure in db2 I found that
the execution failed because the procedure failed to delete one row
from a specific parent table. The parameter set for this output message
is of type varchar and size 2000. The out pu to fthe debugger is

I just need to install the DB2 client in a solaris machine. The machine
has not installed an open windows environment so the installation
should be done in character mode. Is it posible? How could I do it?

Anyone running HADR using VERITAS Cluster Server (VCS)? Our production
outsourcing company has recommended to use VCS instead of Tivoli System
Automation (TSA) for heartbeat monitoring on Linux.
Another question. We assume that automatic client reroute can be used with

Folks,
 I am having trouble with db2 contol center for UDB 8.2 on AIX.
 I can start control center and it finds my instance/database.
When I try to do anything else I get following error message:

I'm getting a small error with db2 . I have been looking for it on
internet and found almost nothing (some webpage without any answer) .
Small recap : My db2 is a 7.x with a redhat Linux 6.2 .
My errors :

People,
I'm trying to figure if SQL is able find sequences of transactions that
occur over say a four day period.
I have a table that contains a txn id [integer] and a date. Each

i need to change the tablespace of a table, ie. use another tablespace
for the table and stop the use of the existing tablespace. Is there any
way i can accomplish this? One solution might be export the data from
the table, re-create the tables in the new tablespace, drop the

I have a question about VARCHAR fields.  Our application groups here
are starting to use VARCHARs much more frequently.  Even VARCHAR (2) to
(9) length fields.  They say this is because some of the application
programs, specifically Java Beans cannot handle the spaces after the

Can I restore a backup taken from a DB2 7.2 on Linux to a 8.1 Win ?
How ?
Tkx

Can we create an alias for a sequence in db2 udb? We can do it in
oracle. But the same thing is not working in db2. I can create an
alias, but when i am trying to use it, there is an error that the
object is not found.

I'm relatively new to DB2 and was reasonably amused to see the REVERSE
SCAN availability for Indexes.
My assumptions are as follows:
   DB2/UDB uses B-Tree for indexing by default and is likely the main