IBM CL2X3G - DB2 10 for LUW: Basic Administration for Linux and Windows
Startdaten und Startorte
placeLeinfelden-Echterdingen 18. Jun 2024 bis 21. Jun 2024Details ansehen event 18. Juni 2024, 09:00-17:00, Leinfelden-Echterdingen, Seminar 30137 |
Beschreibung
Course Outline
- Overview of DB2 on Linux, UNIX and Windows
- Command Line Processor (CLP) and GUI usage
- The DB2 environment
- Creating databases and data placement
- Creating database objects
- Moving data
- Backup and recovery
- Database Maintenance, Monitoring, and Problem Determination
- Locking and concurrency
- Security
Agenda
Day 1
- Welcome
- Unit 1: Overview of DB2 on Linux, UNIX and Windows
- Unit 2: Command Line Processor (CLP) and GUI usage
- Unit 3: The DB2 Database Manager Instance
- Exercise 1: Create a New DB2 Instance
- Unit 4: Creating databases and data placement
- Exercise 2: Creating databases and data placement
Day 2
- Unit 5: Creating database objects
- Exercise 3: Create objects
- Unit 6…
Frequently asked questions
Es wurden noch keine FAQ hinterlegt. Falls Sie Fragen haben oder Unterstützung benötigen, kontaktieren Sie unseren Kundenservice. Wir helfen gerne weiter!
Course Outline
- Overview of DB2 on Linux, UNIX and Windows
- Command Line Processor (CLP) and GUI usage
- The DB2 environment
- Creating databases and data placement
- Creating database objects
- Moving data
- Backup and recovery
- Database Maintenance, Monitoring, and Problem Determination
- Locking and concurrency
- Security
Agenda
Day 1
- Welcome
- Unit 1: Overview of DB2 on Linux, UNIX and Windows
- Unit 2: Command Line Processor (CLP) and GUI usage
- Unit 3: The DB2 Database Manager Instance
- Exercise 1: Create a New DB2 Instance
- Unit 4: Creating databases and data placement
- Exercise 2: Creating databases and data placement
Day 2
- Unit 5: Creating database objects
- Exercise 3: Create objects
- Unit 6: Moving data
- Exercise 4: Moving data
Day 3
- Unit 7: Backup and recovery
- Exercise 5: Backup and recovery
- Unit 8: Database Maintenance, Monitoring, and Problem
Determination
- Exercise 6: Using DB2 Tools for Performance
Day 4
- Unit 7: Locking and concurrency
- Exercise 7: Investigating DB2 Locking
- Unit 8: Security
- Exercise 8: Database Security
Objective
- Administer a DB2 database system using commands and GUI tools
- Compare DMS, SMS, and Automatic storage management for table space storage
- Implement a given logical database design using DB2 to support integrity and concurrency requirements
- List and describe the components of DB2
- Define a DB2 recovery strategy and perform the tasks necessary to support the strategy
- Use autonomic features of DB2
- Examine Explain output to determine access strategy chosen by Optimizer
- Investigate current application activity that might indicate performance problems using SQL statements
- Implement DB2 security
Werden Sie über neue Bewertungen benachrichtigt
Schreiben Sie eine Bewertung
Haben Sie Erfahrung mit diesem Kurs? Schreiben Sie jetzt eine Bewertung und helfen Sie Anderen dabei die richtige Weiterbildung zu wählen. Als Dankeschön spenden wir € 1,00 an Stiftung Edukans.Es wurden noch keine FAQ hinterlegt. Falls Sie Fragen haben oder Unterstützung benötigen, kontaktieren Sie unseren Kundenservice. Wir helfen gerne weiter!