| Main Office: | 800.631.0410 | |
|---|---|---|
| Sales Office: | 800.533.3893 |
DB2 data types; null values; generated values; key columns; referential integrity; other constraints; table exit routines; performance considerations; creating tables.
Catalog and directory databases; other system databases; DB2 data objects; creating and modifying DB2 objects; deleting DB2 objects.
VSAM dataset requirements; naming convention; page set structure; large object considerations; storage calculation and estimation.
Index structure; index keys and pointers; choosing indexes; index creation; access path determination; filter factors; using EXPLAIN; optimization hints.
Entity integrity; referential integrity; reasons for locking; lock types; lock compatibility; lock size; lock duration; lock avoidance.
Security overview; security terminology; implicit, explicit and grouped privileges; maintaining security using data control language; ownership considerations.
Utility packaging; on-line utilities; stand-alone utilities; LISTDEF and TEMPLATE; invoking and controlling utilities.
COPY; COPYTOCOPY; MERGECOPY; QUIESCE; RECOVER; REBUILD; REPORT; MODIFY; BACKUP SYSTEM; RESTORE SYSTEM.
DSN1COPY; DSN1PRNT; DSNJU003; DSNJU004; DSN1LOGP; DSN1CHKR, DSN1COMP; DSN1LOGF; DSNJCNVB.
Precompile; bind; bind authorizations; collections, packages and plans.
The materials in the course reflect DB2 UDB for z/OS Version 8/9. This course provides attendees with a comprehensive introduction to designing and administering DB2 databases. The course covers the complete spectrum from initial data model, through logical and physical database design, data security, and ongoing administration to ensure that the data remains complete, consistent, and in its most efficient state. After completion delegates will know:
- Data modelling techniques.
- The process of normalisation of data.
- Mapping data models to DB2 objects.
- Choosing the correct data types, and physical design characteristics.
- Data integrity issues.
- Page layouts and storage estimations.
- Indexing, locking strategy and other performance implications.
- Use of utilities and service aids in ongoing maintenance.
- Security and auditing considerations.
This course will be of interest to anyone needing an understanding of the design, implementation, support and maintenance of DB2 databases at versions 8.x or 9.
A fundamental understanding of the DB2 relational database management system is assumed, as is an understanding of data processing in general. Familiarity with the z/OS operating systems and TSO/ ISPF would also be of benefit.
| Code | Course Title | Duration | Level | |
|---|---|---|---|---|
DB2AU |
DB2 Administration for Linux, Unix and Windows |
5 Days |
I |
Details |
DB2M |
Advanced DB2 Application Programming |
3 Days |
II |
Details |
DB2ST |
DB2 System Performance Tuning |
5 Days |
II |
Details |
DB2M9 |
DB2 UDB/390 Version 9 Transition |
2 Days |
II |
Details |
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.