Mainframe

The student learns what has changed in DB2 Version 9, what has been added in this release, how the changes affect the activities that are associated with DB2.

The student will learn how to tune applications that use the DB2 environment, as well as design data bases to minimize the use of system resources.

Students who complete this course will be able to code SQL statements toaccess DB2 objects in CICS pseudo-conversational programs. The student also learns the performance tradeoffs inherent in specific design alternatives, and how to administer the DB2 / CICS attachment facility.

The student will learn how to normalize a relational database, and how to define DB2 objects, including Data Bases, Storage Groups, Table Spaces, Tables, Indexes, Views, and Aliases. The student will also develop a proficiency in loading, modifying, backing up, recovering, and tuning DB2 Data bases, using DB2 utilities, services aids, and catalog tables.

The student will learn how to utilize the features of Query Management Facility (QMF) on OS/390 or z/OS systems.

Students who complete this course will be able to code SQL statements to access DB2 objects using QMF. The student also learns how to use QMF forms to tailor the presentation of results from QMF queries.

The student will learn how to develop stored procedures in DB2, as well as how to invoke stored procedures from a host-based application.

The student will learn how to carry out Dynamic SQL statements in DB2.

Students who complete this course will be able to build efficient queries in DB2, using multiple tables. They will also be able to discern the underlying access strategy for a DB2 query, be able to define, load, and maintain DB2 tables. In addition, they will understand the use of packages, be able to utilize the distributed data base features of DB2, and be able to code programs that use the Call Attachment facility, Recoverable Resource Manager Attachment Facility, dynamic SQL, and stored procedures.

Students who complete this course will be able to code SQL statements to access DB2 objects, both using SPUFI under DB2I, and from within application programs in the student’s standard host environment – CICS, IMS/DB/DC, TSO, or batch. The student also learns how to establish the appropriate execution environment for programs that reference DB2 Data Bases.