Introduction to DB2 for z/OS
Previous topic |
Next topic
| Contents |
Glossary
|
Contact z/OS
|
PDF
Contents (exploded view)
Introduction to DB2 for z/OS
Introduction to DB2 for z/OS
DB2 for z/OS architecture
z/Architecture and the z/OS operating system
DB2 in the z/OS environment
DB2 internal resource lock manager
DB2 and the z/OS Security Server
DB2 and DFSMS
DB2 attachment facilities
Distributed data facility
DB2 in a Parallel Sysplex environment
DB2 concepts
Structured query language
DB2 data structures
DB2 tables
DB2 indexes
DB2 keys
DB2 views
DB2 schemas and schema qualifiers
DB2 table spaces
DB2 index spaces
DB2 storage groups
DB2 databases
DB2 system objects
DB2 catalog
DB2 directory
Active and archive logs
Bootstrap data set
Buffer pools
Data definition control support database
Resource limit facility database
Work file database
Support for high availability
Enforcement of business rules
Entity integrity, referential integrity and referential constraints
Check constraints
Triggers
Application processes and transactions
Packages and application plans
Routines
Functions
Procedures
Distributed data
Remote servers
Connectivity
SQL: The language of DB2
Ways to access data
Ways to select data from columns
How a SELECT statement works
SQL functions and expressions
Ways to filter the number of returned rows
Ways to order rows
Ways to summarize group values
Ways to merge lists of values
Ways to specify search conditions
Ways to join data from more than one table
Subqueries
Ways to access DB2 data that is not in a table
Ways to modify data
Insert statements
Update statements
Merge statements
Delete statements
Truncate statements
Ways to execute SQL
Static SQL
Dynamic SQL
DB2 ODBC
DB2 access for Java: SQLJ and JDBC
Interactive SQL
Use of DB2 Query Management Facility for Workstation
Application programming for DB2
Programming languages and methods for developing application programs
Preparation process for an application program
Static SQL applications
Dynamic SQL applications
Types of dynamic SQL
Dynamic SQL programming concepts
Implementation of your database design
Creation of tables
Types of tables
Creation of base tables
Definition of columns in a table
Row design
Record lengths and pages
Designs that waste space
Creation of table spaces
Types of DB2 table spaces
Assignment of table spaces to physical storage
Creation of indexes
Types of indexes
How indexes can help to avoid sorts
Creation of views
A view on a single table
A view that combines information from several tables
Creation of databases
IBM DB2 tools
Copyright IBM Corporation 1990, 2010