contact contact

dberase utility

» Usage | Notes | Examples | See also
  The dberase utility erases all entries in all or selected datasets of a given database. It retains the database structure (schema) and returns space to the free space pool of the database volume files.


usage: dberase [options] database [set ...]
 -help   - show usage (this list)
 -u user - set user name
 -p pswd - set password
 -d flgs - debug flags

The options are:
The -help option displays a brief help text.

-u user
The -u option specifies the database user (or a file holding the database user and/or password). Defaults to the dba user unless a default user is specified with the EQ_DBUSER environment variable.

-p password
The -p option may be used to specify the password for the database user (or a file holding the password). If not specified, the password is obtained using the EQ_DBUSER and/or EQ_DBPASSWORD environment variables.

-d flags
The -d option specifies debug flags and is normally not used.


  • The database to be erased may not be opened by any users.

  • The database user performing dberase needs to have DBA user privileges, or be member of a group that has DADMIN group privileges for the target database or else be member of a group that has been granted ERASE privileges for the dataset(s).

  • Erasing a detail set clears the chain heads in all associated master set entries.

  • Erasing a master set renders the chain pointers in all related detail sets useless.


dberase MyDB history-set log-detail

See also


  Privacy | Webmaster | Terms of use | Impressum Revision: 2014-08-14  
  Copyright © 1995-2021 Marxmeier Software AG