Db2 for LUW – Administration basics workshop
This workshop provides the necessary knowledge to set up and operate a Db2 LUW database management system.


LIS.TEC has been active in the training system for more than 25 years and has by far trained the most training participants in the Db2 environment. Today, in addition to Db2 and Informix, our offer also includes HCL solutions. Our excellent expertise from project practice and theory, as well as the resulting synergy effects, make our team a competent training partner for database and HCL solutions. We train you individually tailored to your current knowledge and your needs.
Contact us and you will receive a qualified consultation about suitable training paths and possibly customized trainings for you.

Are you interested in HCLSoftware training courses or would you like to learn more about our training offer? Then talk to us directly. Together we will find the right training for your level of knowledge and your requirements – individually, in a practical manner and tailored to your environment. Our team will be happy to advise you personally on available training, content and possible training paths in the HCLSoftware environment.
This workshop provides the necessary knowledge to set up and operate a Db2 LUW database management system.
This workshop provides the necessary knowledge to set up and operate a Db2 LUW database management system, including an additional day dedicated to supplementary topics.
For beginners who wish to familiarize themselves with Db2 administration and SQL in a short period of time.
Db2 security concepts and objects are taught to enable the creation of a robust security framework.
Approaches and tools for analyzing complex SQL are taught.
The architecture, configuration, and operation of Db2 HADR are taught.
Concepts and objects of the Db2 Workload Manager, as well as implementation procedures, are covered.
The methodology and key tools for error analysis are taught.
Learn and understand the concepts of the SQL Procedure Language (SQL/PL).
Fundamental knowledge is imparted to enable the monitoring and secure operation of the database in daily use, as well as the optimal utilization of its available functionalities.
To set up replication and to utilize, monitor, and manage essential Informix high availability features (HDR, SDS, RSS, CLR).
The design, setup, installation, configuration, and usage of the Informix Warehouse Accelerator (IWA) are taught.
Various methods of data backup – aside from the ontape tool – are taught.
The topics are “Identifying and Optimizing Problematic SQL Statements” and “The Benefits of Parallelized Queries.”
The use of the “TimeSeries” data type, along with the associated benefits of compressed data storage, is conveyed.
The internal architecture of the database server and the optimal handling of the sysmaster database tables are covered.