This course teaches basic database administrative tasks using DB2 10.1 for Linux, UNIX, and Windows. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. The access strategies selected by the DB2 Optimizer will be examined using the DB2 Explain tools.Various diagnostic methods will be presented, including using the db2diag.log file messages to direct your investigation of problems, as well as using the db2pd commands.
Click Here to Request It.
- Instructor Led Online
CL285G – Quick Basics of DB2 Administration for Windows
This course teaches basic database administrative tasks using DB2 10.5 for Linux, UNIX, and Windows. These tasks include creating database objects like table, indexes and views and loading data into the database with DB2 utilities like LOAD and INGEST. Various diagnostic methods will be presented, including using various db2pd command options and monitoring using SQL statements with DB2 monitor functions. Students will learn how to implement automatic archival for database logs and how to recover a database to a specific point in time using the archived logs. Locking performed by DB2 and the effect the application isolation level has on locking and lock wait conditions are covered. This course provides a quick start to DB2 database administration skills for experienced relational Database Administrators (DBA).
The lab exercises are performed using DB2 LUW 10.5 for Windows. For some exercise tasks students will have the option to complete the task using a DB2 command line processor or using the graphical interface provided by IBM Data Server Manager.
CL450G – Implementation and Use of DB2 BLU Acceleration
This course covers the implementation of DB2 BLU Acceleration and column-organized table support, for a new or existing DB2 database. Students will learn to describe how the column dictionaries used for DB2 BLU Acceleration are built and utilized to provide extreme compression for column-organized tables. Students will get practical experience in the planning and utilization of the DB2 BLU Acceleration functions, using DB2 LUW commands, utilities and SQL statements, and by performing a lab exercise using DB2 Advanced Enterprise Edition 10.5 installed on a Linux platform.
CL485G – DB2 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs
This course teaches basic and advanced, database administrative tasks using DB2 10.5 for Linux, UNIX, and Windows. Students will learn how to implement automatic archival for database logs and how to plan a redirected database restore to relocate either selected table spaces or an entire database. The REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces, will be discussed.
- Instructor Led Online
KM204G – IBM InfoSphere DataStage Essentials
This course enables the project administrators and ETL developers to acquire the skills necessary to develop parallel jobs in DataStage. The emphasis is on developers. Only administrative functions that are relevant to DataStage developers are fully discussed. Students will learn to create parallel jobs that access sequential and relational data and combine and transform the data using functions and other job components.
KM213G – IBM InfoSphere QualityStage Essentials
This course teaches students how to build QualityStage parallel jobs that investigate, standardize, match, and consolidate data records. Students will gain experience by building an application that combines customer data from three source systems into a single master customer record.
KM404G – IBM InfoSphere Advanced DataStage: Parallel Framework
This course is designed to introduce advanced parallel job development techniques in DataStage v11.5. In this course students will develop a deeper understanding of the DataStage architecture, including a deeper understanding of the DataStage development and runtime environments. This will enable you to design parallel jobs that are robust, less subject to errors, reusable, and optimized for better performance.
KM413G – IBM InfoSphere Advanced QualityStage
This course introduces students to the QualityStage data cleansing process. Students will transform an unstructured data source into a format suitable for loading into an existing data target. Students will cleanse the source data by building a customer rule set that they create and use that rule set to standardize the data. Students will next build a reference match to relate the cleansed source data to the existing target data.
- Instructor Led Online
KM423G – IBM InfoSphere DataStage – Advanced Data Processing
This course is designed to introduce students to advanced parallel job data processing techniques in InfoSphere DataStage v11.5. In this course students will develop data techniques for processing different types of complex data resources including relational data, unstructured data (Excel spreadsheets), and XML data. In addition, students will learn advanced techniques for processing data, including techniques for masking data and techniques for validating data using data rules. Finally, students will learn techniques for updating data in a star schema data warehouse using the DataStage SCD (Slowly Changing Dimensions) stage. Even if students are not working with all of these specific types of data, they will benefit from this course by learning advanced DataStage job design techniques, techniques that go beyond those utilized in the DataStage Essentials course.