3.7 Data Housekeeping

The Data Housekeeping UI helps you to perform the followings tasks based on user defined criteria:

• Delete data from selected tables
• Drop partitions and truncate subpartitions from selected tables
• Archive the data from selected tables

You can use this as data retention in PBSM cloud services.

To open the Data Housekeeping screen, from the LHS menu, select Data Management Tool, and then select Data Housekeeping.

Users and Roles

The following roles and functions are required to use the Data Housekeeping UI.

Table 3-19 Roles and Role Names

Role Code	Role Name	Function Code	Function Name
RLDHKANALYST	Data Housekeeping Analyst Role	DHKADD	Create Data Housekeeping Policy
		DHKRUN	Run Data Housekeeping Policy
		DHKDEL	Delete Data Housekeeping Policy
		DHKEDIT	Edit Data Housekeeping Policy
		DHKVIEW	View Data Housekeeping Policy
		DHKLOG	View Data Housekeeping Policy execution log
RLDHKAUTH	Data Housekeeping Authorizer Role	DHKAUTH	Authorize Data Housekeeping Policy
		DHKADD	Create Data Housekeeping Policy
		DHKRUN	Run Data Housekeeping Policy
		DHK	Delete Data Housekeeping Policy
		DHKEDIT	Edit Data Housekeeping Policy
		DHKVIEW	View Data Housekeeping Policy
		DHKLOG	View Data Housekeeping Policy execution log
RLDHKAUDIT	Data Housekeeping Auditor Role	DHKVIEW	View Data Housekeeping Policy
		DHKLOG	View Data Housekeeping Policy execution log

Data Housekeeping Summary

Search Policy

Prerequisites: Predefined Policy

To search for a Policy:

1. You can search a policy is through the Search drop-down option. Select Policy Name, Policy Type, Seeded Policy Flag, Last Execution Status, and Created By from Search drop-down.
2. Enter the Policy Name, Policy Type, Seeded Policy Flag, Last Execution Status, and Created By in Search Criteria and click Go.

Rows that contain the string you are searching for are fetched and displayed in the Data Housekeeping Summary.

The Data Housekeeping Summary displays the following information:

New Policy: Click the New Policy icon on the page header to build a new policy.

• Name: The policy name.
• Schedule: Shows the time when the policy is scheduled.
• Type: The Type (Archive, Drop Partition, Delete) of the policy.
• Seeded Policy Flag: Shows the type of policy as Yes if the policy is seeded.
• Last Run Date: The Date and Time when the policy was last modified.
• Created Date: the date when policy was created.
• Last Execution Status: The status of policy after execution.
• Actions: Click this icon to view a list of actions that you can perform on the Policy.
  • View: View existing policy.
  • Edit: Edit existing policy. To edit a rule, you must have Read/Write privilege.
  • Run: Select Run to execute an existing policy.
  • Authorize: Select Authorize to approve the policy for execution.
  • Withdraw Jobs: Select Withdraw Jobs to cancel the Job execution.
  • View Log: Select View Log to view the audit information of the policy. This information includes pending and running jobs.
  • Delete: You can delete policies that you no longer require. Note that only policy owners and those with Read/Write privileges can delete Policies. A policy that has a dependency cannot be deleted. A policy cannot be retrieved after deletion.