This course begins with a review the concepts and components of DB2 for OS/390.
DB2 commands and SQL will be used to focus on DB2 administration activities.
The relationships between object components will be presented along with communication and security aspects.
Design issues of referential Integrity, table check constraints, user defined data types and functions, and triggers are covered in detail.
Program design issues will be presented which effect concurrency, integrity and performance.
DB2 administration functions and utilities will be discussed in detail.
DB2 Application Performance considerations are reviewed.
LEARNING OBJECTIVES
After completing this course the student will be able to:
- Explain DB2 UDB for OS/390 concepts and facilities
- List and describe the components of DB2 UDB for OS/390
- Create Databases, Tablespaces and Tables to support application development and user data access
- Perform database and tablespace recovery
- Run LOAD, UNLOAD, and CHECK DATA utilities
- Discuss the RUNSTATS utility's capabilities
- Implement DB2's Referential Integrity, Check Constraints, User Defined Distinct Types and User Defined Functions, and Triggers.
- Discuss DB2 Security and Locking / Serialization considerations
- Discuss DB2 Performance considerations
- Discuss differences implemented in DB2 UDB for OS/390 Version 7
Audience
System administrators, database administrators, and technical personnel who are involved with planning, implementing, and maintaining the DB2 UDB for OS/390 environment.
Prerequisites
Six months of OS/390 experience is required. Six months of SQL experience is highly recommended. An understand of basic relational database concepts and objects such as tables, indexes, views, and joins is highly recommended.
Course duration
3 days
Course outline
|
DAY 1
|
| |
- The DB2 Concepts and Terminology
- Creating databases and tablespaces
- Creating Tables and other objects
|
|
DAY 2 |
| |
- Security and Locking
- DB2 utilities I - LOAD, CHECK DATA, RUNSTATS
- DB2 utilities II - COPY, REORG, UNLOAD
- Tablespace Recovery - RECOVERY
|
|
DAY 3 |
| |
- Programming and Performance
- DB2 Version 7 changes
|
Appendices
|
| Appendix A - IBM Sample Tables |
Appendix I - "Common" SQL Errors |
| Appendix B - Bibliography |
Appendix J - Version 6 Functions Summary |
| Appendix C - The Programming Workshop |
Appendix K - UDT and UDF |
| Appendix D - EXPLAIN PLAN Statement and PLAN_TABLE and DSN_STATEMNT_TABLE |
Appendix L - Cast Testing |
| Appendix E - Hints to Success |
Appendix M - Trigger Introduction |
| Appendix F - SQLCODES / SQLSTATES |
Appendix N - DB2 for WINDOWs Overview |
| Appendix G - QMF Overview |
Appendix Z6- Changes Summary - DB2 V 6 |
| Appendix H - Stored Procedures |
Appendix Z7- Changes Summary - DB2 V 7 |
|
