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