Maintenance management

The maintenance service allows you to execute the following operations:

Note   If no parameters are used, the operations are executed in the order presented.

See also Partition lifecycle management.

Clean cache entries

Description

Clean expired cache entries.

When a cache expires, information is only available in the database. This command is used to free space.

This is a regular maintenance task. It has a timeout parameter to be integrated within the regular maintenance flow.

Syntax

dstools maintenance -tasks|--tasks CLEAN_CACHE_ENTRIES

[-to|--timeout TIMEOUT]

Parameter

  • tasks - CLEAN_CACHE_ENTRIES
  • timeout - Maintenance task timeout

Example

dstools maintenance --tasks CLEAN_CACHE_ENTRIES --

timeout 60

Clean collections

Description

Clean collections in error. These collections are produced when an exception occurs during injection. In this case, the injection process stops and part of the information is stored in the database. This command is used to purge information and free up space in the database and it also cleans-up partitions created for failed injections. This is a regular maintenance task. It has a timeout parameter to be integrated within the regular maintenance flow.

Syntax

dstools maintenance -tasks|--tasks CLEAN_COLLECTION

[-to|--timeout TIMEOUT]

Parameter

  • tasks - CLEAN_COLLECTION
  • timeout - Maintenance task timeout

Example

dstools maintenance --tasks CLEAN_COLLECTION --timeout 60

Unmount partitions

Description

Change the status of a set of partitions to OFFLINE and create a dump file per partition to be unmounted. The dump file is stored in the BACKUP database server directory defined in Administration.

Syntax

dstools maintenance

-tasks|--tasks UNMOUNT

[-to|--timeout TIMEOUT]

Parameter

  • tasks - UNMOUNT
  • timeout - Maintenance task timeout (not available on MS SQL Server)

Example

dstools maintenance --tasks UNMOUNT

Carve partitions

Description

Drop the tables and views from the partition that has been unmounted or that can be purged.

The partition is considered as unmounted when the commitment file has been received in the COMMITMENT databse server directory. The committed file name must be the same as the backup file name with the .cmt extension.

Example:

  • Backup file name: ds_ROOT_Def03_002_160201.dat
  • Commited file name: ds_ROOT_Def03_002_160201.cmt

Syntax

dstools maintenance

-tasks|--tasks CARVE

[-to|--timeout TIMEOUT]

Parameter

  • tasks - CARVE
  • timeout - Maintenance task timeout (not available on MS SQL Server)

Example

dstools maintenance --tasks CARVE

Purge partitions

Description

Purge partitions.

When the information retention period is over, it is no longer necessary to keep the data and structure. This command removes the structure definition of a partition.

Syntax

dstools maintenance

-tasks|--tasks PURGE

[-to|--timeout TIMEOUT]

Parameter

  • tasks - PURGE
  • timeout - Maintenance task timeout (not available on MS SQL Server)

Example

dstools maintenance --tasks PURGE

Mount partitions

Description

Restore partitions from the backup file available in the RESTORE database server directory. The partition status changes to ONLINE.

Syntax

dstools maintenance

-tasks|--tasks MOUNT

[-to|--timeout TIMEOUT]

Parameter

  • tasks - MOUNT
  • timeout - Maintenance task timeout (not available on MS SQL Server)

Example

dstools maintenance --tasks MOUNT

Related Links