When Needed

Execute the following when needed as described in the Notes column.

CommandRefer ToNotesSingle- User Mode?
newdb.pl Syntax for newdb.pl

Use when a new Contenta database is needed.

The sysadmin desktop is the only object in Contenta Explorer in a new database.

not applicable
dbcopy.pl Syntax for dbcopy.pl

Use when a copy of a Contenta database is needed.

The data in the original database is copied to the new database.

After copied, there are no links or connections between the databases or the data in the databases.

Yes
dropdb.pl Syntax for dropdb.pl

Use to delete a Contenta database.

The Contenta database is permanently deleted.

You may want to export the database before dropping/deleting — after dropping, the database can only be restored from a backup copy, that is, by importing a previously exported database.

See Syntax for dbexport.pl.

Yes
dbimport.pl Syntax for dbimport.pl Use to import a database that was previously exported (that is, to import a backup copy of the database). See Syntax for dbexport.pl.not applicable
listdb.pl Syntax for listdb.plUse to list all Contenta databases.No
pcmsessionsContenta Sessions Command

Use to view user sessions; that is, current user access to the database. Issue before issuing single-user mode commands to verify that there are no users attached to the database.

(Single-user mode commands fail if there are user sessions attached to the database).

Use if you suspect that there are invalid (hung) user sessions. Use to clear (specific or all) sessions.

No
checkblobsBinary Large Object Check Command

Use to check that each BLOb (of Contenta data) is accessible and free of corruption.

Note that this is used primarily by the reap_delete command to check the BLOb space in your database.

Note that repair of corrupted blobs must be done with assistance from an SDL representative.

Yes
pcm_compute_stats.pl Compute Stats Command

Use to analyze and compute statistics on each table in the specified Contenta database, for the purpose of optimizing queries (sql) made to the database.

If you execute this program, it is highly recommended that you then schedule periodic and regular execution of the program to keep the statistical information updated.

Yes
pltrimParent List Trim Command

Use to remove erroneous entries (orphans) in the parent list—those are entries that were not deleted when they should have been, as well as duplicate entries.

Yes
reap_deleteDeleting Objects

Use to remove objects from the database that are not being used in Contenta Explorer.

Permanently removes objects.

Does not restore space see Deleting Objects to restore space.

Yes