CV851G DB2 10 for z/OS System Administration

Overnet Education
A Segrate

1.800 
+IVA
Vuoi parlare del corso con un consulente?
Confronta questo corso con altri simili
Leggi tutto

Informazione importanti

  • Corso
  • Segrate
  • Durata:
    4 Giorni
Descrizione

A continuazione troverai il programma di questo corso disegnato per migliorare le tue competenze e permetterti di realizzare gli obiettivi stabiliti.
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 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 and foregroundUse views to minimize your ability to see into the DB2 catalogSee how the catalog (through grant activity) controls access to dataSearch the catalog for problem situationsUse the catalog and DB2 utilities to determine data recovery requirementsDescribe Internal Resource Lock Manager (IRLM) in a DB2 environmentImplement 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 user page sets

Informazione importanti
Sedi

Dove e quando

Inizio Luogo
Consultare
Segrate
Via Cassanese, 224, Palazzo Mantegna, Scala A, 20090, Milano, Italia
Visualizza mappa

Programma

Il centro presenta a continuazione il programma pensato per migliorare le tue competenze e permetterti di realizzare gli obiettivi stabiliti. Nel corso della formazione si alterneranno differenti moduli che ti permetteranno di acquisire le conoscenze sulle differenti tematiche proposte. Inscriviti per poter accedere alle seguenti materie.


  • Explain the principles of:
    • IPLing z/OS
    • TSO/E LOGON
    • Allocation CLIST
    • Control of DB2
    • START DB2 process
    • DSNZPARM member
    • DB2 address space structure
    • DB2 log
    • Catalog and directory
    • Data sharing feature
    • Connection process
    • Command routing process
    • Program preparation and execution processes
    • Transaction and points of consistency
  • Set up and tune the IRLM
  • Recognize the important IRLM parameters
  • Protect DB2 data sets when DB2 is up or down
  • Protect connections to DB2
  • Describe the high-level operation of DB2 security exits
  • Describe DB2 program execution
  • Explain what a DB2 thread is
  • Explain commit processing
  • Describe connection types
    • DSN
    • CAF
    • IMS
    • CICS
    • RRSAF
  • Describe TSO facilities
  • Describe the facilities of DB2I
  • Invoke the DSN command processor in various ways
  • Invoke DB2 utilities
  • Describe the QMF environment
  • Provide appropriate authorization for your user community
  • Monitor authorization in the DB2 catalog
  • Effectively assign administrative authorities like SYSADM, DBADM, and BINDAGENT
  • Create objects for others
  • Explain the basic algorithms of the DB2 logging facility
  • Set up and operate your log efficiently
  • Recover from BSDS failures
  • Recover from certain lost log data set situations
  • Explain the use of the log maintenance tools
  • Categorize and discuss DB2 utilities
  • Explain how to back up and recover DB2 objects using BACKUP SYSTEM and RESTORE SYSTEM utilities
  • Define high-level qualifier for catalog and directory
  • Rename DB2 data sets
  • Print log map of BSDS
  • Describe the different types of application recovery
  • Perform various health checks to detect damaged data
  • Read the log using DSN1LOGP
  • Avoid certain lost log scenarios
  • Describe the two-phase commit process
  • Explain thread recycling and the complete connection process for a DB2 thread
  • Describe the input to and output from a SIGNON exit
  • Outline a CICS connection to DB2
  • Use the DSNC transaction
  • Encourage CICS thread recycling
  • Monitor and control DB2
  • Train operators at your local site
  • Discuss the functions of ATS (Administrative Task Scheduler)
  • Describe the DB2 restart process following both normal and abnormal terminations
  • Prevent restart failures
  • Recover from restart failures
  • Begin planning for offsite recovery
  • Integrate IMS transactions into the DB2 environment
  • Integrate IMS BATCH jobs into the DB2 environment
  • Control which plans, subsystems, and connection IDs transactions and batch jobs use
  • Describe the use of DB2 for z/OS enterprise servers in a multitier environment
  • Explain the difference between JDBC and SQLJ
  • Describe the Java database connectivity capabilities: use SQLJ and/or JDBC
  • Document the requirements to set up the DB2 and Java environment in a z/OS environment

Dotazione:
Each participant will have a station set up with operating systems and software needed for the exercises.


Confronta questo corso con altri simili
Leggi tutto