dbdeletedata - Delete Database Row Data

dbdeletedata [OPTIONS] dataarea [name ...]

Use the dbdeletedata utility to delete the data from database tables. You can use various options to control which data is deleted, such as by filters and indexes. You can also use an option to delete a table's associated framework data (such as audit snapshot data and user field storage).

Program Option Description
-b or --brief Brief mode (print only summary for each file).
-d Delete table data (default is to truncate table data).
--file=FILE

Use to specify a directives file in a directory. Each line in the file should contain the input arguments for dbdeletedata. For example:

BusClassABC -f "FieldXYZinBusClassABC = 1" -i Index1OnBusClassABC

BusClassDEF -f "FieldQRSinBusClassDEF = 2" -i Index1OnBusClassDEF

You can also specify a hyphen for FILE. The hyphen represents STDIN and you can then pipe directives into the command.

-f "filterString" or --filter=filterString

Limit the output based on the specified filter value for the index keys of the file. The filter can be a conditional expression, such as

-f "fileName.fieldName=1"

or

-f "relationshipName.fieldName=1"

--gridstatus=ID Publish progress to grid. You can then use managegrid getprogress to see a list of all running programs, or you can use managegrid getprogress ID to see the status of this program. The value you specify for ID must be unique across the system for any programs being run with the gridstatus option.
--includeframework Delete associated framework-managed data, such as audit snapshot data and user field storage.
-i indexName or --index=indexName Delete using the name index.
-k Keep the configuration parameters table.
--noconfigclear Do not fire the configuration clear event. Using this option means the system will be out of sync. This is useful when a system is off-line and these utilities are being used. In that case, the system will be restarted anyway and the cache for configuration data will be automatically built upon access so processing the event is not needed.
--noskipviews Do not skip views.
-q or --quiet Quiet mode (print only errors, do not print informational messages).
--showdataarea Show the data area name.
--showtimings Show timings for each file.
--threads=n Delete rows using the specified number of threads. The default is 4. If you use multiple threads, you may see a performance improvement. However, performance depends on other factors as well. Note that a very large table will be processed in a single thread.
--useupgradenames Use the upgrade names for tables. Only use if directed to by support personnel.
-x N Set the number of rows per transaction. The default is 1000.
-y or --YES Do not prompt for confirmation.
name...

A list of names of dictionary files, business classes, modules, database spaces, or business class patterns to execute the command against.

Use the prefixes file-, pattern-, space-, or module- to resolve ambiguity. Use prefix- and type- to select files by prefix name or types used. File names can be the long or classic name and can include ? and *. Specifying "!" anywhere in the list will complement the selected files. Specifying @path reads names from the file, one per line. A hyphen ( - ) indicates stdin. Wildcard characters may need to be quoted in the command line or they will be interpreted by the command processor. A :L on a file name selects the lobs table. A :B on a file name selects the base table.

-V errorlevel or --errorlevel=errorlevel

errorlevel, tracelevel, and verbose specified in any order, where:

  • errorlevel = {n}none | {f}atal | {e}rror | {w}arning (warning is the default)

  • tracelevel = 0:6 where 0 is no message and 6 is everything

  • verbose = whether to display exception stacktrace