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