Follow Us on Social!
Kursangebot
- Garantietermine
- Neue Trainings
- Fast Lane LIVE E-Learning
- Digitale Lernlösungen
- Fast Lane Academy»
-
Fast Lane IT Workshops»
- IT-Training by Fast Lane
- Garantietermine
- Themen im Fokus
- Professional Services
- Trainingspakete
- Hersteller im Fokus
- Amazon Web Services»
- Aruba»
- Cisco»
- Citrix»
- EC-Council»
- Google Cloud»
- (ISC)²»
-
Microsoft»
- Was ist neu?
- Microsoft Training
- Microsoft Expert Line
- Microsoft Zertifizierungen
- Microsoft Instructor-led Online Training
- Microsoft E-Learning
- Microsoft SATV Voucher einlösen
- Microsoft Consulting Services
- Themen im Fokus
- Microsoft Power Platform
- Microsoft Security, Compliance & Identity
- Microsoft Azure
- Open Hacks
- Microsoft Office
- NetApp»
- Palo Alto Networks»
- Red Hat»
- VMware»
-
Weitere Hersteller»
- Adobe
- Apple
- Autodesk
- Automation Anywhere
- Barracuda
- Brocade
- Check Point
- Cloudera
- Commvault
- CompTIA
- CWNP
- Cybersecurity First Responder
- Cydrill Secure Encoding
- DataCore
- Dell EMC
- Extreme Networks
- F5
- Fortinet
- Gigamon
- IBM
- Infoblox
- Juniper
- Kaspersky Lab
- KnowBe4 Security Awareness
- Micro Focus
- Nutanix
- Oracle
- Pivotal / Spring
- Ruckus
- Salesforce
- SAP
- SonicWall
- Sophos
- SUSE
- Symantec
- TÜV (IT-Security)
- Veeam
- Veritas
- IT- & Projektmanagement»
- ITIL®»
- PRINCE2®»
- Scaled Agile»
- Scrum»
- Atlassian»
- Themen/Technologien im Fokus
- Artificial Intelligence (AI)»
- Business & Soft Skills»
- Cloud Computing»
- Cyber Security»
- Data Center»
- Kubernetes / Container»
- Linux»
- Network Analysis / Wireshark»
- Software Development»
- Wireless & Mobility»
Db2 11.1 Advanced Database Administration (CL464G)
Who should attend
This is an advanced course for DBAs and technical individuals who plan, implement, and maintain Db2 11.1 databases
Prerequisites
- Perform basic database administration tasks for a Db2 database server, including using Db2 commands like BACKUP and RESTORE
- Utilize Structured Query Language (SQL) and be able to construct DDL, DML, and authorization statements
- These skills can be developed by taking:
- CL207 Db2 11.1 Administration Workshop for Linux
Course Content
This course is designed to teach you how to: • Perform advanced monitoring using the Db2 administrative views and routines in SQL queries. • Manage the disk space assigned in Database Managed Storage (DMS) and Automatic Storage table spaces, including the activities of the rebalancer. • Use SQL queries and Db2 commands to check the high water mark on table spaces and to monitor the rebalance operation. • Utilize the REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces using database or tablespace backup images. • Plan and execute the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases. • Create incremental database or tablespace level backups to reduce backup processing and backup image storage requirements. • Implement automatic storage management for table spaces and storage groups or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity. • Describe the various types of database memory including buffer pools, sort memory, lock memory and utility processing memory. • Adjust database or Db2 instance configuration options to improve application performance or processing efficiency. • Implement Db2 Self Tuning Memory management for specific database memory areas.
Online Training
Dauer 2 Tage
Preis (exkl. MwSt.)
- 1.590,– €
Sprache der Kursunterlagen: Englisch
Derzeit gibt es keine Online-Termine für diesen Kurs.
Classroom Training
Dauer 2 Tage
Preis (exkl. MwSt.)
- Deutschland: 1.590,– €
Verpflegung umfasst:
- Kaffee, Tee, Saft, Wasser, Cola
- Gebäck und Süßigkeiten
- Frisches Obst
- Mittagessen in einem der naheliegenden Restaurants
Gilt nur bei Durchführung durch Fast Lane. Termine, die von unseren Partnern durchgeführt werden, beinhalten ggf. ein abweichendes Verpflegungsangebot.
Sprache der Kursunterlagen: Englisch
Derzeit gibt es keine Klassenraum-Termine für diesen Kurs.
Derzeit gibt es keine Trainingstermine für diesen Kurs.