Hi, folks.
Sorry about this - I have been R'ing all TFM's I can find, but am just
getting more frustrated.
Background:

How can I see the actual size of a table is bytes?
I could to a count on table and multiply by page size, but we are using
VARCHARs and I'm affraid that is not the correct value.
I could also find the file that a table is stored in, but I don't know where

Ive written a test program for loading data into a table using the
db2Load api. It works fine except when i specify COPY = YES USE TSM.
Ive set the aforementioned attribute in the api by the following line
of code:

I have DB2 V8.1 running on solaris box but I wanted to install DB2
V9.5. Does anyone have documentation 'how to install DB V9.5 on
solaris 9', by using db2_install command. I checked on IBM website but
didn't found anything.

I NEED A WAY TO CONVERTER IN THE BASE DB2 DATAS TYPE (BLOB) INTO
(VARCHAR/LONG VARCHAR) TO STORE IN A VIEW. I WORK WITH THE REPORT GENERATOR
CRYSTAL REPORT AND INSIDE OF THE TOOL ENVIRONMENT I CAN´T CONVERTER VIA ODBC
THE DATAS TO PRESENT IN THE REPORT.

For some reason when i execute this :
select table_name from table(sysproc.snapshot_tbreorg('',-1))as t
I doesn't return any data on couple of databases, but works on others,
yet when I do list history reorg I get lots of data.

When issuing a get db cfg command are we supposed to be getting the
current value or future value of a parameter?
For example, I issue a get db cfg against a certain database and get
this:

When I am SELECT'ing a CLOB column from command prompt, the output is
getting truncated after a certail limit (8 K ??)
How do I get the full data out of a CLOB column? Are there any string
manipuration functions for CLOB fields to read it in multiple chunks ?

Help T-SQL Server developer lost trying to implement some simple
cursor logic!
I need to create a "table object (variable)" OR "TEMP variable" OR
"create and drop a table in a procedure" in DB2 to eliminate duplicate

DB2 LUW v8.2 FP 14  Red Hat EL 3.4.6-2
I will soon, in order to gain some disk space in my DB2
file systems:
1.  Shut down DB2

I am working with DB2 LUW after being away for a few years. Most of my
experinece is in the z/Os environment.
I am noticing the millisecond-only timestamps and trying to remember
if there is a way to get DB2 to insert the actual microseconds in

Dear DBAs.
I am wondering if anyone gotten good results leaving the,
   Monitor health of instance and databases   (HEALTH_MON) = ON
I find the default ON setting causes more problem than its worth, its

Dear Group,
we are migrating V8.2 instances to V9.5 and try to map everything
thats needed. Does anybody know
if userexit program needs to be recompile in V9.5 for it to be

I like the new feature that allows you to load data from a table in another
database without using data federation (servers, nicknames and user mappings
not required).  One feature I miss, however, with doing it the "old" way is
the use of CREATE with the LIKE option.  I don't ...

I have the DB2 Connection Concentrator enabled (DB2 V9.1) on a system
with very limited memory resources.  Does anyone know if the db2evmg,
db2taskd, and db2stmm processes count toward the MAX_COORDAGENTS
setting?