IBM DB2

1
IBM DB2

• DB2 for iSeries

2
IBM DB2 for iSeries

• IBM DB2 Family
• z/OS, i5/OS, Linux/Unix/Windows
• IBM DB2 for LUW
• V9.7
• IBM DB2 for iSeries
• V5R4
• DB2 Administration iSeries Navigator
• Download Access for Windows V5R4
• Getting start

3
The iSeries Navigator
4
Add Connection
5
Add Database Component
6
Install Database Components
7
Run SQL Scripts
8
Create COMPANY Objects

• Create and populate COMPANY tables by running
  script company_create.sql
• Open Run SQL Script window
• File ? Open ? company_create.sql ? Open
• Modify the first line to
• Set current schema your schema name
• Run ? All
• Drop COMPANY tables by running script
  company_drop.sql

9
Create COMPANY Objects