CICS/TS & DB2 Application Design

 LENGTH OF COURSE:
5 Days

DESCRIPTION: The course will concentrate on designing systems which have minimal impact on resources and performance. Students will gain the ability to design a small system and create the objects necessary to support the application. Students will review both CICS/TS and DB2 considerations throughout the course.

PREREQUISITES: Prior DB2 and CICS/TS Experience or Education.

INSTRUCTION TECHNIQUES: A combination of Lecture, and Hands-On Labs (when/where available).

AUDIENCE

This course is designed for the Application Programmer, Analyst or Manager that is involved in the design, testing/debugging and implementation of CICS/TS / DB2 Systems.
KEY HIGHLIGHTS:

  • CICS/TS Design and System Overview
    • CICS/TS System Review
    • CICS/TS Control Components
      • Includes CICS/TS Transaction Flow and COBOL Coding
    • CICS/TS Application Program Environment
    • CICS/TS Screen Design and Prototyping
    • CICS/TS Screen and Terminal Control
      • Minimize Data Transmission with MDT's
      • Data Only Sends
        • Map Only
        • Data Only
        • Erase AUP
  • DB2 Design and System Overview
    • DB2 Relational Concept Overview
    • DB2 Concepts
      • Includes Attachments
      • Interfaces to CICS/TS and Thread Establishment (RCT)
    • DB2 Database Design
      • Entities
      • Attributes
      • Relationships
      • Normalization
      • Design


  • DB2 Application Design and DDL
  • DB2 / CICS/TS Program Preparation
    • CICS/TS Compile Flow
    • DB2 Compile Flow
    • Bind, Plans, Rebinds, Runstats, Reorgs, and Performance
    • Using Plans/Packages and the CICS/TS Resource Control Table
    • Program Prep and Change Flexibility
  • SQL in the DB2 / CICS/TS Environment
    • Predicate Modeling
    • CICS/TS / DB2 Performance and Index Utilization
    • EXPLAIN and Transaction Analysis
      • SQL Processing & Performance
      • DBAS and RDS
      • Predicate Types
      • Filter Factor and Transaction Performance
      • Access Path Selection
      • Index Usage
      • Join Techniques
      • Using EXPLAIN to improve Transaction Response Time


  • Referential Integrity and Design
  • Response Time and Throughput
  • Design and Recovery Considerations
  • Online Locking Considerations
  • CICS/TS / DB2 Security and Authorization


FROM OUR STUDENT EVALUATIONS...
"Great class -- tailored to our needs."

Gary Dodson
Internal Revenue Service

Return to Home Page.
Return to Alphabetic Listing of Courses.
Return to Courses by Subject.
Request More Information or Contact Us.