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 1437
Location
Start Date
Price
Dubai, United Arab Emirates
1st Feb 2021
$3600
Riyadh, Saudi Arabia
1st Feb 2021
$3600
Wellington, New Zealand
1st Feb 2021
$5000
Canberra, Australia
1st Feb 2021
$5000
Auckland, New Zealand
1st Feb 2021
$5000
Perth, Australia
1st Feb 2021
$5000
Brisbane, Australia
1st Feb 2021
$5000
Tel Aviv, Israel
1st Feb 2021
$3600
Cairo, Egypt
1st Feb 2021
$3600
Melbourne, Australia
1st Feb 2021
$5000
Sydney, Australia
1st Feb 2021
$5000
LVC, United Arab Emirates
1st Feb 2021
$3600
LVC, South Africa
1st Feb 2021
$3600
LVC, Singapore
1st Feb 2021
$3600
LVC, Australia
1st Feb 2021
$5000
LVC, New Zealand
1st Feb 2021
$5000
LVC, United States
1st Feb 2021
$3600
LVC, United States
1st Feb 2021
$3600
London, United Kingdom
1st Feb 2021
£3000
London, United Kingdom
1st Feb 2021
£3000
Edison, United States
1st Feb 2021
$3600
Sacramento, United States
1st Feb 2021
$3600
McLean, United States
1st Feb 2021
$3600
King of Prussia, United States
1st Feb 2021
$3600
San Francisco, United States
1st Feb 2021
$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