SMLAN Software & Management Training Keep calm and study smart
esciris authorized training reseller

DB2 11 for z/OS System Administration (CV852G)     » zur Seminarliste

Administrators of DB2 11 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 11 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 andforeground
  • Use views to minimize users' ability to see into the DB2catalog
  • See how the catalog (through grant activity) controls accessto data
  • Search the catalog for problem situations
  • Use the catalog and DB2 utilities to determine data recoveryrequirements
  • Describe Internal Resource Lock Manager (IRLM) in a DB2environment
  • 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 userpage sets

Alle IBM Trainings finden in Kooperation mit unserem Partner esciris GmbH statt.

Kurs-Id: IBM_CV852G

Seminarinhalt
  • Start and stop the DB2 subsystem
  • Explain the allocation CLIST used at logon for DB2 data sets
  • Use Set SYSPARM command
  • Locate the Command recognition character for the DB2 subsystem
  • Query the system log to gain knowledge about the IPL processand information in the system log when DB2 is initialized orstopped
  • Explore DB2 Address Spaces information
  • Select the DB2 functions that best satisfy your siterequirements
  • Explain the use of RACF for DB2 connection security
  • Explain the use of Roles and Trusted Context
  • Implement security procedures for a DB2 environment
  • Describe the components and address space structure of a DB2subsystem
  • Explain DB2 Program Flow for all environments
  • Invoke and use DB2 TSO Facilities
  • Use the DB2 Catalog to monitor authorizations
  • Increase the size of the Active Log data sets
  • Explain DB2 Logging
  • Use SET LOG SUSPEND and SET LOG RESUME
  • Use DSNJU004 to Print Log Map
  • Interpret the output of the Print Log Map Utility DSNJU004
  • Use DSNJU003 to rename DB2 data sets
  • Plan for recovery of a BSDS failure
  • Monitor and control DB2
  • Explain transaction flow in IMS and CICS
  • Describe the CICS and DB2 environment
  • Make use and inplement the extended 10-byte RBA and LRSN
Informationen
Zielgruppe

This is an intermediate course for system administrators, database administrators, and other technical individuals, who manage and implement DB2 10 for z/OS.

Vorkenntnisse

You should have:

  • an understanding of the objects (tables, indexes, databases, and so forth) used in DB2 systems, and of how those objects are created, managed, and recovered. These skills can be developed by taking the DB2 Database Administration Workshop (CF83G) / (CV830) or through equivalent experience.
  • a working knowledge of SQL. The SQL Workshop (CE120G) / (3E12G) provides that.
  • At least one year as a z/OS systems programmer or equivalent experience
  • Or, one year working with DB2 on the mainframe as a DBA on the mainframe or equivalent experience
Dauer

5 Kurstage (pro Tag 8 Unterrichtsstunden à 45 Min.)

Termine
  • Stuttgart (U9GUU): 14.01. - 18.01.19: AnmeldenDB2 11 for z/OS System Administration (CV852G)SMLan Software & Management TrainingKastanienallee 53Berlin10119Administrators of DB2 11 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 11 for z/OS subsystem. Engage in lectures and hands-on labs to gain experience to:Relate the z/OS IPL process to a DB2 subsystemExplain effects of stopping and starting DB2Explain how DB2 sets and use Integrated Catalog Facility (ICF) catalog namesThe use of DSN command processor running in batch andforegroundUse views to minimize users' ability to see into the DB2catalogSee how the catalog (through grant activity) controls accessto dataSearch the catalog for problem situationsUse the catalog and DB2 utilities to determine data recoveryrequirementsDescribe Internal Resource Lock Manager (IRLM) in a DB2environmentImplement DB2 and Resource Access Control Facility (RACF) securityDescribe DB2 program flow for all environmentsDisplay normal and problem threads and database statusSee how the SQL Processor Using File Input (SPUFI)AUTOCOMMIT option defers the COMMIT/ROLLBACK decisionInterpret lock displaysIdentify and cancel particular threadsDescribe available DB2 utilities to manage system and userpage setsAlle IBM Trainings finden in Kooperation mit unserem Partner esciris GmbH statt.4165.00EUR
  • München (P8LGY): 25.03. - 29.03.19: AnmeldenDB2 11 for z/OS System Administration (CV852G)SMLan Software & Management TrainingKastanienallee 53Berlin10119Administrators of DB2 11 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 11 for z/OS subsystem. Engage in lectures and hands-on labs to gain experience to:Relate the z/OS IPL process to a DB2 subsystemExplain effects of stopping and starting DB2Explain how DB2 sets and use Integrated Catalog Facility (ICF) catalog namesThe use of DSN command processor running in batch andforegroundUse views to minimize users' ability to see into the DB2catalogSee how the catalog (through grant activity) controls accessto dataSearch the catalog for problem situationsUse the catalog and DB2 utilities to determine data recoveryrequirementsDescribe Internal Resource Lock Manager (IRLM) in a DB2environmentImplement DB2 and Resource Access Control Facility (RACF) securityDescribe DB2 program flow for all environmentsDisplay normal and problem threads and database statusSee how the SQL Processor Using File Input (SPUFI)AUTOCOMMIT option defers the COMMIT/ROLLBACK decisionInterpret lock displaysIdentify and cancel particular threadsDescribe available DB2 utilities to manage system and userpage setsAlle IBM Trainings finden in Kooperation mit unserem Partner esciris GmbH statt.4165.00EUR
  • Frankfurt (ADGK6): 03.06. - 07.06.19: AnmeldenDB2 11 for z/OS System Administration (CV852G)SMLan Software & Management TrainingKastanienallee 53Berlin10119Administrators of DB2 11 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 11 for z/OS subsystem. Engage in lectures and hands-on labs to gain experience to:Relate the z/OS IPL process to a DB2 subsystemExplain effects of stopping and starting DB2Explain how DB2 sets and use Integrated Catalog Facility (ICF) catalog namesThe use of DSN command processor running in batch andforegroundUse views to minimize users' ability to see into the DB2catalogSee how the catalog (through grant activity) controls accessto dataSearch the catalog for problem situationsUse the catalog and DB2 utilities to determine data recoveryrequirementsDescribe Internal Resource Lock Manager (IRLM) in a DB2environmentImplement DB2 and Resource Access Control Facility (RACF) securityDescribe DB2 program flow for all environmentsDisplay normal and problem threads and database statusSee how the SQL Processor Using File Input (SPUFI)AUTOCOMMIT option defers the COMMIT/ROLLBACK decisionInterpret lock displaysIdentify and cancel particular threadsDescribe available DB2 utilities to manage system and userpage setsAlle IBM Trainings finden in Kooperation mit unserem Partner esciris GmbH statt.4165.00EUR
  • Berlin (CXHPA): 19.08. - 23.08.19: AnmeldenDB2 11 for z/OS System Administration (CV852G)SMLan Software & Management TrainingKastanienallee 53Berlin10119Administrators of DB2 11 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 11 for z/OS subsystem. Engage in lectures and hands-on labs to gain experience to:Relate the z/OS IPL process to a DB2 subsystemExplain effects of stopping and starting DB2Explain how DB2 sets and use Integrated Catalog Facility (ICF) catalog namesThe use of DSN command processor running in batch andforegroundUse views to minimize users' ability to see into the DB2catalogSee how the catalog (through grant activity) controls accessto dataSearch the catalog for problem situationsUse the catalog and DB2 utilities to determine data recoveryrequirementsDescribe Internal Resource Lock Manager (IRLM) in a DB2environmentImplement DB2 and Resource Access Control Facility (RACF) securityDescribe DB2 program flow for all environmentsDisplay normal and problem threads and database statusSee how the SQL Processor Using File Input (SPUFI)AUTOCOMMIT option defers the COMMIT/ROLLBACK decisionInterpret lock displaysIdentify and cancel particular threadsDescribe available DB2 utilities to manage system and userpage setsAlle IBM Trainings finden in Kooperation mit unserem Partner esciris GmbH statt.4165.00EUR
  • Hamburg (O0I36): 14.10. - 18.10.19: AnmeldenDB2 11 for z/OS System Administration (CV852G)SMLan Software & Management TrainingKastanienallee 53Berlin10119Administrators of DB2 11 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 11 for z/OS subsystem. Engage in lectures and hands-on labs to gain experience to:Relate the z/OS IPL process to a DB2 subsystemExplain effects of stopping and starting DB2Explain how DB2 sets and use Integrated Catalog Facility (ICF) catalog namesThe use of DSN command processor running in batch andforegroundUse views to minimize users' ability to see into the DB2catalogSee how the catalog (through grant activity) controls accessto dataSearch the catalog for problem situationsUse the catalog and DB2 utilities to determine data recoveryrequirementsDescribe Internal Resource Lock Manager (IRLM) in a DB2environmentImplement DB2 and Resource Access Control Facility (RACF) securityDescribe DB2 program flow for all environmentsDisplay normal and problem threads and database statusSee how the SQL Processor Using File Input (SPUFI)AUTOCOMMIT option defers the COMMIT/ROLLBACK decisionInterpret lock displaysIdentify and cancel particular threadsDescribe available DB2 utilities to manage system and userpage setsAlle IBM Trainings finden in Kooperation mit unserem Partner esciris GmbH statt.4165.00EUR
  • Stuttgart (LWQZ4): 09.12. - 13.12.19: AnmeldenDB2 11 for z/OS System Administration (CV852G)SMLan Software & Management TrainingKastanienallee 53Berlin10119Administrators of DB2 11 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 11 for z/OS subsystem. Engage in lectures and hands-on labs to gain experience to:Relate the z/OS IPL process to a DB2 subsystemExplain effects of stopping and starting DB2Explain how DB2 sets and use Integrated Catalog Facility (ICF) catalog namesThe use of DSN command processor running in batch andforegroundUse views to minimize users' ability to see into the DB2catalogSee how the catalog (through grant activity) controls accessto dataSearch the catalog for problem situationsUse the catalog and DB2 utilities to determine data recoveryrequirementsDescribe Internal Resource Lock Manager (IRLM) in a DB2environmentImplement DB2 and Resource Access Control Facility (RACF) securityDescribe DB2 program flow for all environmentsDisplay normal and problem threads and database statusSee how the SQL Processor Using File Input (SPUFI)AUTOCOMMIT option defers the COMMIT/ROLLBACK decisionInterpret lock displaysIdentify and cancel particular threadsDescribe available DB2 utilities to manage system and userpage setsAlle IBM Trainings finden in Kooperation mit unserem Partner esciris GmbH statt.4165.00EUR
Hinweis

Das Training findet auf Deutsch statt.

Kurspreis für offene Schulungen

3500,00 € zzgl. 19% MwSt. (4165,00 € inkl. 19% MwSt.)