Course announcements

  • Students that complete EDB795 and practice the skills learned will be able to expertly administer an SAP IQ system. This course will teach you how to configure, manage, secure, and troubleshoot multiplex and non- multiplex IQ databases.

Goals

  • Implement an optimum server configuration through the use of disk management, memory allocation, and database options Understand the Information Lifecycle Management process
  • Understand the effects of creating system logins, nodes, dbspaces and objects in a Multiplex environment
  • Optimize data provisioning into IQ using bulk loading and row level versioning
  • Manage unstructured data in IQ
  • Implement full text search in IQ
  • Extract and load data into SAP IQ from a variety of external remote sources using Component Integration Services (Smart Data Access)
  • Implement advanced security controls, including encryption and Kerberos
  • Monitor IQ using sp_iqsysmon and other tools
  • Troubleshoot and repair an IQ database
  • Describe the best practices in administering SAP IQ

Audience

  • Database Administrator

Prerequisites

Essential

  • Understanding of database concepts and database fundamentals
  • EDB785: SAP IQ Administration
  • 2-4 years’ DBA experience

Recommended

  • None

Course based on software release

  • SAP IQ 16 Service Pack 3

Content

  • SAP IQ Overview
    • SAP IQ Overview
  • Sizing and Configuration
    • Database Sizing Configurations
    • Memory Considerations
    • CPU and Thread Considerations
    • Network Considerations
    • Database Options
  • Information Lifecycle Management
    • IQ Dbspaces
    • Managing Dbspaces
    • Object Positioning
    • Table Partitioning
    • Information Lifecycle Management
  • Multiplex Management
    • Multiplex Architecture
    • Managing Multiplex Servers
    • Running Multiplex Transactions
    • Running DDL Commands
    • Handling Dynamic Collisions
  • Data Provisioning
    • Data Provisioning
    • Bulk Loading Best Practices
    • Data Copy Best Practices
    • Row Level Versioning
  • Unstructured Data Analytics
    • Unstructured Data Analytics
    • Full Text Search
    • Importing and Exporting LOB Data
    • Managing LOB Data
  • Remote Data Access
    • SAP IQ and Remote Data
    • Setting Up Remote Access
    • Query Processing
    • Troubleshooting Remote Data Access
  • Advanced Security Topics
    • SAP IQ Security Management
    • Enhancing Data Security
    • Data Encryption
    • SAP IQ Advanced Security
  • Advanced Monitoring and Diagnostics
    • SAP IQ Diagnostic Output
    • Analyzing Hardware Resource Allocation
    • Using the sp_iqsysmon Monitor
  • Advanced Troubleshooting
    • Troubleshooting IQ
    • Advanced Database Repair
    • Advanced Database Recovery
  • Best Practices
    • Data Modeling
    • Tables, Datatypes and Indexes
    • SQL Development
    • System Configuration