Export DB2

[Harris Kosmidhs]

Hello there,

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?

Thanks

[Sanjuro]

On Jan 7, 3:28 am, Harris Kosmidhs <[e-mail]>
wrote:

Hello there,

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?

Thanks

Take a look at recently released web based DB2 management console.
http://sourceforge.net/projects/db2mc/

cheers,
sanjuro

[m]

Harris Kosmidhs wrote:

Hello there,

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?

Thanks

There is also a command line tool - db2look that will recreate the DDL
for a database.

[Mark A]

"Harris Kosmidhs" <hk******@remove.me.softnet.tuc.grwrote in message
news:fl**********@volcano1.grnet.gr...

Hello there,

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?

Thanks

If you are loading the tables into another DB2 database, then all you need
is export to IXF format, and then import using replace_create option. This
will create the table upon import. However, the foreign keys will not be
re-created in the new table. If you use import, then the "COMMITCOUNT 1000"
keyword is recommended.

If you want to automatically move all the tables in the database, then
db2move command will automate the export and import for you.

[Harris Kosmidhs]

Mark A wrote:

"Harris Kosmidhs" <hk******@remove.me.softnet.tuc.grwrote in message
news:fl**********@volcano1.grnet.gr...

>Hello there,

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?

Thanks

If you are loading the tables into another DB2 database, then all you need
is export to IXF format, and then import using replace_create option.

No, what I want is only the table in a text file with insert into
statements.

Why isn't there a simple tool for that? I examined
http://sourceforge.net/projects/db2mc/ but it was rather obfuscated to
install the php_ibm_db2 extension!

[Sinzig]

On 8 Jan., 09:23, Harris Kosmidhs <[e-mail]>
wrote:

No, what I want is only the table in a text file with insert into
statements.

Why isn't there a simple tool for that?

Take a look at http://jailer.sourceforge.net/
The tool is mainly intended for exporting referentially intact row-
sets, but you can also export single tables by removing all
association definitions after db-introspection, then choose the table
you want to export as the subject-table and '1=1' as condition.