Sunday, October 04, 2015

Challenges of being a Tandem DBA

  • Repartition
    • Reviewing and updating key values
    • Merging Partitions
  • Reuse Partitions
  • Update statistics
    • Gathering SQL/MX statistics
    • Copy Statistics from One Table (or system) to Another
  • Index maintenance
    • Create
    • Populate
    • Drop
    • Alter
  • Specifying Access Previleges
    • Grant
    • Revoke
  • Query Performance Tuning
  • Building and Deploying Standard Queries
  • Dataload/Unload
    • Moving Data from MP to MX for Testing

No comments: