Skip to main Content

IBM PureData System for Analytics Administration

  • Course Code DW575G
  • Duration 3 days

Additional Payment Options

  • GTC 46

    GTC, Global Knowledge Training Credit, please contact Global Knowledge for more details

Public Classroom

Public Classroom Price


Request Group Training Add to Cart

Course Delivery

This course is available in the following formats:

  • Company Event

    Event at company

  • Public Classroom

    Traditional Classroom Learning

  • Virtual Learning

    Learning that is virtual

Request this course in a different delivery format.

Course Overview


This course teaches participants operational aspects of database administration for the IBM PureData System for Analytics N1001 and N2001 appliances. This course is designed to teach participants about the High Availability, Backup and Restore and Security aspects of the IBM PureData System for Analytics N1001 and N2001 so that SLAs can be met and service maintained. In addition this course teaches the participant how to manage the performance characteristics of the system through workload management and system parameters. Lastly this course provides participants with the knowledge to assist developers in tuning SQL queries to maximize performance.

Course Schedule


Target Audience


Database administrators, system administrators, application developers, and data warehouse architects.

Course Objectives

  • Analyze Plan files
  • Perform query analysis and troubleshooting
  • Optimize data distributions
  • Interact with advanced CLI commands
  • Use nzsql
  • Detemine workload management requirements
  • Make use of the System Management functionality

Course Content

  • High availability architecture
  • DBOS internals and system log files
  • nzsql and scripting
  • nzevents and event processing
  • Optimizer and plan files
  • Analyzing plan files using EXPLAIN
  • Analyzing and optimizing plan performance
  • Workload management
  • System management and monitoring commands
  • System management and monitoring administration GUIs
  • Configuring query history
  • Backup and restore
  • Security including authenticating users with LDAP, SSL

Course Prerequisites


Participants who have successfully completed the IBM PureData Systems for Analytics Appliance Usage course have satisfied the prerequisite requirements to attend this course.

Hands on experience of administering an IBM PureData System for Analytics system would also be highly beneficial.