DB2 11 for z/OS System Administration

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 and foreground
Use views to minimize users’ 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
Learning Journeys or Training Paths that reference this course:

Db2 for z/OS – Role: Database Administrator
Db2 for z/OS – Role: System Administrator

Objetivos

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 process and information in the system log when DB2 is initialized or stopped
Explore DB2 Address Spaces information
Select the DB2 functions that best satisfy your site requirements
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 DB2 subsystem
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

Administración y programación bases de datos

Disponible en formato e-learning

Disponible en formato presencial

Disponible en formato a distancia

Subvención disponible
A través de Fundae, cumpliendo requisitos.

Duración
25 horas

  • Dificultad 50% 50%
  • Nivel alcanzado 80% 80%

Dirigido a

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

Conocimientos requeridos

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

Temario

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 process and information in the system log when DB2 is initialized or stopped
Explore DB2 Address Spaces information
Select the DB2 functions that best satisfy your site requirements
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 DB2 subsystem
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

Solicita información del curso

Esta web utiliza cookies propias y de terceros para su correcto funcionamiento y para fines analíticos. Contiene enlaces a sitios web de terceros con políticas de privacidad ajenas que podrás aceptar o no cuando accedas a ellos. Al hacer clic en el botón Aceptar, acepta el uso de estas tecnologías y el procesamiento de tus datos para estos propósitos. Ver Política de cookies
Privacidad