Db2 for z/OS: Introduction, Concepts & Facilities [DC]

This course introduces, describes and explains the fundamental principles of Db2 for z/OS. The course also explains the relational theory and concepts, and shows how Db2 adheres to them. The concepts of Db2 data storage, the Db2 system and its operation, Structured Query Language, the use of Db2 Interactive (DB2I), and the management of DB2 data using standard utility tasks are also introduced and explained 

2 Days

Hands-On

$1,450

Email at Info@zcubedtech.com  to find out more

• DBMS Overview
• Relational Theory & Concepts
• Db2 System Architecture
• Introduction to DB2 Interactive (DB2I)
• Db2 Data Objects
• Introduction to SQL
• Managing Db2 Data with Utilities
• Hands-on Exercises

• Describe the relational concepts and theory, and the advantages of a RDBMS. 
• Describe the components of the Db2 system, their function, and how they are controlled. 
• Identify the objects used to store Db2 data and the relationships between them. 
• Code the SQL statements needed to create and modify Db2 data objects, and control access to them. 
• Code SQL statements to read and modify Db2 data and interrogate the Db2 catalog. 
• Describe and fully utilize all the functions available with Db2 Interactive (DB2I). 
• Use online utilities to backup and restore data, and perform other data management tasks. 
• Describe the use of stand-alone utilities and identify situations where they may be required 

A basic understanding of IT, with some exposure to database technology as a user. Whilst not essential, a knowledge of TSO/ISPF would be beneficial 

Email at Info@zcubedtech.com  to find out more

This intensive course has been designed to provide a comprehensive understanding of the DB2 UDB for z/OS Structured Query Language and how it is embedded in application programs. Throughout the course reference will be made to best practices to ensure that the SQL and application programs will run efficiently and effectively

5 Days

Hands- On

$2,800

Email at Info@zcubedtech.com  to find out more

• DBMS Overview
• Relational Theory & Concepts
• Db2 System Architecture
• Introduction to Structured Query Language
• Introduction to DB2 Interactive (DB2I)
• Basic SELECT Statements
• SQL Built-in Functions
• Joins & Nested Table Expressions
• Unions, Exceptions, Intersections & CASE Expressions
• Subqueries
• Table Modification Statements
• The Db2 Optimizer and Access Path Selection
• Db2 EXPLAIN
• Basic Db2 Application Programming
• Cursor Processing
• Program Preparation & Execution
• Db2 Locking & Concurrency

• Use SPUFI to code SQL statements.
• Code SQL Select statements including those using techniques such as joins, nested table expressions, subqueries, unions and case expressions.
• Code SQL INSERT, UPDATE DELETE and MERGE statements to modify data.
• Identify access paths chosen by Db2 by using the EXPLAIN feature.
• Embed SQL statements into and application programming language such as COBOL, PL/I or Assembler. 
• Understand and control the locking strategy used by Db2 to maintain data integrity.
• Prepare and execute DB2 applications and understand the use of pre-compile and bind steps in the preparation process

Must be familiar with a major application programming language, e.g. COBOL, PL/1 or Assembler. Previous exposure to the z/OS environment and the ability to use TSO/ISPF would also be a big advantage 

Email at Info@zcubedtech.com  to find out more

This course provides a detailed understanding of the Db2 for z/OS facilities and procedures required to provide database users with efficient administration and support. It explains the system architecture and facilities of Db2 including monitoring, security and recovery techniques

3 Days

Hand-On

$2,350

Email at Info@zcubedtech.com  to find out more

• Db2 System Architecture
• Db2 Pagesets
• Db2 Security & Data Control Language
• Managing Data with Db2 Utilities - Overview
• Online Data Utilities
• Online Recovery Utilities
• Stand-alone Utilities
• Performance Tuning

• Describe the Db2 environment, and understand the use of key Db2 components such as buffer pools, the Db2 catalog and directory, logging data sets, etc.
• Describe the internal structure of Db2 UDB for z/OS databases
• Understand and assess security and related requirements
• Use Db2 commands to monitor and control Db2 objects, processes and operations
• Understand and use the full complement of Db2 online data and recovery utilities
• Understand and use the Db2 stand-alone utilities
• Use Db2 traces to record performance monitoring information
• Understand and interpret information in DB2PM accounting and statistics reports 

Attendees should be familiar with the Db2 environment and have knowledge of SQL or have attended courses DB2 for z/OS: Introduction, Concepts & Facilities [DC] and Understanding & Using SQL [DSQL] 

Email at Info@zcubedtech.com  to find out more