{"id":3851,"date":"2021-12-01T10:20:00","date_gmt":"2021-12-01T09:20:00","guid":{"rendered":"https:\/\/grupoloyal.net\/curso-db2-10-for-z-os-system-administration\/"},"modified":"2021-12-01T10:20:00","modified_gmt":"2021-12-01T09:20:00","slug":"curso-db2-10-for-z-os-system-administration","status":"publish","type":"post","link":"https:\/\/grupoloyal.net\/curso-db2-10-for-z-os-system-administration\/","title":{"rendered":"DB2 10 for z\/OS System Administration"},"content":{"rendered":"

[et_pb_section fb_built=\u00bb1″ fullwidth=\u00bbon\u00bb _builder_version=\u00bb4.4.0″][et_pb_fullwidth_image src=\u00bbhttps:\/\/grupoloyal.net\/wp-content\/uploads\/2022\/02\/curso-e1645533395126.jpg\u00bb _builder_version=\u00bb4.4.0″ hover_enabled=\u00bb0″ min_height=\u00bb223.3px\u00bb height=\u00bb530px\u00bb][\/et_pb_fullwidth_image][\/et_pb_section][et_pb_section fb_built=\u00bb1″ _builder_version=\u00bb4.4.0″ min_height=\u00bb106px\u00bb custom_padding=\u00bb12px||0px|||\u00bb background_color=\u00bb#eaeaea\u00bb hover_enabled=\u00bb0″][et_pb_row _builder_version=\u00bb4.4.0″][et_pb_column _builder_version=\u00bb4.4.0″ type=\u00bb4_4″][et_pb_text _builder_version=\u00bb4.4.0″ hover_enabled=\u00bb0″]<\/p>\n

DB2 10 for z\/OS System Administration<\/h1>\n

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).<\/p>\n

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:<\/p>\n

Relate the z\/OS IPL process to a DB2 subsystem
\nExplain effects of stopping and starting DB2
\nExplain how DB2 sets and use Integrated Catalog Facility (ICF) catalog names
\nThe use of DSN command processor running in batch and foreground
\nUse views to minimize your ability to see into the DB2 catalog
\nSee how the catalog (through grant activity) controls access to data
\nSearch the catalog for problem situations
\nUse the catalog and DB2 utilities to determine data recovery requirements
\nDescribe Internal Resource Lock Manager (IRLM) in a DB2 environment
\nImplement DB2 and Resource Access Control Facility (RACF) security
\nDescribe DB2 program flow for all environments
\nDisplay normal and problem threads and database status
\nSee how the SQL Processor Using File Input (SPUFI) AUTOCOMMIT option defers the COMMIT\/ROLLBACK decision
\nInterpret lock displays
\nIdentify and cancel particular threads
\nDescribe available DB2 utilities to manage system and user page sets
\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=\u00bb1″ _builder_version=\u00bb4.4.0″ custom_padding=\u00bb52px|||||\u00bb][et_pb_row column_structure=\u00bb3_5,2_5″ _builder_version=\u00bb4.4.0″ hover_enabled=\u00bb0″][et_pb_column type=\u00bb3_5″ _builder_version=\u00bb4.4.0″ hover_enabled=\u00bb0″][et_pb_blurb title=\u00bbObjetivos\u00bb image=\u00bbhttp:\/\/itformacion.ivanosuna.com\/wp-content\/uploads\/2020\/09\/curso-objetivos.png\u00bb icon_placement=\u00bbleft\u00bb _builder_version=\u00bb4.4.0″ hover_enabled=\u00bb0″ header_font_size=\u00bb19px\u00bb]
\nStart and stop the DB2 subsystem
\nExplain the allocation CLIST used at logon for DB2 data sets
\nUse Set SYSPARM command
\nLocate the Command recognition character for the DB2 subsystem
\nQuery the system log to gain knowledge about the IPL process and information in the system log when DB2 is initialized or stopped
\nExplore DB2 Address Spaces information
\nSelect the DB2 functions that best satisfy your site requirements
\nExplain the use of RACF for DB2 connection security
\nExplain the use of Roles and Trusted Context
\nImplement security procedures for a DB2 environment
\nDescribe the components and address space structure of a DB2 subsystem
\nExplain DB2 Program Flow for all environments
\nExplain parameter settings for the IRLM
\nDisplay storage values for the IRLMPROC
\nDynamically change IRLM storage
\nEstimate lock storage required for the IRLM
\nInvoke and use DB2 TSO Facilities
\nUse the DB2 Catalog to monitor authorizations
\nIncrease the size of the Active Log data sets
\nExplain DB2 Logging
\nUse SET LOG SUSPEND and SET LOG RESUME
\nUse DSNJU004 to Print Log Map
\nInterpret the output of Print Log Map
\nUse DSNJU003 to rename DB2 data sets
\nPlan for recovery of a BSDS failure
\nMonitor and control DB2
\nExplain transaction flow in IMS and CICS
\nDescribe the CICS and DB2 environment
\nExplain the difference between JDBC and SQLJ<\/p>\n

[\/et_pb_blurb][\/et_pb_column][et_pb_column type=\u00bb2_5″ _builder_version=\u00bb4.4.0″][et_pb_blurb image=\u00bbhttp:\/\/itformacion.ivanosuna.com\/wp-content\/uploads\/2020\/09\/curso-palabras-clave-300×300.png\u00bb icon_placement=\u00bbleft\u00bb _builder_version=\u00bb4.4.0″ hover_enabled=\u00bb0″]<\/p>\n

Administraci\u00f3n y programaci\u00f3n bases de datos <\/strong><\/p>\n

[\/et_pb_blurb][et_pb_blurb image=\u00bbhttp:\/\/itformacion.ivanosuna.com\/wp-content\/uploads\/2020\/09\/curso-elearning-300×194.png\u00bb icon_placement=\u00bbleft\u00bb _builder_version=\u00bb4.4.0″ hover_enabled=\u00bb0″]<\/p>\n

Disponible en formato e-learning<\/strong><\/p>\n

[\/et_pb_blurb][et_pb_blurb image=\u00bbhttp:\/\/itformacion.ivanosuna.com\/wp-content\/uploads\/2020\/09\/curso-presencial.png\u00bb icon_placement=\u00bbleft\u00bb _builder_version=\u00bb4.4.0″ hover_enabled=\u00bb0″]<\/p>\n

Disponible en formato presencial<\/strong><\/p>\n

[\/et_pb_blurb][et_pb_blurb image=\u00bbhttp:\/\/itformacion.ivanosuna.com\/wp-content\/uploads\/2020\/09\/curso-remoto-300×300.png\u00bb icon_placement=\u00bbleft\u00bb _builder_version=\u00bb4.4.0″ hover_enabled=\u00bb0″]<\/p>\n

Disponible en formato a distancia<\/strong><\/p>\n

[\/et_pb_blurb][et_pb_blurb image=\u00bbhttp:\/\/itformacion.ivanosuna.com\/wp-content\/uploads\/2020\/09\/curso-remoto-300×300.png\u00bb icon_placement=\u00bbleft\u00bb _builder_version=\u00bb4.4.0″ hover_enabled=\u00bb0″]<\/p>\n

Acceso al campus<\/strong><\/a><\/p>\n

[\/et_pb_blurb][et_pb_blurb image=\u00bbhttp:\/\/itformacion.ivanosuna.com\/wp-content\/uploads\/2020\/09\/curso-subvencionado-300×300.png\u00bb icon_placement=\u00bbleft\u00bb _builder_version=\u00bb4.4.0″ hover_enabled=\u00bb0″]<\/p>\n

Subvenci\u00f3n disponible<\/strong>
\nA trav\u00e9s de Fundae, cumpliendo requisitos.<\/p>\n

[\/et_pb_blurb][et_pb_blurb image=\u00bbhttp:\/\/itformacion.ivanosuna.com\/wp-content\/uploads\/2020\/09\/curso-duracion-1-290×300.png\u00bb icon_placement=\u00bbleft\u00bb _builder_version=\u00bb4.4.0″ hover_enabled=\u00bb0″]<\/p>\n

Duraci\u00f3n<\/strong>
\n25 horas<\/p>\n

[\/et_pb_blurb][et_pb_counters _builder_version=\u00bb4.4.0″][et_pb_counter percent=\u00bb50″ _builder_version=\u00bb4.4.0″ percent_text_color=\u00bb#e88b00″ background_enable_color_default=\u00bbon\u00bb parallax_default=\u00bboff\u00bb parallax_method_default=\u00bbon\u00bb bar_background_color_default=\u00bb#e88b00″ use_percentages=\u00bbon\u00bb allow_player_pause_default=\u00bboff\u00bb]Dificultad[\/et_pb_counter][et_pb_counter percent=\u00bb80″ _builder_version=\u00bb4.4.0″ percent_text_color=\u00bb#e88b00″ background_enable_color_default=\u00bbon\u00bb parallax_default=\u00bboff\u00bb parallax_method_default=\u00bbon\u00bb bar_background_color_default=\u00bb#e88b00″ use_percentages=\u00bbon\u00bb allow_player_pause_default=\u00bboff\u00bb]Nivel alcanzado[\/et_pb_counter][\/et_pb_counters][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=\u00bb1″ _builder_version=\u00bb4.4.0″ background_color=\u00bb#eeeeee\u00bb min_height=\u00bb194px\u00bb custom_padding=\u00bb17px||19px|||\u00bb][et_pb_row column_structure=\u00bb1_2,1_2″ _builder_version=\u00bb4.4.0″][et_pb_column type=\u00bb1_2″ _builder_version=\u00bb4.4.0″][et_pb_blurb title=\u00bbDirigido a\u00bb image=\u00bbhttp:\/\/itformacion.ivanosuna.com\/wp-content\/uploads\/2020\/09\/curso-dirigido-a-300×268.png\u00bb icon_placement=\u00bbleft\u00bb _builder_version=\u00bb4.4.0″ child_filter_saturate=\u00bb0%\u00bb child_filter_brightness=\u00bb200%\u00bb]<\/p>\n

\n
\n

This intermediate course is for system administrators, database administrators, and other technical individuals, who manage and implement DB2 10 for z\/OS.<\/p>\n<\/div>\n<\/div>\n

\n
<\/div>\n<\/div>\n

[\/et_pb_blurb][\/et_pb_column][et_pb_column type=\u00bb1_2″ _builder_version=\u00bb4.4.0″][et_pb_blurb title=\u00bbConocimientos requeridos\u00bb image=\u00bbhttp:\/\/itformacion.ivanosuna.com\/wp-content\/uploads\/2020\/09\/curso-skils.png\u00bb icon_placement=\u00bbleft\u00bb _builder_version=\u00bb4.4.0″ custom_margin=\u00bb||-120px|||\u00bb child_filter_saturate=\u00bb0%\u00bb child_filter_brightness=\u00bb200%\u00bb]<\/p>\n

\n
\n
\n

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.<\/p>\n

These skills can be developed by taking the DB2 Database Administration Workshop (CF83) \/ DB2 9 for z\/OS Database Administration Workshop Part 1 (CV830) or through equivalent experience. You should also have a working knowledge of SQL. The DB2 SQL Workshop (CF12) \/ SQL Workshop – Instructor Led Online (3E120) provides that.<\/p>\n

In addition, you should have:<\/p>\n

At least one year as a z\/OS systems programmer orequivalent experience
\nOr, one year working with DB2 on the mainframe as a DBA on the mainframe or equivalent experience\n<\/p><\/div>\n<\/div>\n

\n
<\/div>\n<\/div>\n

[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=\u00bb1″ _builder_version=\u00bb4.4.0″ custom_margin=\u00bb1px|||||\u00bb][et_pb_row _builder_version=\u00bb4.4.0″][et_pb_column type=\u00bb4_4″ _builder_version=\u00bb4.4.0″]
\n[et_pb_text content_tablet=\u00bb\u00bb]<\/p>\n

Temario<\/h2>\n

Basic architecture and fundamental mechanisms<\/p>\n

Explain the principles of:
\nIPLing z\/OS
\nTSO\/E LOGON
\nAllocation CLIST
\nControl of DB2
\nSTART DB2 process
\nDSNZPARM member
\nDB2 address space structure
\nDB2 log
\nCatalog and directory
\nData sharing feature
\nConnection process
\nCommand routing process
\nProgram preparation and execution processes
\nTransaction and points of consistency
\nSet up and tune the IRLM
\nRecognize the important IRLM parameters
\nSystem security<\/p>\n

Protect DB2 data sets when DB2 is up or down
\nProtect connections to DB2
\nDescribe the high-level operation of DB2 security exits
\nDB2 program flow for all environments<\/p>\n

Describe DB2 program execution
\nExplain what a DB2 thread is
\nExplain commit processing
\nDescribe connection types
\nDSN
\nCAF
\nIMS
\nCICS
\nRRSAF
\nTSO and batch environments<\/p>\n

Describe TSO facilities
\nDescribe the facilities of DB2I
\nInvoke the DSN command processor in various ways
\nInvoke DB2 utilities
\nDescribe the QMF environment
\nDB2 authorization<\/p>\n

Provide appropriate authorization for your user community
\nMonitor authorization in the DB2 catalog
\nEffectively assign administrative authorities like SYSADM, DBADM, and BINDAGENT
\nCreate objects for others
\nLogging<\/p>\n

Explain the basic algorithms of the DB2 logging facility
\nSet up and operate your log efficiently
\nRecover from BSDS failures
\nRecover from certain lost log data set situations
\nExplain the use of the log maintenance tools
\nDB2 9 for z\/OS utilities<\/p>\n

Categorize and discuss DB2 utilities
\nExplain how to back up and recover DB2 objects using BACKUP SYSTEM and RESTORE SYSTEM utilities
\nDefine high-level qualifier for catalog and directory
\nRename DB2 data sets
\nPrint log map of BSDS
\nObject recovery<\/p>\n

Describe the different types of application recovery
\nPerform various health checks to detect damaged data
\nRead the log using DSN1LOGP
\nAvoid certain lost log scenarios
\nTransaction flow in IMS and CICS<\/p>\n

Describe the two-phase commit process
\nExplain thread recycling and the complete connection process for a DB2 thread
\nDescribe the input to and output from a SIGNON exit
\nCICS – DB2 environment<\/p>\n

Outline a CICS connection to DB2
\nUse the DSNC transaction
\nEncourage CICS thread recycling
\nOperations (monitoring and controlling DB2)<\/p>\n

Monitor and control DB2
\nTrain operators at your local site
\nDiscuss the functions of ATS (Administrative Task Scheduler)
\nSystem recovery\/restart<\/p>\n

Describe the DB2 restart process following both normal and abnormal terminations
\nPrevent restart failures
\nRecover from restart failures
\nBegin planning for offsite recovery
\nIMS – DB2 environment<\/p>\n

Integrate IMS transactions into the DB2 environment
\nIntegrate IMS BATCH jobs into the DB2 environment
\nControl which plans, subsystems, and connection IDs transactions and batch jobs use
\nDistributed – DB2 environment<\/p>\n

Describe the use of DB2 for z\/OS enterprise servers in a multitier environment
\nExplain the difference between JDBC and SQLJ
\nDescribe the Java database connectivity capabilities: use SQLJ and\/or JDBC
\nDocument the requirements to set up the DB2 and Java environment in a z\/OS environment
\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=\u00bb1″ _builder_version=\u00bb4.4.0″ background_color=\u00bb#032b35″][et_pb_row _builder_version=\u00bb4.4.0″][et_pb_column type=\u00bb4_4″ _builder_version=\u00bb4.4.0″][et_pb_contact_form captcha=\u00bboff\u00bb title=\u00bbSolicita informaci\u00f3n del curso\u00bb submit_button_text=\u00bbSolicitar informaci\u00f3n ahora\u00bb _builder_version=\u00bb4.4.0″ title_text_color=\u00bb#ffffff\u00bb title_font_size=\u00bb30px\u00bb][et_pb_contact_field field_id=\u00bbName\u00bb field_title=\u00bbNombre\u00bb _builder_version=\u00bb3.16″ button_text_size__hover_enabled=\u00bboff\u00bb button_one_text_size__hover_enabled=\u00bboff\u00bb button_two_text_size__hover_enabled=\u00bboff\u00bb button_text_color__hover_enabled=\u00bboff\u00bb button_one_text_color__hover_enabled=\u00bboff\u00bb button_two_text_color__hover_enabled=\u00bboff\u00bb button_border_width__hover_enabled=\u00bboff\u00bb button_one_border_width__hover_enabled=\u00bboff\u00bb button_two_border_width__hover_enabled=\u00bboff\u00bb button_border_color__hover_enabled=\u00bboff\u00bb button_one_border_color__hover_enabled=\u00bboff\u00bb button_two_border_color__hover_enabled=\u00bboff\u00bb button_border_radius__hover_enabled=\u00bboff\u00bb button_one_border_radius__hover_enabled=\u00bboff\u00bb button_two_border_radius__hover_enabled=\u00bboff\u00bb button_letter_spacing__hover_enabled=\u00bboff\u00bb button_one_letter_spacing__hover_enabled=\u00bboff\u00bb button_two_letter_spacing__hover_enabled=\u00bboff\u00bb button_bg_color__hover_enabled=\u00bboff\u00bb button_one_bg_color__hover_enabled=\u00bboff\u00bb button_two_bg_color__hover_enabled=\u00bboff\u00bb][\/et_pb_contact_field][et_pb_contact_field field_id=\u00bbEmail\u00bb field_title=\u00bbDirecci\u00f3n de correo electr\u00f3nico\u00bb field_type=\u00bbemail\u00bb _builder_version=\u00bb3.16″ button_text_size__hover_enabled=\u00bboff\u00bb button_one_text_size__hover_enabled=\u00bboff\u00bb button_two_text_size__hover_enabled=\u00bboff\u00bb button_text_color__hover_enabled=\u00bboff\u00bb button_one_text_color__hover_enabled=\u00bboff\u00bb button_two_text_color__hover_enabled=\u00bboff\u00bb button_border_width__hover_enabled=\u00bboff\u00bb button_one_border_width__hover_enabled=\u00bboff\u00bb button_two_border_width__hover_enabled=\u00bboff\u00bb button_border_color__hover_enabled=\u00bboff\u00bb button_one_border_color__hover_enabled=\u00bboff\u00bb button_two_border_color__hover_enabled=\u00bboff\u00bb button_border_radius__hover_enabled=\u00bboff\u00bb button_one_border_radius__hover_enabled=\u00bboff\u00bb button_two_border_radius__hover_enabled=\u00bboff\u00bb button_letter_spacing__hover_enabled=\u00bboff\u00bb button_one_letter_spacing__hover_enabled=\u00bboff\u00bb button_two_letter_spacing__hover_enabled=\u00bboff\u00bb button_bg_color__hover_enabled=\u00bboff\u00bb button_one_bg_color__hover_enabled=\u00bboff\u00bb button_two_bg_color__hover_enabled=\u00bboff\u00bb][\/et_pb_contact_field][et_pb_contact_field field_id=\u00bbEmpresa\u00bb field_title=\u00bbEmpresa\u00bb fullwidth_field=\u00bbon\u00bb _builder_version=\u00bb4.4.0″][\/et_pb_contact_field][et_pb_contact_field field_id=\u00bbMessage\u00bb field_title=\u00bbCu\u00e9ntanos un poco sobre tus necesidades\u00bb field_type=\u00bbtext\u00bb fullwidth_field=\u00bbon\u00bb _builder_version=\u00bb4.4.0″ form_field_text_color=\u00bb#555555″ button_text_size__hover_enabled=\u00bboff\u00bb button_one_text_size__hover_enabled=\u00bboff\u00bb button_two_text_size__hover_enabled=\u00bboff\u00bb button_text_color__hover_enabled=\u00bboff\u00bb button_one_text_color__hover_enabled=\u00bboff\u00bb button_two_text_color__hover_enabled=\u00bboff\u00bb button_border_width__hover_enabled=\u00bboff\u00bb button_one_border_width__hover_enabled=\u00bboff\u00bb button_two_border_width__hover_enabled=\u00bboff\u00bb button_border_color__hover_enabled=\u00bboff\u00bb button_one_border_color__hover_enabled=\u00bboff\u00bb button_two_border_color__hover_enabled=\u00bboff\u00bb button_border_radius__hover_enabled=\u00bboff\u00bb button_one_border_radius__hover_enabled=\u00bboff\u00bb button_two_border_radius__hover_enabled=\u00bboff\u00bb button_letter_spacing__hover_enabled=\u00bboff\u00bb button_one_letter_spacing__hover_enabled=\u00bboff\u00bb button_two_letter_spacing__hover_enabled=\u00bboff\u00bb button_bg_color__hover_enabled=\u00bboff\u00bb button_one_bg_color__hover_enabled=\u00bboff\u00bb button_two_bg_color__hover_enabled=\u00bboff\u00bb][\/et_pb_contact_field][\/et_pb_contact_form][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

25 horas<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"2880","footnotes":""},"categories":[49,9,11],"tags":[],"class_list":["post-3851","post","type-post","status-publish","format-standard","hentry","category-bases-de-datos","category-cursos","category-cursos-de-it"],"acf":[],"_links":{"self":[{"href":"https:\/\/grupoloyal.net\/wp-json\/wp\/v2\/posts\/3851","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/grupoloyal.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/grupoloyal.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/grupoloyal.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/grupoloyal.net\/wp-json\/wp\/v2\/comments?post=3851"}],"version-history":[{"count":0,"href":"https:\/\/grupoloyal.net\/wp-json\/wp\/v2\/posts\/3851\/revisions"}],"wp:attachment":[{"href":"https:\/\/grupoloyal.net\/wp-json\/wp\/v2\/media?parent=3851"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/grupoloyal.net\/wp-json\/wp\/v2\/categories?post=3851"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/grupoloyal.net\/wp-json\/wp\/v2\/tags?post=3851"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}