All Brands   >   IBM   >   IBM Analytics HDM Db2   >   DB2 10.5 for Linux UNIX and Windows Quickstart for Experienced Relational DBAs CL485G

CMDBID: 45616 | Course Code: CL485G | Duration: 4 Days
Overview >

This course teaches you to perform, basic and advanced, database administrative tasks using DB2 10.5 for Linux, UNIX, and Windows. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. The access strategies selected by the DB2 Optimizer will be examined using the DB2 Explain tools. Various diagnostic methods will be presented, including using various db2pd command options. Students will learn how to implement automatic archival for database logs and how to plan a redirected database restore to relocate either selected table spaces or an entire database. The REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces, will be discussed. We will also cover using the TRANSPORT option of RESTORE to copy schemas of objects between two DB2 databases. The selection of indexes to improve application performance and the use of SQL statements to track database performance and health will be covered. This course provides a quick start to DB2 database administration skills for experienced relational Database Administrators (DBA).

Audience >
Skills Gained >
Prerequisites >
Outline >

Course Dates

Search by:

Show only GTR courses

Page 1, showing results 1-25 out of 1124
Location
Duration
Start Date
Price
Denver, United States
4 Days
13th Apr 2021
$3600
Atlanta, United States
4 Days
13th Apr 2021
$3600
Dallas, United States
4 Days
13th Apr 2021
$3600
Live Virtual Class, United States
4 Days
13th Apr 2021
$3600
Doha, State of Qatar
4 Days
13th Apr 2021
$3600
Maputo, Mozambique
4 Days
13th Apr 2021
$3600
San Francisco, United States
4 Days
13th Apr 2021
$3600
Edison, United States
4 Days
13th Apr 2021
$3600
McLean, United States
4 Days
13th Apr 2021
$3600
Sacramento, United States
4 Days
13th Apr 2021
$3600
Abuja, Nigeria
4 Days
13th Apr 2021
$3600
Muscat, Oman
4 Days
13th Apr 2021
$3600
New York, United States
4 Days
13th Apr 2021
$3600
San Jose, United States
4 Days
13th Apr 2021
$3600
King of Prussia, United States
4 Days
13th Apr 2021
$3600
Islamabad, Pakistan
4 Days
13th Apr 2021
$3600
Casablanca, Morocco
4 Days
13th Apr 2021
$3600
Istanbul, Turkey
4 Days
13th Apr 2021
$3600
Singapore, Singapore
4 Days
13th Apr 2021
$3600
Tel Aviv, Israel
4 Days
13th Apr 2021
$3600
Johannesburg, South Africa
4 Days
13th Apr 2021
$3600
Nairobi, Kenya
4 Days
13th Apr 2021
$3600
Melbourne, Australia
4 Days
13th Apr 2021
$5000
Sydney, Australia
4 Days
13th Apr 2021
$5000
Brisbane, Australia
4 Days
13th Apr 2021
$5000

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. Its a cost effective option. One on one training can be delivered too, at reasonable rates.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

All $ prices are in USD unless it’s a NZ or AU date

SPVC = Self Paced Virtual Class

LVC = Live Virtual Class

Please Note: All courses are availaible as Live Virtual Classes