{"course":{"productid":19516,"modality":6,"active":true,"language":"fr","title":"Db2 12 for z\/OS Introduction to System Administration","productcode":"CV853G","vendorcode":"IB","vendorname":"IBM","fullproductcode":"IB-CV853G","courseware":{"has_ekit":true,"has_printkit":false,"language":"en"},"url":"https:\/\/portal.flane.ch\/course\/ibm-cv853g","essentials":"<ul>\n\n\t<li>Understanding of the objects (such as databases, table spaces, tables, indexes, and so forth) used in a Db2 subsystem<\/li><li>Basic knowledge of SQL<\/li><li>At least one year as a z\/OS systems programmer or equivalent knowledge<\/li><\/ul><p>OR<\/p>\n<ul>\n\n\t<li>At least one year as a Db2 for z\/OS Database Administrator<\/li><\/ul>","audience":"<p>This course is intended for z\/OS system administrators, database administrators, or other technical individuals who will be managing Db2 12 for z\/OS.<\/p>","contents":"<p>Starting, stopping, and accessing Db2\n<\/p>\n<ul>\n<li>&bull; Starting Db2 as part of the z\/OS IPL process<\/li><li>&bull; Data set allocation and APF authorization<\/li><li>&bull; The START DB2 and STOP DB2 commands<\/li><li>&bull; zParms, DSNTIJUZ, and DSNZPARM<\/li><li>&bull; Address spaces<\/li><li>&bull; IRLM and lock storage<\/li><\/ul><p>\nDb2 components and processes\n<\/p>\n<ul>\n<li>&bull; BSDS and logging<\/li><li>&bull; Catalog and directory<\/li><li>&bull; Program preparation and execution<\/li><li>&bull; Transaction execution<\/li><li>&bull; Data sharing in the sysplex<\/li><\/ul><p>\nSystem security\n<\/p>\n<ul>\n<li>&bull; Protecting Db2 data sets<\/li><li>&bull; Controlling connections to Db2<\/li><li>&bull; Db2 authorization exits<\/li><li>&bull; Trusted context and roles<\/li><li>&bull; Securing an application server<\/li><\/ul><p>\nDb2 authorization\n<\/p>\n<ul>\n<li>&bull; Authorizations<\/li><li>&bull; Controlling access for dynamic and static SQL<\/li><li>&bull; Access control authorization exits<\/li><li>&bull; Distributed security<\/li><\/ul><p>Program flow for all environments\n<\/p>\n<ul>\n<li>&bull; Connection types and language interfaces<\/li><li>&bull; Program flow<\/li><\/ul><p>\nTSO and batch environments\n<\/p>\n<ul>\n<li>&bull; TSO<\/li><li>&bull; Utilities<\/li><\/ul><p>\nTransaction flow in IMS and CICS (optional)\n<\/p>\n<ul>\n<li>&bull; Transaction processing<\/li><li>&bull; Thread reuse<\/li><li>&bull; SIGNON exit<\/li><\/ul><p>\nCICS - Db2 environment (optional)\n<\/p>\n<ul>\n<li>&bull; CICS connections to Db2<\/li><li>&bull; DSNC transaction<\/li><\/ul><p>\nIMS - Db2 environment (optional)\n<\/p>\n<ul>\n<li>&bull; IMS-Db2 introduction<\/li><li>&bull; IMS TM<\/li><li>&bull; IMS\/DLI batch environment<\/li><\/ul><p>\nDistributed - Db2 environment\n<\/p>\n<ul>\n<li>&bull; Distributed attachment<\/li><li>&bull; Location aliases<\/li><li>&bull; DDF profiling<\/li><li>&bull; Block fetch<\/li><li>&bull; Db2 REST services<\/li><\/ul><p>\nLogging\n<\/p>\n<ul>\n<li>&bull; The Db2 log<\/li><li>&bull; Log commands<\/li><li>&bull; Archiving considerations<\/li><li>&bull; BSDS<\/li><\/ul><p>\nDb2 utilities\n<\/p>\n<ul>\n<li>&bull; Categorization<\/li><li>&bull; DSNJU003 and DSNJU004<\/li><li>&bull; BACKUP and RESTORE SYSTEM<\/li><\/ul><p>\nOperations (monitoring and controlling Db2)\n<\/p>\n<ul>\n<li>&bull; Issuing Db2 commands<\/li><li>&bull; Basic workload controls<\/li><li>&bull; Monitoring and controlling utilities<\/li><li>&bull; DISPLAY commands<\/li><li>&bull; Starting \/ stopping databases<\/li><\/ul><p>\nRecovery\n<\/p>\n<ul>\n<li>&bull; Planning for recovery<\/li><li>&bull; Table space recovery<\/li><li>&bull; Log considerations<\/li><li>&bull; DISPLAY and SET LOG commands<\/li><li>&bull; Recovery considerations<\/li><\/ul><p>\nSystem recover\/restart\n<\/p>\n<ul>\n<li>&bull; System checkpoints<\/li><li>&bull; System restart after normal shutdown<\/li><li>&bull; Page externalization<\/li><li>&bull; Two-phase commit processing<\/li><li>&bull; System restart after system failure<\/li><li>&bull; Recovery considerations<\/li><\/ul><p>\nJava with Db2&nbsp; (optional)\n<\/p>\n<ul>\n<li>&bull; Java<\/li><\/ul><p>\nAdministrative task scheduler (optional)\n<\/p>\n<ul>\n<li>&bull; Overview<\/li><li>&bull; Routines<\/li><li>&bull; Scheduling features<\/li><li>&bull; Life cycle<\/li><li>&bull; Syncronization<\/li><li>&bull; Commands<\/li><\/ul>","outline":"<p>Starting, stopping, and accessing Db2\n<\/p>\n<ul>\n<li>&bull; Starting Db2 as part of the z\/OS IPL process<\/li><li>&bull; Data set allocation and APF authorization<\/li><li>&bull; The START DB2 and STOP DB2 commands<\/li><li>&bull; zParms, DSNTIJUZ, and DSNZPARM<\/li><li>&bull; Address spaces<\/li><li>&bull; IRLM and lock storage<\/li><\/ul><p>\nDb2 components and processes\n<\/p>\n<ul>\n<li>&bull; BSDS and logging<\/li><li>&bull; Catalog and directory<\/li><li>&bull; Program preparation and execution<\/li><li>&bull; Transaction execution<\/li><li>&bull; Data sharing in the sysplex<\/li><\/ul><p>\nSystem security\n<\/p>\n<ul>\n<li>&bull; Protecting Db2 data sets<\/li><li>&bull; Controlling connections to Db2<\/li><li>&bull; Db2 authorization exits<\/li><li>&bull; Trusted context and roles<\/li><li>&bull; Securing an application server<\/li><\/ul><p>\nDb2 authorization\n<\/p>\n<ul>\n<li>&bull; Authorizations<\/li><li>&bull; Controlling access for dynamic and static SQL<\/li><li>&bull; Access control authorization exits<\/li><li>&bull; Distributed security<\/li><\/ul><p>Program flow for all environments\n<\/p>\n<ul>\n<li>&bull; Connection types and language interfaces<\/li><li>&bull; Program flow<\/li><\/ul><p>\nTSO and batch environments\n<\/p>\n<ul>\n<li>&bull; TSO<\/li><li>&bull; Utilities<\/li><\/ul><p>\nTransaction flow in IMS and CICS (optional)\n<\/p>\n<ul>\n<li>&bull; Transaction processing<\/li><li>&bull; Thread reuse<\/li><li>&bull; SIGNON exit<\/li><\/ul><p>\nCICS - Db2 environment (optional)\n<\/p>\n<ul>\n<li>&bull; CICS connections to Db2<\/li><li>&bull; DSNC transaction<\/li><\/ul><p>\nIMS - Db2 environment (optional)\n<\/p>\n<ul>\n<li>&bull; IMS-Db2 introduction<\/li><li>&bull; IMS TM<\/li><li>&bull; IMS\/DLI batch environment<\/li><\/ul><p>\nDistributed - Db2 environment\n<\/p>\n<ul>\n<li>&bull; Distributed attachment<\/li><li>&bull; Location aliases<\/li><li>&bull; DDF profiling<\/li><li>&bull; Block fetch<\/li><li>&bull; Db2 REST services<\/li><\/ul><p>\nLogging\n<\/p>\n<ul>\n<li>&bull; The Db2 log<\/li><li>&bull; Log commands<\/li><li>&bull; Archiving considerations<\/li><li>&bull; BSDS<\/li><\/ul><p>\nDb2 utilities\n<\/p>\n<ul>\n<li>&bull; Categorization<\/li><li>&bull; DSNJU003 and DSNJU004<\/li><li>&bull; BACKUP and RESTORE SYSTEM<\/li><\/ul><p>\nOperations (monitoring and controlling Db2)\n<\/p>\n<ul>\n<li>&bull; Issuing Db2 commands<\/li><li>&bull; Basic workload controls<\/li><li>&bull; Monitoring and controlling utilities<\/li><li>&bull; DISPLAY commands<\/li><li>&bull; Starting \/ stopping databases<\/li><\/ul><p>\nRecovery\n<\/p>\n<ul>\n<li>&bull; Planning for recovery<\/li><li>&bull; Table space recovery<\/li><li>&bull; Log considerations<\/li><li>&bull; DISPLAY and SET LOG commands<\/li><li>&bull; Recovery considerations<\/li><\/ul><p>\nSystem recover\/restart\n<\/p>\n<ul>\n<li>&bull; System checkpoints<\/li><li>&bull; System restart after normal shutdown<\/li><li>&bull; Page externalization<\/li><li>&bull; Two-phase commit processing<\/li><li>&bull; System restart after system failure<\/li><li>&bull; Recovery considerations<\/li><\/ul><p>\nJava with Db2&nbsp; (optional)\n<\/p>\n<ul>\n<li>&bull; Java<\/li><\/ul><p>\nAdministrative task scheduler (optional)\n<\/p>\n<ul>\n<li>&bull; Overview<\/li><li>&bull; Routines<\/li><li>&bull; Scheduling features<\/li><li>&bull; Life cycle<\/li><li>&bull; Syncronization<\/li><li>&bull; Commands<\/li><\/ul>","summary":"<p>This course provides students with an introduction to the skills and knowledge needed to administer a Db2 12 for z\/OS system.<\/p>","essentials_plain":"- Understanding of the objects (such as databases, table spaces, tables, indexes, and so forth) used in a Db2 subsystem\n- Basic knowledge of SQL\n- At least one year as a z\/OS systems programmer or equivalent knowledge\nOR\n\n\n\n\t- At least one year as a Db2 for z\/OS Database Administrator","audience_plain":"This course is intended for z\/OS system administrators, database administrators, or other technical individuals who will be managing Db2 12 for z\/OS.","contents_plain":"Starting, stopping, and accessing Db2\n\n\n\n- \u2022 Starting Db2 as part of the z\/OS IPL process\n- \u2022 Data set allocation and APF authorization\n- \u2022 The START DB2 and STOP DB2 commands\n- \u2022 zParms, DSNTIJUZ, and DSNZPARM\n- \u2022 Address spaces\n- \u2022 IRLM and lock storage\n\nDb2 components and processes\n\n\n\n- \u2022 BSDS and logging\n- \u2022 Catalog and directory\n- \u2022 Program preparation and execution\n- \u2022 Transaction execution\n- \u2022 Data sharing in the sysplex\n\nSystem security\n\n\n\n- \u2022 Protecting Db2 data sets\n- \u2022 Controlling connections to Db2\n- \u2022 Db2 authorization exits\n- \u2022 Trusted context and roles\n- \u2022 Securing an application server\n\nDb2 authorization\n\n\n\n- \u2022 Authorizations\n- \u2022 Controlling access for dynamic and static SQL\n- \u2022 Access control authorization exits\n- \u2022 Distributed security\nProgram flow for all environments\n\n\n\n- \u2022 Connection types and language interfaces\n- \u2022 Program flow\n\nTSO and batch environments\n\n\n\n- \u2022 TSO\n- \u2022 Utilities\n\nTransaction flow in IMS and CICS (optional)\n\n\n\n- \u2022 Transaction processing\n- \u2022 Thread reuse\n- \u2022 SIGNON exit\n\nCICS - Db2 environment (optional)\n\n\n\n- \u2022 CICS connections to Db2\n- \u2022 DSNC transaction\n\nIMS - Db2 environment (optional)\n\n\n\n- \u2022 IMS-Db2 introduction\n- \u2022 IMS TM\n- \u2022 IMS\/DLI batch environment\n\nDistributed - Db2 environment\n\n\n\n- \u2022 Distributed attachment\n- \u2022 Location aliases\n- \u2022 DDF profiling\n- \u2022 Block fetch\n- \u2022 Db2 REST services\n\nLogging\n\n\n\n- \u2022 The Db2 log\n- \u2022 Log commands\n- \u2022 Archiving considerations\n- \u2022 BSDS\n\nDb2 utilities\n\n\n\n- \u2022 Categorization\n- \u2022 DSNJU003 and DSNJU004\n- \u2022 BACKUP and RESTORE SYSTEM\n\nOperations (monitoring and controlling Db2)\n\n\n\n- \u2022 Issuing Db2 commands\n- \u2022 Basic workload controls\n- \u2022 Monitoring and controlling utilities\n- \u2022 DISPLAY commands\n- \u2022 Starting \/ stopping databases\n\nRecovery\n\n\n\n- \u2022 Planning for recovery\n- \u2022 Table space recovery\n- \u2022 Log considerations\n- \u2022 DISPLAY and SET LOG commands\n- \u2022 Recovery considerations\n\nSystem recover\/restart\n\n\n\n- \u2022 System checkpoints\n- \u2022 System restart after normal shutdown\n- \u2022 Page externalization\n- \u2022 Two-phase commit processing\n- \u2022 System restart after system failure\n- \u2022 Recovery considerations\n\nJava with Db2\u00a0 (optional)\n\n\n\n- \u2022 Java\n\nAdministrative task scheduler (optional)\n\n\n\n- \u2022 Overview\n- \u2022 Routines\n- \u2022 Scheduling features\n- \u2022 Life cycle\n- \u2022 Syncronization\n- \u2022 Commands","outline_plain":"Starting, stopping, and accessing Db2\n\n\n\n- \u2022 Starting Db2 as part of the z\/OS IPL process\n- \u2022 Data set allocation and APF authorization\n- \u2022 The START DB2 and STOP DB2 commands\n- \u2022 zParms, DSNTIJUZ, and DSNZPARM\n- \u2022 Address spaces\n- \u2022 IRLM and lock storage\n\nDb2 components and processes\n\n\n\n- \u2022 BSDS and logging\n- \u2022 Catalog and directory\n- \u2022 Program preparation and execution\n- \u2022 Transaction execution\n- \u2022 Data sharing in the sysplex\n\nSystem security\n\n\n\n- \u2022 Protecting Db2 data sets\n- \u2022 Controlling connections to Db2\n- \u2022 Db2 authorization exits\n- \u2022 Trusted context and roles\n- \u2022 Securing an application server\n\nDb2 authorization\n\n\n\n- \u2022 Authorizations\n- \u2022 Controlling access for dynamic and static SQL\n- \u2022 Access control authorization exits\n- \u2022 Distributed security\nProgram flow for all environments\n\n\n\n- \u2022 Connection types and language interfaces\n- \u2022 Program flow\n\nTSO and batch environments\n\n\n\n- \u2022 TSO\n- \u2022 Utilities\n\nTransaction flow in IMS and CICS (optional)\n\n\n\n- \u2022 Transaction processing\n- \u2022 Thread reuse\n- \u2022 SIGNON exit\n\nCICS - Db2 environment (optional)\n\n\n\n- \u2022 CICS connections to Db2\n- \u2022 DSNC transaction\n\nIMS - Db2 environment (optional)\n\n\n\n- \u2022 IMS-Db2 introduction\n- \u2022 IMS TM\n- \u2022 IMS\/DLI batch environment\n\nDistributed - Db2 environment\n\n\n\n- \u2022 Distributed attachment\n- \u2022 Location aliases\n- \u2022 DDF profiling\n- \u2022 Block fetch\n- \u2022 Db2 REST services\n\nLogging\n\n\n\n- \u2022 The Db2 log\n- \u2022 Log commands\n- \u2022 Archiving considerations\n- \u2022 BSDS\n\nDb2 utilities\n\n\n\n- \u2022 Categorization\n- \u2022 DSNJU003 and DSNJU004\n- \u2022 BACKUP and RESTORE SYSTEM\n\nOperations (monitoring and controlling Db2)\n\n\n\n- \u2022 Issuing Db2 commands\n- \u2022 Basic workload controls\n- \u2022 Monitoring and controlling utilities\n- \u2022 DISPLAY commands\n- \u2022 Starting \/ stopping databases\n\nRecovery\n\n\n\n- \u2022 Planning for recovery\n- \u2022 Table space recovery\n- \u2022 Log considerations\n- \u2022 DISPLAY and SET LOG commands\n- \u2022 Recovery considerations\n\nSystem recover\/restart\n\n\n\n- \u2022 System checkpoints\n- \u2022 System restart after normal shutdown\n- \u2022 Page externalization\n- \u2022 Two-phase commit processing\n- \u2022 System restart after system failure\n- \u2022 Recovery considerations\n\nJava with Db2\u00a0 (optional)\n\n\n\n- \u2022 Java\n\nAdministrative task scheduler (optional)\n\n\n\n- \u2022 Overview\n- \u2022 Routines\n- \u2022 Scheduling features\n- \u2022 Life cycle\n- \u2022 Syncronization\n- \u2022 Commands","summary_plain":"This course provides students with an introduction to the skills and knowledge needed to administer a Db2 12 for z\/OS system.","skill_level":"Beginner","version":"1","duration":{"unit":"d","value":3,"formatted":"3 jours"},"pricelist":{"List Price":{"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":2400},"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":2100},"FR":{"country":"FR","currency":"EUR","taxrate":19.6,"price":2250},"SI":{"country":"SI","currency":"EUR","taxrate":20,"price":2100}}},"lastchanged":"2025-07-29T12:17:56+02:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-course-schedule\/19516","source_lang":"fr","source":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-course\/ibm-cv853g"}}