®

IBM Software Group

Lesson 2: The DB2 Environment

Part 1 of 2
(DB2 on Campus Lecture Series)

Raul F. Chong
IBM Toronto Laboratory

© 2005 IBM Corporation

 IBM Software Group | DB2 Information Management Software

Agenda

ƒ Introduction
ƒ Instances
ƒ Databases
ƒ The DAS
ƒ DB2 Configuration

2
 IBM Software Group | DB2 Information Management Software

Agenda

ƒ Introduction
ƒ Instances
ƒ Databases
ƒ The DAS
ƒ DB2 Configuration

3
 IBM Software Group | DB2 Information Management Software
DB2 Commands & SQL/XML,
Xquery Statements DB2 Tools
SQL/XML, Xquery Command Line Tools
DB2: Statements
create bufferpool
Command Editor
Command Line Processor

The big create tablespace

create table
Command Window

Development Tools
picture alter bufferpool
alter tablespace DB2 Developer Workbench
Project Deployment Tool
DB2 Environment
Instance 'myinst'
alter table
select Database Manager
insert General Administration Tools Configuration
update Control Center File (dbm cfg)
delete Journal
... License Center Database MYDB1
Replication Center Database
DB2 System Commands Task Center Configuration
db2set File (db cfg)
db2start Information
db2stop Information Center
db2ilist Check for DB2 Updates
db2icrt
db2idrop Monitoring Tools
... Event Analyzer Port
DB2 CLP Commands Health Center
db2 update dbm cfg Indoubt Transaction Manager
catalog db Memory Visualizer
list node directory Activity Monitor
create database
list applications Setup Tools
list tablespaces Configuration Assistant
... Configure DB2 .Net Data Provider
<sql statement> Default DB2 Selection Wizard
xquery < > First Steps
Register Visual Studio Add-ins
4
 IBM Software Group | DB2 Information Management Software
DB2 Commands & SQL/XML,
Xquery Statements DB2 Tools
SQL/XML, Xquery Command Line Tools
DB2: Statements
create bufferpool
Command Editor
Command Line Processor
The big create tablespace
create table
Command Window

picture alter bufferpool

alter tablespace
Development Tools
DB2 Developer Workbench
DB2 Environment
Instance 'myinst'
alter table Project Deployment Tool
select Database Manager
insert General Administration Tools Configuration
update Control Center File (dbm cfg)
delete Journal
... License Center Database MYDB1
Replication Center Database
DB2 System Commands Task Center Configuration
db2set File (db cfg)
db2start Information
db2stop Information Center
db2ilist Check for DB2 Updates
db2icrt
db2idrop Monitoring Tools
... Event Analyzer Port
DB2 CLP Commands Health Center
db2 update dbm cfg Indoubt Transaction Manager
catalog db Memory Visualizer
list node directory Activity Monitor
create database
list applications Setup Tools
list tablespaces Configuration Assistant
... Configure DB2 .Net Data Provider
<sql statement> Default DB2 Selection Wizard
xquery < > First Steps
Register Visual Studio Add-ins
5
 IBM Software Group | DB2 Information Management Software

Agenda

ƒ Introduction
ƒ Instances
ƒ Databases
ƒ The DAS
ƒ DB2 Configuration

6
 IBM Software Group | DB2 Information Management Software

The DB2 Environment

DB2 Server (Linux/Windows)

7
 IBM Software Group | DB2 Information Management Software

The DB2 Environment

DB2 Server (Linux/Windows)

Instance DB2

Port

8
 IBM Software Group | DB2 Information Management Software

The DB2 Environment

DB2 Server (Linux/Windows)

Instance DB2 Instance myInst

Port

Port Port

9
 IBM Software Group | DB2 Information Management Software

Creating an instance
ƒ Windows (as Admin)
 db2icrt myinst

ƒ Linux (as root)

 /home/db2inst1/instance> ./db2icrt -u db2fenc2 db2inst2

ƒ db2fenc2 and db2inst2 must exist before hand.

 To create an instance using the GUI:

ƒ /home/db2inst1/instance>./db2isetup
ƒ In this case, the user IDs are created for you.
ƒ Note if you run as non-root, you can only see the current configuration of
existing instances.

 Note: Running from db2inst1 home directory, which has soft links to
/opt/ibm/db2/V9.5 (from which the same commands could be run)

10
 IBM Software Group | DB2 Information Management Software

Switching instances

ƒ Windows (as Admin)

 set DB2INSTANCE=<instance_name>

ƒ Linux
 su – <instance name>
 An instance maps to a Linux user
 The db2profile file is normally added to the .profile or .login files when the
instance was created.
ƒ The db2profile file has a line for DB2INSTANCE=<instance name>

11
 IBM Software Group | DB2 Information Management Software

Reviewing instance information

ƒ List all instances on the server:

db2ilist

ƒ Showing the current instance:

db2 get instance

12
 IBM Software Group | DB2 Information Management Software

Starting and stopping instance

ƒ db2start

ƒ db2stop [force]

13
 IBM Software Group | DB2 Information Management Software

Dropping an instance
ƒ Windows (as local Admin)
 db2stop
 db2idrop myinst

ƒ Linux
 db2stop (as the instance owner, eg: db2inst1)
 /opt/ibm/db2/V9.5/instance> ./db2idrop db2inst1 (as root)

14
 IBM Software Group | DB2 Information Management Software

Agenda

ƒ Introduction
ƒ Instances
ƒ Databases
ƒ The DAS
ƒ DB2 Configuration

15
IBM Software Group | DB2 Information Management Software

To be continued in
part 2…

16