Syntax for reap_delete
| OS | Command |
|---|---|
| Windows | reap_delete -dbase dbname@ODBC_DSN <-i <infile>|-allobjects> switches |
| Linux | reap_delete -dbase dbname@SID <-i <infile>|-allobjects> switches |
| Switch | Description |
|---|---|
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 | |
| Default | None; 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 (|). | |
| Default | None; 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. |
| Default | None; must use this switch or -i reportfile switch |
| -compact | Optional Drop and recreate database tables and indices after deletions. |
|
| |
| Default | Does 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. | |
|
| |
| Default | No 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). |
| Default | No 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. |
|
| |
| Default | None. |
-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_file | Optional 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. |
| Default | Standard output (stdout). |
| -v | Optional 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. |
| Default | INFO: messages are suppressed. |
| -n | Optional Displays a list of inactive objects that are to be deleted but does not delete objects. |
|
| |
| Default | Objects are deleted. |
| -quick | Optional 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).
|
| -multiuser | Optional 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. |