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

Course Dates

Search by:

Show only GTR courses

Page 1, showing results 1-25 out of 655
Location
Duration
Start Date
Price
Brisbane, Australia
5 Days
26th Jul 2021
$6250
LVC, Australia
5 Days
26th Jul 2021
$6250
Canberra, Australia
5 Days
26th Jul 2021
$6250
LVC, Australia
5 Days
26th Jul 2021
$6250
Melbourne, Australia
5 Days
26th Jul 2021
$6250
LVC, Australia
5 Days
26th Jul 2021
$6250
Perth, Australia
5 Days
26th Jul 2021
$6250
LVC, Australia
5 Days
26th Jul 2021
$6250
Sydney, Australia
5 Days
26th Jul 2021
$6250
LVC, Australia
5 Days
26th Jul 2021
$6250
Auckland, New Zealand
5 Days
26th Jul 2021
$7250
LVC, New Zealand
5 Days
26th Jul 2021
$7250
Wellington, New Zealand
5 Days
26th Jul 2021
$7250
Riyadh, Saudi Arabia
5 Days
26th Jul 2021
$4500
LVC, Saudi Arabia
5 Days
26th Jul 2021
$4500
Dubai, United Arab Emirates
5 Days
26th Jul 2021
$4500
LVC, United Arab Emirates
5 Days
26th Jul 2021
$4500
Cairo, Egypt
5 Days
26th Jul 2021
$4500
LVC, Egypt
5 Days
26th Jul 2021
$4500
Tel Aviv, Israel
5 Days
26th Jul 2021
$4500
LVC, Israel
5 Days
26th Jul 2021
$4500
Istanbul, Turkey
5 Days
26th Jul 2021
$4500
LVC, Turkey
5 Days
26th Jul 2021
$4500
Singapore, Singapore
5 Days
26th Jul 2021
$4500
LVC, Singapore
5 Days
26th Jul 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