DB2 operations (2DB2 )

Module

2DB2

Description

Participants in this course gain insight into the operation of DB2. They also learn how certain places create and manage DB2 Logging and recovery in DB2 will be extensively discussed. Finally, operational issues relating to the DB2 commands and start and stop DB2 treated. Participants will after this course through an own SQL database environment to organize and manipulate the DB2 utilities.

Topics

*Database

*DBMS

*SQL

Dynamic & Static SQL

*DB2 Objects

*Data Objects

Database

DB2 Storage Group

Table space

Table

Index/ index space

View

*System Objects

DB2 catalog

DB2 directory

Active and archive logs

Bootstrap data set (BSDS)

Buffer Pools

Communications Database (CDB)

Resource limit facility database

Data definition control support database

*DB2 Logging

*Operating aspects

DB2 Commands

Messages

Troubleshooting

*DB2 Utilities

Prerequisites

Course 1RKC, 1DATAM, 1ZOS, 1VSAM, 3TSO, 1JCL, 1JES2

Coursedays

3 days

Class

Classroom with Syllabus

                                    Online practice exercises

Special

A written or practical test is possible.