Home    |    Instructor-led Training    |    Online Training     
         
 
Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Python
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
DB2 Administration - Linux
Audience

Database and System Administrators or other technical personnel involved in the planning, implementing and manageing of DB2 databases in a Linux environment.

Class will be hands-on, lab oriented with students performing various tasks to exercise and reinforce material covered. Access to individual computers with instances of DB2 for Linux should be available for each student in order to effectively participate and complete the lab problems.

This should not be the first DB2 experience for the student.

Prerequisites

To successfully participate in this class students should be:
  • Familiar with the Linux file system and be able to use basic Linux functions such as utilities, manage file permissions, issue Linux commands and use Linux editor.
  • Able to successfully construct basic SQL Data Definition, Data Manipulation and Data Control statements.
  • Describe basic relational database objects and concepts such as tables, indexes, databases, joins and views.
Course duration

4 days

Course outline

I. Overview of DB2 on Linux

      A. Basic processing capabilities and components
      B. Installation process and parameters
      C. Command Line Processor and GUI Interfaces
      D. Database Administration Server (DAS) overview
      E. The DB2 on Linux environment
      F. Primary features of a DB2 instance
      G. Creating and Dropping a DB2 Instance
      H. Using the db2start and db2stop commands
      I. Modifing Database Manager configurations

II. Creating and Placing Databases and Files

      A. Planning considerations for database and file creation
      B. System catalog tables and views
      C. Database Managed Spaces (DMS) vs System Managed Spaces (DMS) vs
      Automatic table spaces
      D. Table spaces, Containers, Extents and Pages
      E. Defining a table space
      F. Obtaining a snapshot of a tablespace
      G. Obtaining and interpreting table space statistics
      H. Database configuation parameters

III. Database Object Creation

      A. DB2 object hierarchy, physical structures and files
      B. Creating Schemas, Tables, Views, Indexes and Alias’
      C. Table Partitioning concepts, purpose and use
      D. Using Temporary Tables
      E. Check Constraints, Triggers and Referential Integrity
      F. Large Object processing
      G. Using XML in DB2 for Linux

IV. Working with DB2 Data

      A. Moving data using Import, Export and Load
      B. Exception tables
      C. Identify pending Table States such as Load Pending and Set Integrity Pending
      D. dbmove and dblook commands
      E. Backup and recovery options for data
      F. Logging for backup and recovery
      G. BACKUP, RESTORE and ROLLFORWARD commands
      H. Restoring a database to various restore points
      I. Configuration parameters associated with backup and recovery

V. Locking and Data Concurrency

      A. Locking concepts and facilities in DB2
      B. Objects that may be locked and how
      C. Lock modes and compatibility
      D. Locking levels in DB2
      E. Isolation level and lock time
      F. Lock conversion and escalation
      G. Deadlocks - causes and avoidance

VI. Problem Determination

      A. Information requirements and collection for problem resolution
      B. Using the error logs
      C. Snapshtp, Event, Activity and Health monitors
      D. Using EXPLAIN in problem determination and analysis
      E. Commands to assist with connections and sessions
      F. How to obtain and interpret statistics related to a running DB2 session
      G. Using RUNSTATS, REORGCHK and REORG

VII. DB2 Security

      A. DB2 access control mechanisms
      B. Using group ids in DB2 security
      C. Level Based Access Control (LBAC)
      D. Database and System privileges
      E. Binding and Executing package privileges
      F. Explicit vs Implicit privileges
      G. DB2 authorization levels


Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved