Overview
| Course code | 1X801 | Skill level | Basic |
|---|---|---|---|
| Duration | 2.0 days | Delivery type | Web Based Training |
| Course type | Public only | ||
| Public price | USD $250.00 plus tax | ||
Note: This is a self-paced online course. This course usually requires 15 hours to complete. Once you receive your access information, you will have 60 days access to this course.
In this course, students will learn about some of the new features introduced in Informix Dynamic Server, Version 11. They will learn how to use the new installation process to install IDS and other product components. They will also be introduced to the new 'MACH-11' replication features and will learn some basic information about configuring and administering the replication servers. Students will also learn how to implement greater security using the new Label-Based Access Control feature. In addition to system administration skills, students will also be introduced to new features that will be of interest to application developers.
This innovative self-paced online format is available from IBM Training and gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. Once you have accessed the course, instructor help is available via the course forum Monday through Friday; questions will be responded to within 24 hours. The course is available 24 hours a day.
Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access the course materials.
Audience
This is a basic course for IDS 10 Database Administrator who wants an introductory knowledge of the function and features in IDS 11.
Skills taught
Learning points in this course include:
- The continuous availability feature provided by IDS
- The impact of IDS in different industries
- The new features of IDS 11 for hands-free administration
- The installation modes for installing Informix Dynamic Server
- The deployment wizard, manifest file, and the installation files list
- Silent installation of Informix Dynamic Server
- High-Availability Data Replication (HDR) encryption and the parameters required for configuring HDR encryption
- The improvements for Enterprise Replication and the new dbspace ordering
- How to back up data to a directory with the ontape utility
- An overview of the Multi-node Active Cluster for High Availability (MACH-11) technology
- The interval checkpoint
- Automatic Least Recently Used (LRU) flush tuning, asynchronous I/O (AIO) virtual processor (VP) tuning, and automatic checkpoints
- Crash recovery and the recovery time objective (RTO)
- The new administration mode in IDS 11, and the commands for adding administration mode users
- The LBAC objects, including security policies, security labels, and security label components
- Security considerations for LBAC
- The enhancements to database administration and the update statistics process
- SQL-related, control-related, and performance-related features
- Various DataBlade modules and programming-related features
- Shared Disk Secondary (SDS) instances and how to configure an SDS instance
- The Distributed Relational Database Architecture (DRDA) communication protocol and the IBM Migration Toolkit (MTK)
Course outline
Introduction
- Describe IDS
- Describe the continuous availability feature provided by IDS
- Describe the impact of IDS in business
- Describe the new features of IDS 11 for facilitating administration
Installing Informix Dynamic Server
- Describe the installation modes for installing Informix Dynamic Server
- Describe the deployment wizard
- Describe the manifest file
- Describe the installation files list
- Describe silent installation
High-Availability Data Replication Encryption and Backup/Restore Facilities
- Describe HDR encryption
- List the parameters required for configuring HDR encryption
- Describe Enterprise Replication improvements
- Describe the new dbspace ordering
- Describe the use of the BAR_MAX_BACKUP parameter
- Describe how to back up data to a directory with the ontape utility
Introduction to MACH-11
- Describe the MACH-11 technology
- Describe SMX
- Describe index page logging and how it works
- Describe the similarities and differences between the RSS server and the HDR secondary server
- Describe the usage of RSS servers
- Describe the steps of setting up a RSS server
- Lists the commands used to display information about the RSS servers
- Describe SMI tables
- Describe continuous log restore
Checkpoint Improvements and Recovery Time Objective
- Describe the current issues with checkpoints
- Describe the interval checkpoint
- Describe the use of the onstat –g ckp command
- Describe the two new sysmaster tables
- Explain automatic LRU flush tuning
- Explain AIO VP tuning
- Describe the automatic checkpoint
- Describe the new configuration parameter RTO_SERVER_RESTART
- Describe the RAS_PLOG_SPEED and RAS_LLOG_SPEED configuration parameters
- List tuning recommendations
Administration Enhancements
- Describe the administration mode
- Describe the uses of the command oninit -U
- Describe the uses of the command onmode –j -U
- Describe the use of the ADMIN_MODE_USERS configuration parameter
Introduction to Label-Based Access Control
- Describe LBAC
- Describe security policies
- Describe security labels
- Describe security components
- Lists the three types of security label components
- Describe how to create and grant security labels
- Describe the SETSESSIONAUTH privilege
- Lists the utilities for importing, exporting, loading, and unloading data
- Describe the dbexport and dbimport issues
Improved Database and Instance Administration and Index Statistics Maintenance
- Explain the database administration improvements
- Describe the SQL query drill-down feature
- Describe the task() and admin() functions
- Describe the database scheduler
- Describe tasks and sensors
- Describe how to create tasks and sensors
- Describe improvements to the update statistics process
- Describe when data distributions and statistics will not be automatically created
- Describe the improvement to the SET EXPLAIN command
- Describe the improvement to the temporary table statistics
Application Development
- Describe cross-server and cross-database distributed queries
- List the newly supported as well unsupported data types in distributed operations
- Describe the use of the sysdbopen() and sysdbclose() functions
- Describe the improvement in statistics maintenance
- Describe the use of the Last Committed isolation level option
- Describe the in dex self-join access method
- Describe the two new data types provided by the Binary DataBlade module
- Describe hierarchical data types
- Describe the BTS DataBlade module
- Describe how to create BTS indexes
- Describe the MQ DataBlade module
- List the three PHP providers
- Describe the IBM Informix .NET provider
- Describe the IBM Data Server Developer Workbench
Shared Disk Secondary Instances and SQL
- Describe the SDS instance
- Describe the use of Log Sequence Number (LSN)
- List the configuration parameters for an SDS instance.
- Describe how to instantiate an SDS instance
- Describe the ways of obtaining SDS instance statistics
- Describe the SQL comment delimiters supported by Informix Dynamic Server 11
- Describe the use of the SQL comment delimiters
- List the new SQL functions supported by Informix Dynamic Server 11
- Describe the MTK
- Describe how the MTK works
- Describe the DRDA communication protocol
- Describe how to configure DRDA communication between a client and an IDS instance
My IBM
We're here to help
Easy ways to get the answers you need.
or call us at
Call 1-800-426-8322
Open M-F 9AM-7PM ET.
