Request availability or book by selecting a date: England
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.
|
Course Overview The aim of this course is to give the delegate experience in the design process for DB2 tables and in physical database design, day-to-day administration, and to give ideas in defining a DB2 environment in an z/OS (OS/390) environment. A review of the normalisation process is also covered. Audience Database Administrators, Application Developers and Database Designers. Skills Gained On successful completion, the delegate will be able to design DB2 tables from a data model, define a physical database, code JCL to run DB2 utilities and investigate performance issues. By The End Of This Course You Will Have Learned - Table design
- tablespace creation
- table creation
- index creation
- performance implications
- DB2 utilities.
Prerequisites A basic knowledge of z/OS (OS/390) facilities and familiarity with using TSO/ISPF. A basic knowledge of SQL. Course Outline - Review of normalisation
- Denormalisation
- Creating tablespaces and tables
- Freespace considerations
- performance aspects
- sizing the tablespace
- column ordering
- data types
- VARCHAR usage
- date and time
- null columns
- data compression
- data validation
- row lengths
- Creating views
- CHECK option; updates using views
- DB2 indexes
- Creating indexes
- sizing the indexspace
- use of multiple indexes
- clustering indexes
- composite indexes
- primary and foreign keys
- DB2 security and auditing
- DB2 utilities
Load utility, reorg utility, runstats utility, etc - DB2 catalog tables
- Performance
The EXPLAIN command, the PLAN table, data and index structures, when to reorganise, access paths - Matching and non-matching index scans
- selecting which columns to index!
How to make a booking for the CM102 course
|
