Db2 12 for z/OS Basic Database AdministrationCV844GIBIBMIB-CV844G1<ul>
<li>Familiarity with the z/OS operating system, including TSO, ISPF, and SDSF</li><li>Familiarity with SQL data manipulation statements (SELECT, INSERT, UPDATE, and DELETE) to access and change the contents of Db2 tables</li></ul><ul>
<li>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.</li></ul><p>Preface
</p>
<ul>
<li>• Course Overview</li><li>• Intended Audience</li><li>• Course Objectives</li><li>• Prerequisites</li></ul><p>
Unit 1 - Db2 Relational database concepts
</p>
<ul>
<li>• Relational Database design</li><li>• Data access</li><li>• Interacting with Db2</li><li>• Catalog and directory</li></ul><p>
Unit 2 - SQL and SPUFI
</p>
<ul>
<li>• SQL SELECT statement review</li><li>• SQL INSERT, UPDATE, DELETE review</li><li>• SQL COMMIT and ROLLBACK review</li><li>• Joining tables</li><li>• Executing SQL using SPUFI</li></ul><p>
Unit 3 - Db2 objects (Storage groups, databases, and table spaces)
</p>
<ul>
<li>• Object concepts</li><li>• Storage Groups</li><li>• Databases</li><li>• Table Spaces</li></ul><p>
Unit 4 - Db2 Objects (Tables, indexes, and views)
</p>
<ul>
<li>• Tables</li><li> o Aliases</li><li>• Table constraints</li><li> o Primary key</li><li> o Foreign key</li><li> o Check</li><li> o Referential integrity</li><li>• Indexes</li><li>• Views</li><li>• Qualified names</li><li>• Implicit object creation</li></ul><p>
Unit 5 - Utilities
</p>
<ul>
<li>• Utility Categories</li><li>• Load Utility</li><li>• Check Data Utility</li><li>• Unload Utility</li><li>• Runstats Utility</li><li>• Reorg Utility</li></ul><p>
Unit 6 - Commands and program preparation
</p>
<ul>
<li>• Db2 Command Structure</li><li>• Display Command</li><li>• Archiving Logs</li><li>• Stop and Start Commands</li><li>• Executing Commands</li><li>• Program Preparation</li></ul><p>
Unit 7 - The Db2 system
</p>
<ul>
<li>• System Parameters (zParms)</li><li>• Address Spaces</li><li>• System Databases</li><li>• Buffer Pools</li><li>• Logging</li><li>• Integrity</li><li>• Security</li></ul><p>
Unit 8 - Db2 Shutdown, startup, and recovery
</p>
<ul>
<li>• Start and Stop Commands</li><li>• Db2 Shutdown Process</li><li>• Db2 Startup Phases</li><li>• System Recovery</li><li>• Object Recovery</li><li>• Copy Utility</li><li>• Recover Utility</li></ul><p>
Appendix A - Demonstration solutions</p><p>Preface
</p>
<ul>
<li>• Course Overview</li><li>• Intended Audience</li><li>• Course Objectives</li><li>• Prerequisites</li></ul><p>
Unit 1 - Db2 Relational database concepts
</p>
<ul>
<li>• Relational Database design</li><li>• Data access</li><li>• Interacting with Db2</li><li>• Catalog and directory</li></ul><p>
Unit 2 - SQL and SPUFI
</p>
<ul>
<li>• SQL SELECT statement review</li><li>• SQL INSERT, UPDATE, DELETE review</li><li>• SQL COMMIT and ROLLBACK review</li><li>• Joining tables</li><li>• Executing SQL using SPUFI</li></ul><p>
Unit 3 - Db2 objects (Storage groups, databases, and table spaces)
</p>
<ul>
<li>• Object concepts</li><li>• Storage Groups</li><li>• Databases</li><li>• Table Spaces</li></ul><p>
Unit 4 - Db2 Objects (Tables, indexes, and views)
</p>
<ul>
<li>• Tables</li><li> o Aliases</li><li>• Table constraints</li><li> o Primary key</li><li> o Foreign key</li><li> o Check</li><li> o Referential integrity</li><li>• Indexes</li><li>• Views</li><li>• Qualified names</li><li>• Implicit object creation</li></ul><p>
Unit 5 - Utilities
</p>
<ul>
<li>• Utility Categories</li><li>• Load Utility</li><li>• Check Data Utility</li><li>• Unload Utility</li><li>• Runstats Utility</li><li>• Reorg Utility</li></ul><p>
Unit 6 - Commands and program preparation
</p>
<ul>
<li>• Db2 Command Structure</li><li>• Display Command</li><li>• Archiving Logs</li><li>• Stop and Start Commands</li><li>• Executing Commands</li><li>• Program Preparation</li></ul><p>
Unit 7 - The Db2 system
</p>
<ul>
<li>• System Parameters (zParms)</li><li>• Address Spaces</li><li>• System Databases</li><li>• Buffer Pools</li><li>• Logging</li><li>• Integrity</li><li>• Security</li></ul><p>
Unit 8 - Db2 Shutdown, startup, and recovery
</p>
<ul>
<li>• Start and Stop Commands</li><li>• Db2 Shutdown Process</li><li>• Db2 Startup Phases</li><li>• System Recovery</li><li>• Object Recovery</li><li>• Copy Utility</li><li>• Recover Utility</li></ul><p>
Appendix A - Demonstration solutions</p>- 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- 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.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 solutionsPreface
- • 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 solutions3 jours2100.005080.00