Hierarchy of DB2 Sub system

TS – Table Space              INS – Index Space                

T – Table                           IND – Index

V – view

Maximum storage space for a Table Space is 64 million bytes.

SQL can be used to Create, Delete, and Update and Query the Objects

SQL queries can be executed by the following techniques

1. Application programming
2. Tools like QMF (Query Management Facility)

                             SPUFI (SQL Processor User File Input)

                             FILE -AID