Základní info
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.
Kurz je určen pro:
This intermediate course is designed for IDS Administrators, Database Administrators, and Applications Developers.
Předpokládané znalosti:
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
Co se u nás naučíte:
- 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
Obsah:
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
