DB2 school training courses in Chicago, IL (public, in-house or online)

Learn how to design and implement recovery and restart procedures for DB2 UDB for z/OS and OS/390. Emphasize the three most difficult recovery emergencies: conditional restart, broken catalog/directory, and off-site recovery. Design and set up procedures for database recovery (point-in-time or application point of consistency), and catalog/directory or database broken data recovery. More than half of the course is devoted to hands-on labs and lab reviews.

Course Materials

The cou...

Full archival course description>>

This is an advanced course for experienced database administrators who plan and implement recovery and high availability plans for DB2 9 for Linux, UNIX and Windows databases using single or multiple partition DPF databases. The lab exercises can be performed using a single partition or a multiple partition DPF database using DB2 Enterprise 9 for Linux.


Skills Taught

--------------------------------------------------------------------------------

After completing this...

Full archival course description>>

This is an advanced course for senior system administrators, senior database administrators, and senior technical system professional individuals, who plan, implement, recover, and maintain DB2 UDB for z/OS and OS/390.


Skills Taught

--------------------------------------------------------------------------------

Implement sysplex component recovery procedures
Use database recovery procedures
Implement subsystem recovery procedures
Use coupling facility reco...

Full archival course description>>

This is an advanced course for senior system administrators, senior database administrators, and senior technical system professional individuals, who plan, implement, and maintain DB2 UDB for z/OS and OS/390.


Skills Taught

--------------------------------------------------------------------------------

Describe DB2 for OS/390 or z/OS data sharing components
Describe an OS/390 or z/OS Parallel Sysplex environment
Understand how DB2 data sharing utilizes OS/390...

Full archival course description>>

This is a basic course for individuals who need to write, support, or understand SQL queries. This includes but is not limited to end users, programmers, application designers, database administrators, and system administrators.


Skills Taught

--------------------------------------------------------------------------------

Write basic Data Manipulation Language (DML) SQL statements
SELECT
INSERT
UPDATE
DELETE
Write basic Data Definition Language (DDL...

Full archival course description>>