IBM Db2 12 for z/OS Basic Database Administration
Retail Price: $2,475.00
Next Date: 04/29/2024
Course Days: 3
Enroll in Next Date
Request Custom Course
Who Can Benefit
- Students who will be performing the role of Db2 for z/OS database administrators who need to acquire the basic skills required to administer a Db2 database.
Prerequisites
- Familiarity with the z/OS operating system, including TSO, ISPF, and SDSF
- Familiarity with SQL data manipulation statements (SELECT, INSERT, UPDATE, and DELETE) to access and change the contents of Db2 tables
Course Outline
Preface
- Course Overview
- Intended Audience
- Course Objectives
- Prerequisites
Unit 1 - Db2 Relational database concepts
- Relational Database design
- Data access
- Interacting with Db2
- Catalog and directory
Unit 2 - SQL and SPUFI
- SQL SELECT statement review
- SQL INSERT, UPDATE, DELETE review
- SQL COMMIT and ROLLBACK review
- Joining tables
- Executing SQL using SPUFI
Unit 3 - Db2 objects (Storage groups, databases, and table spaces)
- Object concepts
- Storage Groups
- Databases
- Table Spaces
Unit 4 - Db2 Objects (Tables, indexes, and views)
- Tables
o Aliases
- Table constraints
o Primary key
o Foreign key
o Check
o Referential integrity
- Indexes
- Views
- Qualified names
- Implicit object creation
Unit 5 - Utilities
- Utility Categories
- Load Utility
- Check Data Utility
- Unload Utility
- Runstats Utility
- Reorg Utility
Unit 6 - Commands and program preparation
- Db2 Command Structure
- Display Command
- Archiving Logs
- Stop and Start Commands
- Executing Commands
- Program Preparation
Unit 7 - The Db2 system
- System Parameters (zParms)
- Address Spaces
- System Databases
- Buffer Pools
- Logging
- Integrity
- Security
Unit 8 - Db2 Shutdown, startup, and recovery
- Start and Stop Commands
- Db2 Shutdown Process
- Db2 Startup Phases
- System Recovery
- Object Recovery
- Copy Utility
- Recover Utility
Appendix A - Demonstration solutions
Course Dates | Course Times (EST) | Delivery Mode | GTR | |
---|---|---|---|---|
4/29/2024 - 5/1/2024 | 9:30 AM - 5:30 PM | Virtual | Enroll |