DUMP_OPTIONS - UDBDUMP configuration option

Owned by Stonebranch (Deactivated)
Feb 06, 2023
1 min read

Description

The DUMP_OPTIONS option controls database dump behavior, including the format of the dump output and the extent to which data is recovered from a possibly corrupt database file.

There are two forms of the DUMP_OPTIONS option:

  • -p controls the format of the dump output, causing some printable characters to be dumped as text characters. This form of DUMP_OPTIONS is useful if you to intend use standard text editors and tools to modify the contents of databases upon reload.
  • -r controls data recovery behavior, and instructs the utility to recover as many records as possible.

Note

UDBDUMP also accepts a -R option. However, the upper case -R is not recommended. It specifies that aggressive recovery should be performed, which can result in potentially bad or deleted records being recovered.

When using DUMP_OPTIONS, only use lower case -r.

Usage

Method

Syntax

IBM i

HP NonStop

UNIX

Windows

z/OS

Command Line, Short Form

-p

-r



(tick)

(tick)

(tick)

Command Line, Long Form

n/a






Values

(There are no values used with this option.)