Duration
4 hours
Overview
Description
The Labs – Db2 12 for z/OS provide a range of simulations and exercises, the latter of which can be run on your organization’s mainframe training sandbox. Initial exercises focus on operational aspects of Db2 including the starting and stopping, of Db2 on z/OS. It then moves to commands used to display Db2 structures and content, and methods used to gather Db2 data that can be subsequently used to resolve Db2 system and performance issues. The last exercise concentrates on using SQL predominantly to create a working database, so, the creation of table spaces, tables, indexes, keys, as well as the loading of data into tables.
Audience
The majority of the lab exercises are suitable for Operators, Systems Programmers, and Database Administrators (DBAs) as it focuses on the operation, and management of the Db2 subsystem. The SQL exercise is suitable for anyone requiring a knowledge of Db2 structures and components, so, those staff names above and also Application Programmers who deal with Db2 data.
Prerequisites
A general understanding of z/OS, and the successful completion of the following Interskill courses:
- Db2 – Db2 Fundamentals v12
- Db2 – Managing Db2 Operations v12
Each Lab module below contains its own list of prerequisites or equivalent knowledge, which is displayed when accessing the module.
Objectives
After completing these labs, the student will be able to:
- Start and stop a Db2 subsystem
- Enter commands to determine the status and availability of Db2
- Display Db2 buffer pool attributes
- Modify the size and other attributes of Db2 buffer pools
- Display and cancel Db2 threads
- Display the status of Db2 utilities
- Manage Db2 log activity
- Display, start, and stop a Db2 trace
- Use z/OS commands to identify Db2-related problems
- Issue a dump command for Db2 address spaces
- Create a Db2 database, and table space
- Create tables and add data to them
- Create indexes for tables
- Copy and recover Db2 data
- Delete Db2 data
Course Content
Lab Db2 – Startup and Shutdown
Manually Starting Db2
Using an Alternate Parameter Load Module to Start Db2
Allocate Specific Access During Db2 Startup
Configure Db2 Attributes at Startup
Locating Db2 Startup Procedures
Investigating how Automation is Used to Start Db2
Identifying Db2 Startup Parameters Used by Your Organization
Determining Db2 Subsystem Status
Displaying Active Db2 Subsystem Attributes
Manually Stopping Db2
Stopping Db2 Using a FORCE Parameter
Suspending Db2 Activity Before a Shutdown
Identifying your Organization’s Process for Manually Shutting Down Db2
Investigating Past Db2 Shutdown Problems
Lab Db2 – Db2 Buffer Pools
Displaying General and Detailed Buffer Pool Configuration
Modifying Buffer Pool Size
Altering Buffer Pool Attributes
Investigating your Organization’s Buffer Pool Use
Identifying your use of Simulated Buffer Pools
Investigating Third-Party Tools used to Manage Db2 Buffer Pools
Lab Db2 – Operations Troubleshooting
Displaying Threads
Canceling Threads
Canceling a DDF Thread Using VTAM Commands
Displaying Active Utilities
Terminating a Utility
Displaying Log Attributes
Manually Archiving Logs
Canceling an ARCHIVE LOG Request
Suspending Log Activity
Investigating Past Log Problems
Lab Db2 – Running Diagnostics
Displaying Traces
Stopping Traces
Starting a Trace and Defining Attributes
Investigating Commonly Run Traces
Identifying Products Used to View Trace Output
Displaying Thread Details
Entering z/OS Commands to Display System Activity
Displaying Database Details
Investigating Supporting Documentation Required by your Organization
Creating a Db2 Address Space Dump
Lab Db2 – Creating a Database
Identifying Db2 Storage Groups
Creating a Db2 Database
Creating a Table Space
Creating Tables and Indexes
Loading Data Into Tables
Granting Access to a Table
Sorting Table Data
Combining Table Data
Copying and Recovering Data
Delete Db2 Data