Informix TimeSeries Data
The use of the “TimeSeries” data type, along with the associated benefits of compressed data storage, is conveyed.
Advanced
Informix Warehouse Accelerator (IWA)
The design, setup, installation, configuration, and usage of the Informix Warehouse Accelerator (IWA) are taught.
Informix server replication and high availability (HA)
To set up replication and to utilize, monitor, and manage essential Informix high availability features (HDR, SDS, RSS, CLR).
Informix server administration (extension)
Expansion and Deepening of Basic Knowledge.
Informix administration using the sysmaster database
The internal architecture of the database server and the optimal handling of the sysmaster database tables are covered.
Informix IDS Backup and Restore
Various methods of data backup – aside from the ontape tool – are taught.
Informix SQL optimization
The topics are “Identifying and Optimizing Problematic SQL Statements” and “The Benefits of Parallelized Queries.”
Db2 for LUW – Security
Db2 security concepts and objects are taught to enable the creation of a robust security framework.
Db2 for LUW – Explain and SQL access path analysis
Approaches and tools for analyzing complex SQL are taught.
Db2 for LUW – High Availability and Disaster Recovery (HADR)
The architecture, configuration, and operation of Db2 HADR are taught.