dbdump

Dump Database File

dbdump [-dp] [-iindex] DataArea|dataID filename

Dump database files to standard output. You can then load the database from the flat file using dbload. You should not use this utility to import data into a Lawson database from a non-Lawson application system. The main use for this utility is to dump the Lawson database on one machine and load it onto another.

Unless you use the -d option, the utility truncates fields larger than 80 columns (or 132 columns, with the -p option). To dump files containing fields larger than 80 columns, in addition to using dbdump -d, you can also use rngdbdump with either the -d or -c option.

If your data files have attachments, make sure you dump both the header and detail attachment files. They reside in the same data area as the data to which they are attached, and they are named as follows:

L_HPrefix (for example L_HEMP, if the file name is EMPLOYEE)
L_DPrefix

where Prefix is the prefix of the data file the attachments are related to; L_H indicates a header attachment file (the first 512 bytes of the attachment), and L_D indicates the detail attachment file (the remaining bytes, up to 32,000, of the attachment).

Lawson has a 2GB limitation on file creation. Call Lawson's Global Support Center for more information on how to use named pipes to bypass this limitation.

To have the system automatically dump and load the attachment files, use the expsysdb and impexp utilities.

Option	Description
d	Dump to flat file. Use with the dbload utility. You can also use this option to dump files containing fields larger than 80 columns.
p	Printer format (132 columns). Writes the output in 132-column format. The default is to write the output in 80-column format for online display.
i	Use index (for example, -iGLMSET1).Dumps the database using an index sequence. The index name must follow the -i.