JCL - Basic VSE Job Control

Duration

Overview

Audience

Prerequisites

Objectives

• Understand the function of JCL
• Be familiar with the different parameters and the options that can be used with JCL
• Use the correct format when coding parameters
• Use JCL statements to select the job attributes required

Course Content

Module 1 VSE JOB STREAMS

• Basic format of Job Statement
• Job Name
• Accounting Information
• End of Job Statement
• Basic format of EXEC Statement
• Program Name
• Size Operand
• Parm Operand

Module 2 DOCUMENTING JOBS

• Format and function of the Pause Statement
• Format and function of the Comment Statement

Module 3 FILE LABELS AND ASSIGNMENTS

• Permanent and Temporary Statements
• Format of ASSGN Statement and the Operands used
• The TLBL Statement, format and operands
• The DLBL Statement, format and operands

Module 4 CREATING A VSE JOB

• Defect support for applications

Module 8 PRODUCTION SUPPORT: SECURITY AND AUTOMATION

• Continuous availability
• Database descriptors
• COPY SHRLEVEL CHANGE
• REORG SHRLEVEL CHANGE
• Auditing
• Security
• Automation
• Automation Levels Characteristics

Module 9 PRODUCTION SUPPORT: LOCKING AND CONCURRENCY

• Locking
• Locking hierarchy
• Transaction locks
• Intent Locks
• Tablespace locks
• Releasing locks
• Releasing Page/Row Locks
• Concurrency Options

Module 10 BACKUP AND RECOVERY

• Backup and recovery definition
• Copy Utility
• QUIESCE utility
• Report utility
• Data set retention
• Recover utility
• Rebuild utility
• Check Data Utility
• Modify utility
• The BSDS

Module 11 SECURITY

• Security definition
• Privileges
• Administrative authorities
• Secondary AUTH IDS
• Security Exits
• CICS Attachment facility options
• IMS Attachment facility options

Module 12 DATABASE CONNECTIVITY

• Connectivity definition
• DRDA
• DB2 Connect
• DRDA Levels
• CLI and ODBC
• JDBC
• DB2 Connect Personal edition
• DB2 Connect Enterprise edition

Module 13 PERFORMANCE MANAGEMENT: COMPONENTS AND FACILITIES

• Performance Management definition
• DB2 Architecture
• Optimizer statistics
• Default statistics
• DB2 Visual Explain
• DB2 Instrumentation Facility
• DB2 Estimator

Module 14 PERFORMANCE MANAGEMENT: DB2 ACCESS PATHS & EXPLAIN

• DB2 Explain
• PLAN_TABLE Usage
• Creating the PLAN_TABLE
• Populating the PLAN_TABLE
• DB2 Access Path Overview
• Tablespace Scan
• Matching Index Scan
• Index Screening
• Non-Matching Index Scan
• In-List Index Scan
• Multiple Index Access
• One Fetch Index Access
• Index Only Access
• Equal Unique Index
• Nested Loop Join
• Merge Scan Join
• Hybrid Join
• 12 Questions to ask

Module 15 CONSULTING AND PROJECTS

• Definition
• Reasons for Conversion
• Parallel Sysplex
• OO Programming (UDT)
• OO Programming (UDF)
• OO Programming (Triggers)
• Multimedia
• Client Server
• Data Replication