DB2 Training

OVERVIEW

HISTORY

VERSIONS

DATA SERVER EDITIONS AND FEATURES

INTRODUCTION

HARDWARE REQUIREMENTS

SOFTWARE REQUIREMENTS

CHECKING SYSTEM COMPATIBILITY

INSTALLING DB ON LINUX OPERATING SYSTEM

VERIFYING DB INSTALLATION

COMMAND LINE PROCESSOR (CLP)

ACCESSING DB

INTRODUCTION

ARCHITECTURE OF INSTANCE IN DB PRODUCT

Creating instance on Linux

LISTING INSTANCES

INSTANCE ENVIRONMENT COMMANDS.

dbstop

CREATING AN INSTANCE

ARRANGING COMMUNICATION PORT AND HOST FOR AN INSTANCE

UPDATING AN INSTANCE

UPGRADING AN INSTANCE

dbiupgrade

DROPPING AN INSTANCE

dbidrop

USING OTHER COMMANDS WITH INSTANCE

DATABASE ARCHITECTURE

DATABASE DIRECTORY

PARTITIONED GLOBAL DIRECTORY

MEMBER SPECIFIC DIRECTORY

CREATING DATABASE

CREATING NON-RESTRICTIVE DATABASE

CREATING RESTRICTIVE DATABASE

CREATING DATABASE WITH DIFFERENT USER DEFINED LOCATION

VIEWING LOCAL OR SYSTEM DATABASE DIRECTORY FILES

ACTIVATING DATABASE

DEACTIVATING DATABASE

CONNECTING TO DATABASE

VERIFYING IF DATABASE IS RESTRICTIVE

CONFIGURING THE DATABASE MANAGER AND THE DATABASE

ESTIMATING SPACE REQUIRED FOR DATABASE

CHECKING DATABASE AUTHORITIES

DROPPING DATABASE

INTRODUCTION

RELATIONSHIP BETWEEN TABLESPACES AND BUFFERPOOLS

BUFFERPOOL SIZES

LISTING THE AVAILABLE BUFFERPOOLS IN THE CURRENT DATABASE DIRECTORY

CREATING THE BUFFERPOOL

DROPPING THE BUFFERPOOL

INTRODUCTION

BENEFITS OF TABLESPACES IN DATABASE

CONTAINER

DEFAULT TABLESPACES

INTRODUCTION

LISTING STORAGEGROUPS

CREATING A STORAGEGROUP

CREATING TABLESPACE WITH STOGROUP

ALTERING A STORAGE GROUP

DROPPING FOLDER PATH OF STORAGE GROUP

REBALANCING A TABLESPACE

RENAMING A STORAGEGROUP

DROPPING A STORAGE GROUP

INTRODUCTION

GETTING CURRENTLY ACTIVE SCHEMA

SETTING ANOTHER SCHEMA TO CURRENT ENVIRONMENT

CREATING A NEW SCHEMA

EXERCISE

INTRODUCTION

BUILT-IN DATA TYPES

INTRODUCTION

TYPE OF TABLES

CREATING TABLES

LISTING TABLE DETAILS

LISTING COLUMNS IN A TABLE

CREATING TABLE WITH HIDDEN COLUMN

INSERTING DATA VALUES IN TABLE

RETRIEVING VALUES FROM TABLE

RETRIEVING VALUES FROM A TABLE INCLUDING HIDDEN COLUMNS