Formation DB2 10 pour z/OS Administration niveau 1

Describe what DB2 for z/OS is at an overview level
Understand the fundamental differences between static and dynamic SQL programs
Define the major responsibilities of any application program
Define the major responsibilities of the DB2 system
Understand the basic principles of DB2 Recovery
Discuss the basic roles people will play in a DB2 shop

Describe the DB2 objects that make up a DB2 database
Select parameters for these DB2 database objects so that they are implemented with the most appropriate attributes
Create storage groups, databases, table spaces, tables, views, synonyms, aliases, materialized query tables, and indexes
Alter the attributes of DB2 database objects as requirements change over time
Describe how data is stored in a DB2 database

Describe the concepts of PRIMARY KEY, UNIQUE KEY, and FOREIGN KEY
Implement these keys in DB2
Implement REFERENTIAL CONSTRAINTS on new or existing tables with the appropriate DELETE rules
Discuss identity columns and sequence objects

Describe how DB2 utilities may be executed, monitored, terminated, and restarted
Run the DB2 LOAD utility and make full use of its many features
Run the CHECK DATA utility to check DB2 table space data for any violations of referential integrity constraints or table check constraints
Run the DB2 UNLOAD utility, and make full use of its many features

Describe and interpret the statistics collected by RUNSTATS and real-time statistics
Run RUNSTATS with an appropriately chosen set of options
Describe why it is necessary to periodically REORG your table spaces and indexes
Run REORG with an appropriately chosen set of options

Make DB2 user data available again following media failures.

Describe the main steps needed to prepare a program with embedded static SQL to access DB2.

Describe DB2 global security
Describe the various DB2 authids and how they are established
Understand how DB2 security controls access to data
Describe and implement DB2 privileges and authorities appropriately
Describe how ownership is established in DB2
Describe DB2 authorization checking
Describe and implement security for plans and packages
Describe multilevel security
Describe the advantages and considerations for using the RACF / DB2 external security module

Describe concurrency
Explain the aspects of transaction locks
Tell when locks are acquired and released
Describe S and X locks
Explain isolation levels
Explain LOCKSIZE