Discover Classes. Earn Rewards.
DB2 10 for LUW Advanced Database Recovery (CL493G) is unfortunately unavailable

Thankfully we have 1,335 other Tech Classes for you to choose from. Check our top choices below or see all classes for more options.

DB2 10 for LUW Advanced Database Recovery (CL493G)

at Global Knowledge - Financial District

(58)
Course Details
Price:
$2,995
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Financial District, Manhattan
1 State Street Plaza 23rd Flr
Btwn Pearl and Water Streets
New York, New York 10004
(Map)
Description
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 10

What you'll learn in this ibm db2 training:

Gain a deeper understanding of the advanced recovery features of DB2 10 for Linux, UNIX, and Windows database environments with single and multiple partition databases. Get practical experience in the planning and utilization of a wide variety of DB2 recovery facilities in a series of database recovery scenarios you complete during lab exercises using DB2 Advanced Enterprise Edition 10.5 for Linux.

What You'll Learn

  • Describe the unique recovery planning requirements for DB2 10 single partition and multiple partition databases
  • Explore the DB2 for Linux, UNIX and Windows recovery facilities and database configuration options
  • Plan the implementation of automated archival and retrieval of database logs
  • Recover a DB2 table following a DROP TABLE command issued in error
  • Utilize the REBUILD option of the RESTORE Utility to recover a full or partial database copy using either database or table space backups
  • Plan and execute the recovery of table spaces to a selected point in time
  • Effectively utilize incremental backup and restore to reduce the size and duration of DB2 database backups
  • Describe the database crash recovery processing performed when there is an unplanned outage of a DB2 database server and select database configuration options to minimize the restart time.
  • Utilize the redirected restore option to recover DB2 data to alternate disk configurations and invoke the db2relocatedb command to alter the configuration of a DB2 database
  • Execute recovery scenarios, including loss of DB2 log data using the DB2 log mirroring option, and configure a database for automatic backups
  • List the benefits and limitations of disaster recovery alternatives including log shipping to a standby database or using DB2 replication
  • Describe the use of the db2haicu command to select options for the integrated high availability cluster support for DB2 LUW 10 databases
  • List some of the advantages and disadvantages associated with various High Availability and Disaster Recovery configurations DB2 databases
  • Describe some of the differences between DB2 recovery facilities for DB2 pureScale database clusters compared to non-pureScale databases, including the use of the Cluster Caching Facilities to support Member Crash Recovery
  • Plan and implement the use of split mirror copies of DB2 databases to create snapshot database copies or use as an alternative to a standard DB2 database backup.
  • Plan, implement, and manage the Primary and Standby databases using the High Availability Disaster Recovery (HADR) facilities of DB2 10.5 for Linux, UNIX and Windows databases
  • Implement Read-Only application access to the Standby database in a HADR environment
  • Manage a HADR environment with multiple standby databases
Who Needs to Attend

This advanced course is for experienced database administrators who plan and implement recovery and high availability plans for DB2 10 for Linux, UNIX and Windows databases using single or multiple partition databases. The lab exercises can be performed using a single partition or a multiple partition database using DB2 Advanced Enterprise Edition 10.5 for Linux. This course is appropriate for those using DB2 in a z/Linux environment.

Prerequisites


You should complete:
  • DB2 10 for LUW: Basic Administration for Linux and Windows (CL2X3G) or
  • DB2 10 for LUW: Basic Administration for AIX (CL213G) or
  • DB2 10.1 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs (CL484G)
Or have equivalent experience.



Still have questions? Ask the community.

Refund Policy
Notice of cancellation must be submitted 16 business days prior to class.

Map

Google Map

Global Knowledge

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 29950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at Global Knowledge (12)

School: Global Knowledge

Global Knowledge

Global Knowledge is the world's leading learning services and professional development solutions provider. We deliver learning solutions to support customers as they adapt to key business transformations and technological advancements that drive the way that organizations around the world differentiate...

Read more about Global Knowledge

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

1,335 Top Choices

Virtual Excel for Beginners

This class is temporarily being offered remotely.

at Donna Sanabria - Virtual Learning via Zoom

Have you been wanting to learn Excel, but never had time for a long training course?  Do you have a project that requires Excel, but don’t know how to get started?  Are you looking to add another skill to your resume and give yourself a competitive advantage?  In this course you will learn how to get started and gain confidence with...

Tuesday Jul 14th, 6pm - 10pm Eastern Time

Virtual Intermediate Excel

This class is temporarily being offered remotely.

at Julie Khidekel - Virtual Learning via Zoom

In this intermediate Excel course, master tools such as pivot tables, formulas, macros, data analysis & more with hands-on exercises. You'll also learn some advanced formatting tools such as conditional formatting, sorting and filtering, and some major time-saving tips like freeze panes. Materials Needed to Fully Participate: Microsoft Excel...

Wednesday Jul 22nd, 6:30pm - 9:30pm Eastern Time

Beginner Microsoft Excel 2016

This class is temporarily being offered remotely.

at NYC Career Centers - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Get the hang of Excel formulas, functions, charts, and workbook formatting. This beginner course is the perfect introduction to Excel for self-taught users and complete beginners alike. Develop a command of time-saving Excel shortcuts and hotkeys. Practical Real-World Training Our Excel course includes practical exercises that walk you through the...

Thursday Jul 16th, 10am - 5pm Eastern Time

Introduction to Adobe InDesign

This class is temporarily being offered remotely.

at Spectrum Creative Consulting - Greenpoint 198 Greenpoint Ave., Brooklyn, New York 11222

This hands-on introductory course details the most essential Adobe InDesign features for beginner level users. Students will create multi-page documents while learning a variety of text and image layout techniques. TOPICS  Creating & Customizing Documents Page Setup & Layout Working With Master Pages Working With Typography Applying...

Tuesday Jul 14th, 11am - 5pm Eastern Time

Beginner SQL

This class is temporarily being offered remotely.

at NYC Career Centers - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Get an overview of databases and queries in SQL Level 1. In this course, you’ll begin with an introduction to relational database management systems and practice connecting to Microsoft SQL Server. Next, you'll dive right into writing basic SQL queries to retrieve data from the database management system. The Best SQL Courses in NYC Our SQL courses...

Thursday Jul 23rd, 9am - 5pm Eastern Time

Adobe Photoshop Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

Photoshop is the industry standard photo image editing software for print and digital output. In this hands-on introductory workshop, we will walk through Photoshop's basic capabilities and use tools and techniques to edit images and create visual design mock-ups - no design experience required! This bootcamp will help students visualize products...

Thursday Jul 23rd, 11am - 6pm Eastern Time

Excel for Business Fundamentals - Level 1

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Get started in Excel with this fundamental Excel course. Get comfortable using Excel and learn to boost your productivity with formulas, charts, and formatting techniques. Master the core Excel functions in this one-day course. Learn calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing....

Thursday Jul 16th, 10am - 5pm Eastern Time

Intermediate Excel for Business

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Split and join text, create drop-down menus, and sort and filter data. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of this class,...

Friday Jul 17th, 10am - 5pm Eastern Time

Introduction to Adobe Photoshop

This class is temporarily being offered remotely.

at Spectrum Creative Consulting - Greenpoint 198 Greenpoint Ave., Brooklyn, New York 11222

This hands-on introductory course details the most essential Adobe Photoshop features for beginner level users. Topics include basic image editing, transformation, retouching, enhancement, and compositing.  TOPICS Understanding File Formats & Resolution Selections Techniques Image Transformations Layer Management Layer Masking &...

Tuesday Jul 14th, 11am - 5pm Eastern Time

Introduction to 3D Modeling with Rhino (MAC)

This class is temporarily being offered remotely.

at Spectrum Creative Consulting - Greenpoint 198 Greenpoint Ave., Brooklyn, New York 11222

This hands-on introductory course will introduce the fundamentals of 3D-modeling in Rhino on the MAC platform. Students will learn how to build 3D models and prototypes with the NURBS-based modeling tools in Rhino using essential tools and techniques such as curves, surfaces, and solids. The course will cover strategies for drawing curves and modeling...

Tuesday Jul 14th, 11am - 5pm Eastern Time

Intro to Web Design with HTML and CSS

This class is temporarily being offered remotely.

at Spectrum Creative Consulting - Greenpoint 198 Greenpoint Ave., Brooklyn, New York 11222

This hands-on course introduces the fundamentals of web design with HTML (HyperText Markup Language) and Cascading Style Sheets (CSS). Students will learn how code is structured and the major features of the languages. Exercises will include creating a small website including text, images, embedded video and links and styling with CSS to control color,...

Tuesday Jul 14th, 11am - 5pm Eastern Time

Introduction to Adobe After Effects

This class is temporarily being offered remotely.

at Spectrum Creative Consulting - Greenpoint 198 Greenpoint Ave., Brooklyn, New York 11222

This hands-on introductory level course covers the fundamentals of Adobe After Effects. The class will introduce students to the key concepts, terminology, and interface of After Effects. Topics include compositions, layers, animation, keyframing, effects, 3D, and rendering. TOPICS Best Practices File Management Project Organization ...

Tuesday Jul 14th, 11am - 5pm Eastern Time

Intermediate SQL

This class is temporarily being offered remotely.

at NYC Career Centers - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Discover views, functions, and subqueries in SQL Level 2. You’ll begin by reviewing SQL queries related to joins. Next, you’ll dive into the core of SQL—views, functions, stored procedures, subqueries, math, functions, and logic statements. The course concludes with a lab session to practice your skills. Practical SQL Courses in New York City...

Friday Jul 24th, 9am - 5pm Eastern Time

Introduction to Adobe Illustrator

This class is temporarily being offered remotely.

at Spectrum Creative Consulting - Greenpoint 198 Greenpoint Ave., Brooklyn, New York 11222

This hands-on introductory course details the most essential Adobe Illustrator features for beginner level users. Students will learn how to create and manipulate vector shapes with a variety of tools. The course also covers text, color, effects, and layers. TOPICS Understanding Vector Graphics Creating & Transforming Paths Working With...

Tuesday Jul 14th, 11am - 5pm Eastern Time

Introduction to SQL and Data Analytics (Online)

This class is temporarily being offered remotely.

at Practical Programming - Online Online, New York, New York 10001

This workshop will teach you the core concepts of databases as well as how to write effective SQL queries you can use in your everyday work. We will spend a quarter of the workshop reviewing database theory and the majority of the time going through examples. Also, this workshop will teach you advanced concepts of databases as well as how to write...

Wednesday Aug 12th, 6pm - 9pm Eastern Time

  (3 sessions)
$399

3 sessions

Getting Started with Wordpress

This class is temporarily being offered remotely.

at General Assembly - Online Online Classroom, Los Angeles, California 00000

WordPress is the premier content management system for those seeking an easy, user-friendly way to set up and maintain a website. In this class, you’ll walk through the basics of getting your site live quickly and discover various free templates as well as premium resources that require little to no coding skills and will have your site looking polished...

Saturday Aug 22nd, 9am - 12pm Pacific Time

Advanced Excel for Business - Level 3

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Master advanced Excel techniques in this hands-on training. Learn how to use the more advanced tools in Excel like What-If Analysis, INDEX-MATCH, macros, and more. Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with...

Monday Jul 20th, 10am - 5pm Eastern Time

QuickBooks Basic

This class is temporarily being offered remotely.

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

We are offering a QuickBooks Basic Course that will teach you how to navigate QuickBooks, create a company file, set up inventory, work with vendors (writing checks, paying bills) and customers (creating invoices, receipts, receive payments), managing payroll, doing bank reconciliation and creating reports. These topics will give you a great start...

Thursday Jul 16th, 10am - 6pm Eastern Time

Intermediate Microsoft Excel 2016

This class is temporarily being offered remotely.

at NYC Career Centers - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter, and Pivot Tables. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation. Embedded in the course are pivotal time-saving tricks like Paste Special, keyboard...

Friday Jul 17th, 10am - 5pm Eastern Time

Loading...