All Brands   >   IBM   >   IBM Analytics HDM Db2 for z OS   >   DB2 10 for zOS System Administration CV851G

CMDBID: 56618 | Course Code: CV851G | Duration: 5 Days
Overview >

The course is updated for DB2 10 for z/OS. This course is the classroom delivered version of the Instructor led Online course DB2 10 for z/OS System Administration - ILO (3V851).

Administrators of DB2 10 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 10 for z/OS subsystem. Engage in lectures and hands-on labs to gain experience to:

  • Relate the z/OS IPL process to a DB2 subsystem
  • Explain effects of stopping and starting DB2
  • Explain how DB2 sets and use Integrated Catalog Facility (ICF) catalog names
  • The use of DSN command processor running in batch and foreground
  • Use views to minimize your ability to see into the DB2 catalog
  • See how the catalog (through grant activity) controls access to data
  • Search the catalog for problem situations
  • Use the catalog and DB2 utilities to determine data recovery requirements
  • Describe Internal Resource Lock Manager (IRLM) in a DB2 environment
  • Implement DB2 and Resource Access Control Facility (RACF) security
  • Describe DB2 program flow for all environments
  • Display normal and problem threads and database status
  • See how the SQL Processor Using File Input (SPUFI) AUTOCOMMIT option defers the COMMIT/ROLLBACK decision
  • Interpret lock displays
  • Identify and cancel particular threads
  • Describe available DB2 utilities to manage system and user page sets
Audience >
Skills >
Prerequisites >
Outline >

Course Dates

Search by:

Show only GTR courses

Page 1, showing results 1-25 out of 236
Location
Start Date
Price
LVC, Australia
9th Aug 2020
$6250
Tel Aviv, Israel
10th Aug 2020
$4500
LVC, Australia
10th Aug 2020
$6250
LVC, New Zealand
10th Aug 2020
$6250
LVC, Australia
10th Aug 2020
$6250
LVC, Australia
10th Aug 2020
$6250
LVC, Turkey
10th Aug 2020
$4500
Melbourne, Australia
10th Aug 2020
$6250
LVC, Australia
10th Aug 2020
$6250
LVC, Singapore
10th Aug 2020
$4500
Singapore, Singapore
10th Aug 2020
$4500
Cairo, Egypt
4th Sep 2020
$4500
LVC, Egypt
5th Sep 2020
$4500
LVC, Australia
7th Sep 2020
$6250
Johannesburg, South Africa
7th Sep 2020
$4500
Live Virtual Class, United States
7th Sep 2020
$4500
LVC, South Africa
7th Sep 2020
$4500
LVC, United States
7th Sep 2020
$4500
Live Virtual Class, United States
8th Sep 2020
$4500
Brisbane, Australia
11th Sep 2020
$6250
San Francisco, United States
11th Sep 2020
$4500
Melbourne, Australia
14th Sep 2020
$6250
Singapore, Singapore
14th Sep 2020
$4500
LVC, Singapore
14th Sep 2020
$4500
LVC, Australia
14th Sep 2020
$6250

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