PRIVATE GROUP FEE:
$ Based upon a class size of six students.
Scheduling can be adjusted to employee work hours and incorporate client assignments.
SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.
AUDIENCE:
Programmer
Database Administrator
IT Professional
DATES:
CONTENT AND OBJECTIVES:
System Concepts
Examination of the concepts serving as the foundation for the Db2 environment.
Demonstrate monitoring of system locks.
Creating Storage Groups
Create Db2 storage groups which will be used in subsequent exercises.
Create Db2 managed and self managed groups.
Database Design
Perform a physical design on the case study provided by the instructor.
Code and execute DDL; review and confirm the results.
Estimating Disk Storage
Given a physical design, determine storage requirements for the data and the partitioned indexes.
Controlling Access to Db2 Objects
Grant explicit privileges and authorities to a list of users.
Create field-level access control by views.
Auditing
Turn on auditing and review the audit data.
Format audit records to print and analyze.
Determine which security measures are enabled.
Basic Operation
Use operator commands to monitor Db2 resources.
Determine the availability of tablespaces and check pending states.
Monitoring and Controlling Db2
Monitor databases, buffer pools, and Db2 utilities.
Monitor threads for running processes and tasks.
Determine the state of system traces.
Log and the Bootstrap Dataset
Establish the logging environment and display log information.
Managing the BSDS: Bootstrap Dataset.
Backing Up and Recovering Databases
Perform a backup.
Copy page sets and datasets.
Recover page sets and datasets.
Recover data to a prior point of consistency.
Performance
Invoke RUNSTATS to review the table statistics.
Determine the statistics for the buffer pool and establish the appropriate level for the system.
Tuning Queries
Code and review SQL predicates using EXPLAIN or Data Studio; other utilities can be used including File-AID/Db2.
Determine optimal predicates for efficient execution.
Determine the access strategy for specific SQL statements.
Virtual Classroom
Blended Learning
↓
Synchronous Instruction
Asynchronous Instruction
Effective February 27, 2012, the course dates listed on the CETi schedules only will be available based upon approved and authorized user ID.
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. CETi makes no representation regarding ownership in any of the software products that we train on.
CETi courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the CETi course and that the employer has a licensed version of the software.
Certain courses only should be taught by the source software company training company and open source purveyor.
