DB2 database export

[ILIAN_Grigorov]

Hello all,

Currently we are using DB2 9.1,

its EXPORT command supports only 3 types of files - DEL, WSF, IXF

Is there any way I can export the database in other format - i.e. DBF...

Thanks

P.S. I remember some SAP migration tool had the ability to export the database

in some "database independant format" or smth. .....

[Former Member]

Ilian,

        What is your requirement here ? You can also export the data with R3trans and import. Using R3load to export data only for one table is not wise also its very hectic as you need to setup migmon for this. If you explain what is your actual requirement then i may help you with that.

Thank

Chirag

[ILIAN_Grigorov]

Hi Chirag,

I am just asking . There is no actual requirement right now, but may be there will be in the future. Some organisation is supposed to require something like a "snapshot" of our database for auditing purposes. Which is not correct, because It is hard to analyse this big database, and I am almost sure their audit product is able to comunicate with SAP

Thank you for your time.

Regards

ilian

[Former Member]

Hi,

usually IXF extension is used 

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r000830...

and taking a look at IBM documentation it looks like the other extensions are not supported

Specifies the format of the data in the output file:

• DEL (delimited ASCII format), which is used by a variety of database manager and file manager programs.
• WSF (work sheet format), which is used by programs such as:Note:When exporting BIGINT or DECIMAL data, only values that fall within the range of type DOUBLE can be exported accurately. Although values that do not fall within this range are also exported, importing or loading these values back might result in incorrect data, depending on the operating system.
  • Lotus 1-2-3
  • Lotus Symphony
• IXF (integrated exchange format, PC version), in which most of the table attributes, as well as any existing indexes, are saved in the IXF file, except when columns are specified in the SELECT statement. With this format, the table can be recreated, while with the other file formats, the table must already exist before data can be imported into it.

regards, Javier