Overview
In this course, you will learn about the new features that are included with the 11.70 release of IBM Informix. Features include a replication grid management facility, updated installer, fragmentation enhancements, new indexing options, new query optimization features, a debugger for stored procedure language (SPL) coding, new scheduler tasks, support for system and log backup to the Cloud, and many others. A new replication grid management facility provides a central administration tool for administration of HDR primary and secondary servers, RS server, SD servers, and Enterprise Replication participants. Embeddability and deployment tools are also included to enable users to package snapshots of Informix instances and data.
Public
This basic course is for IDS Administrators, Database Administrators, and Applications Developers.
Prerequisits
There are no prerequisites for this course.
Objective
- Explain the new features that are included with the 11.70 release of IBM Informix.
- Describe the purpose of
- replication grid management facility
- indexing options
- query optimization
- stored procedure language (SPL) coding
- Explain how the new replication grid management facility provides a central administration tool for administration of HDR primary and secondary servers, RS server, SD servers, and Enterprise Replication participants
Topics
System Administration Features
- Informix Mapped Users
- Partition Defragmenter
- Unique Event Alarms
- 11.70 Installer
- Deployment Assistant/Deployment Utility
- Embedability toolkit
- Storage Provisioning
- New Database Scheduler Tasks
- One-Step Instantiation Snapshot
- ASF Performance
- Backup to Cloud
- Implicit PDQ
- Trusted Context
Database Administration Features
- Auto Register of DataBlades
- Forest of Trees Index
- Multi-Index Scan
- Star Join and Snowflake Queries
- Selective Row-Level Auditing (SRLA)
- Fragmentation List and Interval Strategies
- Fragment Level Statistics
- New SQL
- Smart Analytics Optimizer
- Websphere MQ Enhancements for Informix
Replication/Grid
- DDL Support for HDR Secondary Servers
- ER Features
- Grid-Based Replication
Application Development
- C-UDR
- Programmability Enhancements
- SPL Debugger
