DEACTIVATE DATA (Deactivate data for a client node)

Use this command to specify that active data that was backed up for an application client node before a specified date is no longer needed. The command marks the data as inactive so it can be deleted according to your data retention policies.

Restriction: The DEACTIVATE DATA command applies only to application clients that protect Oracle databases.

When you issue the DEACTIVATE DATA command, all active backup data that was stored before the specified date becomes inactive. The data can no longer be retrieved, and is deleted when it expires.

The DEACTIVATE DATA command affects only the files that were copied to the server before the specified date and time. Files that were copied after the specified date are still accessible, and the client can still access the server.

Privilege class

To issue this command, you must have system privilege.

Syntax


>>-DEACtivate DAta--node_name--TODate--=--date------------------>

   .-TOTime--=--23:59:59-.  .-Wait--=--No------.   
>--+---------------------+--+------------------+---------------><
   '-TOTime--=--time-----'  '-Wait--=--+-No--+-'   
                                       '-Yes-'

Parameters

node_name (Required)

Specifies the name of an application client node whose data is to be deactivated.

TODate (Required)

Specifies the date to use to select the backup files to deactivate. Tivoli® Storage Manager deactivates only those files with a date on or before the date you specify. You can specify the date by using one of the following values:

Value	Description	Example
MM/DD/YYYY	A specific date	01/23/2014
TODAY	The current date	TODAY
TODAY-days or -days	The current date minus days specified. The maximum number of days you can specify is 9999.	TODAY–30 or –30. To deactivate files that are 30 or more days old, you can specify TODAY-30 or -30.
EOLM	End of last month. The last day of the previous month.	EOLM
EOLM-days	The last day of the previous month minus days specified.	EOLM-1 To deactivate files that were active a day before the last day of the previous month.
BOTM	Beginning of this month. The first day of the current month.	BOTM
BOTM+days	The first day of the current month, plus days specified.	BOTM+9 To deactivate files that were active on the 10th day of the current month.

TOTime

Specifies that you want to deactivate files that were created on the server before this time on the specified date. This parameter is optional. The default is the end of the day (23:59:59). Specify the time by using one of the following values:

Value	Description	Example
HH:MM:SS	A specific time on the specified date	12:30:22
NOW	The current time on the specified date	NOW
NOW+HH:MM or +HH:MM	The current time plus hours and minutes on the specified date	NOW+03:00 or +03:00. If you issue the DEACTIVATE DATA command at 9:00 with TOTIME=NOW+03:00 or TOTIME=+03:00, Tivoli Storage Manager deactivates files that were put on the server at 12:00 or earlier on the specified date.
NOW-HH:MM or -HH:MM	The current time minus hours and minutes on the specified date	NOW-03:30 or -03:30. If you issue the DEACTIVATE DATA command at 9:00 with TOTIME=NOW-3:30 or TOTIME=-3:30, Tivoli Storage Manager deactivates files that were put on the server at 5:30 or earlier on the specified date.

Wait

Specifies whether to wait for the server to complete processing this command in the foreground. This parameter is optional. The default value is NO. Specify the following values:

No: The server processes this command in the background and you can continue with other tasks while the command is processing. Messages that are related to the background process are shown either in the activity log file or the server console, depending on where the messages are logged.
Yes: The server processes this command in the foreground. The operation must complete before you can continue with other tasks. Messages are shown either in the activity log file or the server console, or both, depending on where the messages are logged.

Restriction: You cannot specify WAIT=YES from the server console.

Example: Deactivate data for a data protection client node

The client node BANDIT is a Tivoli Storage Manager for Databases: Data Protection for Oracle application client. All of the backup data is active, and so all of the backup data is retained. The following command deactivates data that was backed up before January 3, 2014, so it can be deleted when it expires.

deactivate data bandit todate=01/23/2014

To periodically deactivate data so it can be deleted when it expires, you might run the following command from within a client schedule.

deactivate data bandit todate=today

Related commands

Table 1. Commands related to DEACTIVATE DATA
Command	Description
DECOMMISSION NODE	Decommissions an application or system.
DECOMMISSION VM	Decommissions a virtual machine.