I was wondering is it necessary to runstats, reorg (and other things
like rebind pkgs, including rebind cli from as many versions of window
clients as exist in the enterprise) following a db restore?
Will these scenarios effect the answer:

db2 8.2 (8.1 FP9a) on AIX 5.2.
The 8.2 information center (online version) states that "The only
64-bit platform that currently supports DB2 XML Extender is the HP-UX
platform".

I am wanting to find out the size of a table for which I am using the
following query:
select c.card * b.columnlength from syscat.tables c,
(select sum(a.avgcollen) as columnlength from syscat.columns a

I am dropping an index and recreating it to lower the high water mark.
The index creation is taking a lot of time. I am stuck as to why it
does so. Is there any way that I can find out why it is doing so. Is
there a snapshot that will help me while index creation.

I'm relatively new to DB2. I'm running v 7.2 on Windows XP Pro. I have
a SQL statement which is very long (almost 90,000 characters). I have a
couple of questions:
1. What is the limit for SQL statments? And if so, is this a

The DB2 8.2 SQL Reference says SET CURRENT LOCK TIMEOUT is not under
transaction control. I assume that means that changing it via the SQL
command affects all connections to the database in the same way the db cfg
parm LOCKTIMEOUT does?

   I have table test (c1 varchar(255) and c2 clob).
  Table contains 100 rows . Both columns contains the SAME value  (
some short text of 150 bytes).
 Now, if I'm fetching both columns to some text files.

We disabled the antivirus software but the problem persists. Any clues?
Many thanks in advance!
Panagiotis Varlagas
=====================================================================2005-07-28-10.39.02.015001   Instance:DB2   Node:000

I am reading that db2 is using the OS for authentication. So if we run
on a Win2000 Server, I guess that we have to create user account in the
Windows2000 for every user that creates an account.
My question is:

For lob data is it a good idea to both compact and apply system
compression? I understand compact can reduce performance when updating
but any disadvantages of using compress? Will it help to save hard disk
space to use both? Thank you very much!

With OS400, all files are objects that can be accessed relationally.
When I view the file system from Navigator (windows client), I see there is
the Database and SQL tables, then there is the filesystem.
I can manipulate both these objects (tables, files) with SQL.

I have a database which is fully generated by a (java) persistence layer; so
I have practically no layer where pure database modelling will be done, no
Erwin no nothing.
All I can do is giving the persistence layer hints on which objects actually

I'm doing a postmortem from an outage at my workplace that looks too
similar to an outage we had last fall to not be related.  Both database
outages had the following characteristics:
1) VERY large, frequently-accessed & updated tablespace defined on a

Hi, is there anything I need to do to recover hard disk space after
deleting a table? I have a large table with blob fields and when I
first created the table I did not compact this field. So I am planning
to create a second table with this field compacted and then delete the

V8.1.6
In order to check if a routine is valid or not, SysCat.Packages must be
checked, since SysCat.Routines is nearly always Valid = 'Y'. I chalked
it up to DB2's  idiosyncrasies (of which there seems to be many) and