Overview and

Basic Maintenance

Presented by Mr. Fuangwith S.

2

Welcome to DB2 planet

IBM DB2 9.1 Fundamental Presentation

Overview and Basic Maintenance presented by Fuangwith S.

3

Agenda

• Overview

• DB2 Structure

• Lab I – Introduction to CLP

• Lab II – Create new database

• Lab III – Backup & Restore

• Lab IV – Import Export

IBM DB2 9.1 Fundamental Presentation

Overview and Basic Maintenance presented by Fuangwith S.

4

DB2 Family

IBM DB2 9.1 Fundamental Presentation

Overview and Basic Maintenance presented by Fuangwith S.

5

DB2 Across Platforms

IBM DB2 9.1 Fundamental Presentation

Overview and Basic Maintenance presented by Fuangwith S.

6

DB2 Structure

IBM DB2 9.1 Fundamental Presentation

Overview and Basic Maintenance presented by Fuangwith S.

7

LAB I

• Introduction to CLP

• DB2CMD

IBM DB2 9.1 Fundamental Presentation

Overview and Basic Maintenance presented by Fuangwith S.

8

LAB II

• db2ilist

• db2icrt

• db2stop

• db2start

• db2set

• db2 create database

• db2 get adm cfg

• db2 connect

IBM DB2 9.1 Fundamental Presentation

Overview and Basic Maintenance presented by Fuangwith S.

9

LAB III

• db2 backup

• db2 restore

IBM DB2 9.1 Fundamental Presentation

Overview and Basic Maintenance presented by Fuangwith S.

10

LAB IV

• Import Export

• Generate Scripts

• Generate DDL

IBM DB2 9.1 Fundamental Presentation

Overview and Basic Maintenance presented by Fuangwith S.

11

TOMORROW

IBM DB2 9.1 Fundamental Presentation

• SQL-PL

• SYSCAT

• Tablespace

• Table

• Procedure

• Function

• View

• Trigger

Overview and Basic Maintenance presented by Fuangwith S.