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 >
Prerequisites >
Outline >

Course Dates

Search by:

Show only GTR courses

Page 1, showing results 1-25 out of 430
Location
Start Date
Price
LVC, Singapore
19th Sep 2020
$3600
LVC, Saudi Arabia
23rd Sep 2020
$3600
LVC, Turkey
24th Sep 2020
$3600
Nairobi, Kenya
25th Sep 2020
$3600
McLean, United States
27th Sep 2020
$3600
Islamabad, Pakistan
29th Sep 2020
$3600
Doha, State of Qatar
30th Sep 2020
$3600
Abuja, Nigeria
2nd Oct 2020
$3600
LVC, United Arab Emirates
2nd Oct 2020
$3600
LVC, Australia
3rd Oct 2020
$5000
McLean, United States
4th Oct 2020
$3600
Melbourne, Australia
5th Oct 2020
$5000
Nairobi, Kenya
5th Oct 2020
$3600
Abuja, Nigeria
5th Oct 2020
$3600
LVC, United States
5th Oct 2020
$3600
LVC, United States
5th Oct 2020
$3600
LVC, United States
5th Oct 2020
$3600
LVC, United States
5th Oct 2020
$3600
Wellington, New Zealand
5th Oct 2020
$5000
Riyadh, Saudi Arabia
5th Oct 2020
$3600
Dubai, United Arab Emirates
5th Oct 2020
$3600
LVC, Egypt
5th Oct 2020
$3600
Tel Aviv, Israel
5th Oct 2020
$3600
LVC, Turkey
5th Oct 2020
$3600
Singapore, Singapore
5th Oct 2020
$3600

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