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 630
Location
Start Date
Price
Singapore, Singapore
8th Feb 2021
$4500
Melbourne, Australia
8th Feb 2021
$6250
LVC, Singapore
8th Feb 2021
$4500
LVC, Australia
8th Feb 2021
$6250
Cairo, Egypt
15th Feb 2021
$4500
Tel Aviv, Israel
15th Feb 2021
$4500
Sydney, Australia
15th Feb 2021
$6250
Melbourne, Australia
15th Feb 2021
$6250
Auckland, New Zealand
15th Feb 2021
$6250
Canberra, Australia
15th Feb 2021
$6250
Perth, Australia
15th Feb 2021
$6250
Brisbane, Australia
15th Feb 2021
$6250
Wellington, New Zealand
15th Feb 2021
$6250
Maputo, Mozambique
15th Feb 2021
$4500
Casablanca, Morocco
15th Feb 2021
$4500
Abuja, Nigeria
15th Feb 2021
$4500
Islamabad, Pakistan
15th Feb 2021
$4500
New York, United States
15th Feb 2021
$4500
San Jose, United States
15th Feb 2021
$4500
Dallas, United States
15th Feb 2021
$4500
Live Virtual Class, United States
15th Feb 2021
$4500
Istanbul, Turkey
15th Feb 2021
$4500
Singapore, Singapore
15th Feb 2021
$4500
Nairobi, Kenya
15th Feb 2021
$4500
Johannesburg, South Africa
15th Feb 2021
$4500

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