ABORTING STATE : ReCoVery Manager or RCV Manager/RMAN

The ABORTING state indicates that the session is aborting its latest request.

“Do you want to get rid of the aborting session in the system from long time, to clean up such sessions quickly?”

1.       Use RCVManager to list/abort the Rollback process   OR

2.       Use Gateway Global to abort user session   OR

3.       Use Function to abort the session

4.       Hopeless ?  Then do TPA reset.(Teradata Database Bounce)

Teradata – Secure Zones

Secure Zones

This feature supports grouping of users, databases, and database objects into Secure Zones. Business Value This feature provides the following business value: Improves total cost of ownership for systems where data from multiple applications must be completely segregated. Addresses cloud/multi-tenancy security requirements for privileged user access and data segregation. Addresses regulatory compliance requirements to separate administration duties from access control. Provides companies that are multi-national the ability to prevent data from crossing boundaries (geographical, national, divisional, etc.).