I have access to a DB2 database through operation navigator. What I
would like to do is find a tool to export the database into create
table, insert into statements. Like what phpmyadmin does.
Is there a free tool for such a job?

I havent used MQT before. Read the online tips and tutorials but none
seems to give any hint for my problem.
I have a base table  (base_table) as:
                     st      varchar(25)     default 'my_null'

So IBM will acquire Solid Tech.
Extract for the SQL Guide from SolidTech:
(http://www.solidtech.com/developers/CarrierGrade/manuals/sqlguide/
html/SQLGuide.html#row.value.constructors):

I have db2 database at V8 + FP 12 and i saw db2fmp process running at
80% cpu
I have health monitor turned off and automatic maintainence turned off
as well

   In the process of making my database work (I started with not
being able to insert records because of tablespace issues) , I dropped
the tablespace for it. Now I am not able to access the data in any of
the tables because the tablespace on those tables is invalid. Is there

I've got a raft of data exported from a FoxPro accounting program in CSV
format.  Trying to import it into a V9.5 database I found that the FoxPro
system used a "memo" data type for some columns which exports a quoted
string but includes newline characters within the quotes.  Any ...

It suddenly matters, but I don't have much old docs.  When, on LUW, did
CTE support appear?  I'm certain by v7, but was it earlier?
thanks,
robert

Given the following situation, I am wondering what advantages and
disadvantages there would be for creating more than one instance.
For testing, we want to have more than one 'version' of a database.
Probably there will be only a single database [structure, that is], although

For some reason some of my views on a DB2 8.2 FP15 database went into
invalid state. I extracted the text from the sysviews and re created
them.  I want to know why it went to invalid state to begin with.  How
can i find the reason ?

I am trying to create nicknames for tables in a remote database. The
federated database and remote database are both DB2 UDB V8.2, both OS
are AIX.
Could anyone tell me how to create a nickname for a remote table with

If im not missing something, when looking into directories that are
SMS containers i can see multiple files, one for table data, one for
indexes and other for lobs.
Is there any special reason for not having different files/containers/

All,
  I'm having a difficult time trying to implement two-phase commits
across federated database members in UDB 8.3. I've tried using MQ (v
6.0) as the transaction manager and UDB tells me that having a 64bit

We want to replicate onto the same server (Capture / Apply) tables
into federated DB2 - Tables but we are not able to do it...
I've tried it with Replication Center but don't see the way to do it.
Could someone give me a hint or tip to do it?

Running DB2 9.1 on AIX 5.3
I would like to do a restore of a database from an online backup image
to December 21st with a backup that was taken using INLCUDE LOGS
Same box, not a redirected restore.

My db2 v7 was working fine with odbc after I installed new vserion DB2
v8 i still can connect to odbc using command mode, but its not working
with ms access to get data.
please help.