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