Download - Overview and Basic Maintenance
![Page 1: Overview and Basic Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022080210/55515ad5b4c9059f768b4a9e/html5/thumbnails/1.jpg)
Overview and
Basic Maintenance
Presented by Mr. Fuangwith S.
![Page 2: Overview and Basic Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022080210/55515ad5b4c9059f768b4a9e/html5/thumbnails/2.jpg)
2
Welcome to DB2 planet
IBM DB2 9.1 Fundamental Presentation
Overview and Basic Maintenance presented by Fuangwith S.
![Page 3: Overview and Basic Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022080210/55515ad5b4c9059f768b4a9e/html5/thumbnails/3.jpg)
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.
![Page 4: Overview and Basic Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022080210/55515ad5b4c9059f768b4a9e/html5/thumbnails/4.jpg)
4
DB2 Family
IBM DB2 9.1 Fundamental Presentation
Overview and Basic Maintenance presented by Fuangwith S.
![Page 5: Overview and Basic Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022080210/55515ad5b4c9059f768b4a9e/html5/thumbnails/5.jpg)
5
DB2 Across Platforms
IBM DB2 9.1 Fundamental Presentation
Overview and Basic Maintenance presented by Fuangwith S.
![Page 6: Overview and Basic Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022080210/55515ad5b4c9059f768b4a9e/html5/thumbnails/6.jpg)
6
DB2 Structure
IBM DB2 9.1 Fundamental Presentation
Overview and Basic Maintenance presented by Fuangwith S.
![Page 7: Overview and Basic Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022080210/55515ad5b4c9059f768b4a9e/html5/thumbnails/7.jpg)
7
LAB I
• Introduction to CLP
• DB2CMD
IBM DB2 9.1 Fundamental Presentation
Overview and Basic Maintenance presented by Fuangwith S.
![Page 8: Overview and Basic Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022080210/55515ad5b4c9059f768b4a9e/html5/thumbnails/8.jpg)
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.
![Page 9: Overview and Basic Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022080210/55515ad5b4c9059f768b4a9e/html5/thumbnails/9.jpg)
9
LAB III
• db2 backup
• db2 restore
IBM DB2 9.1 Fundamental Presentation
Overview and Basic Maintenance presented by Fuangwith S.
![Page 10: Overview and Basic Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022080210/55515ad5b4c9059f768b4a9e/html5/thumbnails/10.jpg)
10
LAB IV
• Import Export
• Generate Scripts
• Generate DDL
IBM DB2 9.1 Fundamental Presentation
Overview and Basic Maintenance presented by Fuangwith S.
![Page 11: Overview and Basic Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022080210/55515ad5b4c9059f768b4a9e/html5/thumbnails/11.jpg)
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.