DB2 8.1 FP5 LUW
Red Hat AS 2.1
Can I run the DB2 Control Center (ie the Admin client)
on a Mac w/ OS 10? (I'm not talking server - a Mac

This is my query which is embedded in a COBOL program.
      EXEC SQL
              SELECT  DATE,  AGE,  DURATION,  AMT
                INTO  :LDATE,  :L.AGE,  :L.DURATION,  :L.AMT

I need to come up with a tool to compare the table definition and/or
its data before and after some modification to the DDL or some tests
(that change the data). Does DB2 come with such a tool, or do I need to
write my own? Thanks.

db2 8.1.3 Windows
I am getting this error in db2diag.log.Please tell why is this error
(-444) always there and how to go about for removing it.
Diag.log output:

I posted this again, but didnt get any answers, so here it goes again:
Since DB2 V8 command center always displays the full error message. Not
only the SQL error number and some short specific information, but the
whole bunch of additional stuff which you find in the documentation.

it seems that there is a free version of DB2 Express -
http://www-306.ibm.com/software/data/db2/udb/edition-expressc.html, named as
DB2 Express-C.
The page says that DB2 Express-C, a version of DB2 Universal Database

It would be a real big help if anyone can shed light on whether DB2 UDB
8.2 on Solaris will make optimum use of a Sun T2000 server. The server
has 1 CPU with 8 cores and each core has 4 threads (32 virtual CPUs).
We are exploring this option againts an equivalent performance pSeries

I'd like to write a query which will get all results from last month
from a table.
It should look something like this:
Select [fields] from [table] where [timestamp field] >= '[first day of

Have anyone seen this before.., we are seeing a lot of orpahn DB2
connections when the client terminates abnormally?
should'nt the underlying TCP/IP mechanism terminate the connection? or is
there any setting in DB2 that I need to change.

I am trying to setup a preferred export format for users when exporting
data.  Are there any pros/cons to using one format over another or is
it really just personal preference?
Spencer

Are there any UDB DBA's in Washington DC area that are looking for a
job?  We need 2 people and haven't been able to  find anyone for months
now.

How can 'rows read' from a DB2 CALL statement incur so many reads? I
would expect it to be zero.
Could someone enlighten me on this? Thanks!
Here is output from executing event monitor on STATEMENTS:

I've got a large table on db2 8.2.1 that I rarely perform runstats on.
It has about 600 million rows organized in a single MDC time dimension
on a non-dpf warehouse.
Anyhow, we recently ran runstats on it with a 20% sampling.  After this

Hi we have a lot of tablequeue overflows on the prod box, how can we
avoid them? we are on V8.2 partitioned.
Thanks,
Raj

Howdy guys,
I'm migrating my data access layer from OLE DB to .Net Provider (V5R3)
and now I've an issue, some of my tables have columns names within a
special character $ (for instance, SD$9INID ).