Documentation Center

Syntax for reap_delete

OSCommand
Windowsreap_delete -dbase dbname@ODBC_DSN <-i <infile>|-allobjects> switches
Linuxreap_delete -dbase dbname@SID <-i <infile>|-allobjects> switches
SwitchDescription

Windows:

dbname@ODBC_DSN

—or—

Linux:

dbname@SID

Required: dbname.

The name of the Contenta database.

Optional: ODBC_DSN (Windows)

The ODBC data source name. If not specified, the default is used—as defined in the registry for XYV_PDM_ODBC_DSN

Optional: SID (Linux)

The system identifier. If not specified, the default is used—as defined in the registry for XYV_PDM_DATABASE_SID

DefaultNone; must be specified
-i reportfile

Optional—if not used, you must use the -allobjects switch.

Required when using the -multiuser switch.

Deletes objects specified in the reportfile created by the reap_report command.

It does not matter whether you specified -nopaths when you ran the reap_report command. The reap_delete command ignores lines in the report that do not begin with a vertical bar (|).

DefaultNone; must use this switch or -allobjects switch
-allobjects

Optional—if not used, you must use the -i reportfile switch

Executes for all inactive objects without using a report file as input.

DefaultNone; must use this switch or -i reportfile switch
-compact

Optional

Drop and recreate database tables and indices after deletions.

DefaultDoes not compact tables and indices.
-verilk -pw password

Optional (recommended)

The verilk command executes prior to the reap_delete execution to ensure that the parent_list is clean.

The -pw switch is required with the -verilk switch; password is the sysadmin user’s password.

The -verilk switch is recommend unless you have already run the verilk command with the -relations switch before running reap_delete.

The output for -verilk is included in the reap_delete log file if you also used the - o filename switch.

DefaultNo verification is done.
-max_proc_time HH:MM Optional

Deletes objects for the specified hours and minutes, then stops and begins rebuilding tables and indexes (unless you specify the -nocompact switch).

DefaultNo maximum time, no timeout.
-restart filename Optional

Specifies the name of a file in which to keep a record of the last report processed.

If the file already exists, the reap_delete command begins with the line specified in the file. When the command exits, the file contains the last-processed line number.

This enables you to use onereap_report command output over multiple days.

Do not specify the -restart switch with the -allobjects switch.

This switch must be used with -i reportfile switch.

DefaultNone.

-before MM/DD/YY[YY]

[HH:MM[:SS]]

Optional

Deletes objects last modified before the specified date and (optional) time.

To delete all object types modified before a specified date (without an input file from a prior execution of reap_report) specify the -before and -allobjects switches in the reap_delete command line.

Default

Deletes all objects except as specified by other switches

-objtype typename typename...

Optional

Deletes only the specified object types. Object type names are not case sensitive.

The -allobjects switch can be used in the conjunction with the -objtype switch to restrict deletions.

Global, SysAdmin, Desktop, WorkPool, Projman, Workflow, NullObject, and customized objects based on these objects.

Default

Deletes all objects except as specified by other switches.

-o output_fileOptional

The output filename.

Use this switch to write the reap_delete log to the specified output_file.

The output_file may contain a directory path; it must contain a filename. If the directory path is not specified, the file is written to the current directory.

Use this switch with the -v switch to obtain a BLOb report of deletions.

DefaultStandard output (stdout).
-vOptional

Reports on objects deleted in the format of the reap_report command output with INFO:DELETE: at the beginning of the line.

Also enables other types of INFO: messages.

Last modified time of each object is read from BLOb deleted; BLObs are loaded. If used with -quick switch, BLObs are not loaded.

DefaultINFO: messages are suppressed.
-nOptional

Displays a list of inactive objects that are to be deleted but does not delete objects.

DefaultObjects are deleted.
-quickOptional

Runs delete in quick mode.

Last modified time is not read from the binary large object (BLOb) so BLOb is not loaded (see Note below regarding -before switch).
-multiuserOptional

Overrides restriction of running reap_delete in singleuser mode.

Use to run reap_deletewhile users are connected to the database. Must be used with -i reportfile switch.

Execute reap_report with -o output_file switch first to create the report file that is required to be used with this switch.