Kurs-ID: TDIBM_CV881G
Kurs Db2 13 for z/OS Advanced Database Administration
This course introduces advanced database administration skills, including program preparation and the use of packages, online schema changes, partition management, and stored procedures. Performance and availability features of utilities, including LOAD, REBUILD INDEX, REORG, and UNLOAD are covered.
This course does not cover distributed data processing or data sharing.
Seminarinhalte
- Unit 1: Program Preparation and the Use of Packages - Part 1
- Unit 2: Online Schema Changes - Part 1
- Unit 3: Online Schema Changes - Part 2
- Unit 4: Partition Management - Part 1
- Unit 5: Partition Management - Part 2
- Unit 6: Stored Procedures - Part 1
- Unit 7: LOAD and REBUILD INDEX
- Unit 8: REORG
- Unit 9: UNLOAD
- (Optional) Unit 10: Program Preparation and the Use of Packages - Part 2
- (Optional) Unit 11: Stored Procedures - Part 2
Kursthemen
Das Training Db2 13 for z/OS Advanced Database Administration ist folgendem Thema zugeordnet:
Zielgruppe
Administrators familiar with Db2 who wish to augment their skill set in administering Db2 13 for z/OS database environment.
Voraussetzungen
Before taking this course, you should have:
- Familiarity with the z/OS operating system, including TSO, ISPF, and SDSF
- Familiarity with SQL DML (SELECT, INSERT, UPDATE, and MERGE, as well as DDL statements (CREATE, ALTER, DROP)
- Basic skills administering a Db2 13 for z/OS database environment, including use of basic utilities, serialization, and basic database security
Dauer und Zeiten
2 Kurstage