Question Re: DB2 database export in Technology Q&A

DB2 database export

ILIAN_Grigorov — Fri, 30 Mar 2012 08:04:57 GMT

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. .....

Re: DB2 database export

Former Member — Fri, 30 Mar 2012 10:27:33 GMT

Hi,

usually IXF extension is used

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

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

Re: DB2 database export

Former Member — Mon, 16 Apr 2012 10:02:22 GMT

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

Re: DB2 database export

ILIAN_Grigorov — Tue, 17 Apr 2012 06:37:40 GMT

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