Informix Dynamic Server 11 New Features Training  

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