Skip to main content

Course description: Informix Dynamic Server 11 New Features

This course is not scheduled. Inquire about Onsite training at your facility.

Overview

List of course details in a data table
Course code IX301 Skill level Intermediate
Duration 3.0 days Delivery type Classroom
(Hands-on labs)
Course type Public or Private on-site    
Public price USD $1,950.00 plus tax  

This course discusses the new features available in IBM Informix Dynamic Server V11, including new features added for V11.5. There will be several labs accompanying this course which will allow you to get hands-on experience with some of these new features. This course is the classroom delivered version of Instructor Led OnLine course 3X301.

View this course in other countries


Training Paths that reference this course are:

Back to top

Special note

IBM Education Advantage Program eligibility:

  • Yes - IBM Education Pack - online account

Back to top

Audience

This intermediate course is designed for IDS Administrators, Database Administrators, and Applications Developers.

Back to top

Prerequisites

You should have following IBM courses:

  • IBM Informix Dynamic Server 11 System Administration (IX811)
  • Informix Dynamic Server Database Administration: Managing and Optimizing Data (IX220)
  • Database Administrator (DBA) or Systems Administration experience on an Informix Dynamic Server system can substitute for classroom training.

Back to top

Skills taught

  • Install and configure Informix Dynamic Server 11.
  • Use new SQL routines to execute administrative commands and create tasks.
  • Describe and use new backup and restore features.
  • Explain the new checkpoint features of IDS 11 and how they enhance fault tolerance.
  • Describe and demonstrate the use of new database administration features of Informix Dynamic Server 11.
  • Execute queries that use new SQL features.
  • List and describe new Hierarchical Dynamic Retrieve (HDR) and ER features.
  • Explain Remote Standalone Secondary replication and set up an RSS server.
  • Explain Shared Disk Secondary replication and configure an SDS node.

Back to top

Course outline

System Administration Features

  • Describe how the deployment wizard improves the installation process
  • Use ontape to backup logical logs and dbspaces to a directory
  • Describe new parallel backup and restore, and dbspace ordering features of On-Bar
  • Configure private memory caches for CPU VPs

SQL Administration Commands

  • Use SQL commands to perform system administration tasks
  • Use the built-in scheduler to automatically perform routine tasks

Fault Tolerance Features

  • Describe how checkpoint enhancements improve user concurrency and checkpoint/recovery performance
  • Configure the server to dynamically allocate LRUs and AIO VPs

Database Administration Features

  • Describe the features of the Committed Read Last Committed isolation level
  • Use SQL Trace to analyze SQL statements
  • Describe how the optimizer uses index self-joins

UPDATE STATISTICS Enhancements

  • Describe the new Update Statistics features

Advanced Access Control (LBAC)

  • Configure data security using LBAC

SQL Enhancements

  • Use the new optimizer directive features
  • Describe the syntax for using derived tables in the FROM clause of SQL queries
  • Verify data currency using a version column
  • Use the IS [NOT] NULL predicate in SQL expressions
  • Improve performance by using the Large Integer and Large Serial data types
  • List the data types now supported for cross-server distributed queries
  • Utilize the new enhancements to triggers
  • Create XML documents using SQL

DataBlade Modules

  • Describe how to use the Node DataBlade Module to index hierarchical data
  • Describe the new indexable binary data type feature
  • Configure the Basic Text Search DataBlade Module and search textual content utilizing BTS

Replication Features

  • Describe various IDS availability options
  • Describe new encryption feature for HDR
  • Describe new Enterprise Replication features

Introduction to Continuous Availability

  • Explain what is meant by continuous availability
  • Describe the purpose of the Connection Manager
  • Explain the configuration requirements for Connection Manager

Remote Standalone Secondary Replication

  • Describe the benefits of remote standalone secondary replication
  • Configure and implement RSS replication
  • Perform steps required to respond to a failover.

Shared Disk Secondary Replication

  • Describe the benefits of shared disk secondary replication
  • Configure and implement SDS replication
  • Perform steps required to respond to a failover

Agenda

Day 1

  • Welcome
  • Unit 1: Installation and Configuration Exercise 1
  • Unit 1: Backup and Restore Features Unit 1: Other Administration Features
  • Exercise 2
  • Unit 2: SQL Administration Commands
  • Exercise 3
  • Unit 3: Fault Tolerant Features
  • Exercise 4

Day 2

  • Unit 4: Database Administration Features
  • Exercise 5
  • Unit 5 UPDATE STATISTICS Enhancements
  • Exercise 6
  • Unit 6: Label-Based Access Control
  • Exercise 7
  • Unit 7: SQL Enhancements
  • Exercise 8
  • Unit 7: XML Publishing
  • Exercise 9
  • Unit 8: DataBlade Modules: Node DataBlade
  • Exercise 10
  • Unit 8: DataBlade Modules: Binary DataBlade
  • Unit 8: DataBlade Modules: Basic Text DataBlade
  • Exercise 11

Day 3

  • Unit 9: Replication Features
  • Unit 10: Introduction to Continuous Availability
  • Unit 11: Remote Standalone Secondary Replication
  • Exercise 12
  • Unit 12: Shared Disk Secondary Replication
  • Exercise 13

Back to top

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.

Student center

Find the right course

Offers and more