DB2 References

Contents

Introduction

Schema

Index

Referential integrity relationships

Trigger

 

Introduction

This is a place to talk about the DB2 concepts most simply and the easiest-to-understand

Everything will be try to talk about as simplest as possible

Schema

Schema is similar as packages or namespace. It helps to keep the related objects (tables, views, indexes) together

How to create a schema? Please find in IBM website.

Index

What is the benefit of indexes?

Referential integrity relationships

Keep the data consistent through the related tables

• Primary Key
  
• Foreign Key
  
  • On Delete of Restrict
    what does it mean?
    

Trigger

Trigger is a method that allows you to do a specific action in the cases:

• Update
  
• Insert
  

Notes: You're possible to check the conditions before triggering a action, as well as specify which time to do it (before, after …)

How to create a trigger?

How to specify what aspects trigger an action?

Database physical directories and files

    I don't care how they are organized, it's should be just some files that I can bring it to other machine, because I don't need to use the backup or restore function.